i 'd like create a proxy server with SQL 10 but the connexion failed.

First test:
one DB sql9 with proxy server using the Microsoft ODBC for Oracle (PC
windows 2000). test OK.

Second test
one DB sql9 with proxy server using the Microsoft ODBC for oracle (PC
Windows XP pro Service pack 2); Tets OK

Last test
ON DB sql10 with proxy server using the same Microsoft ODBC for Oracle (PC
Windows XP pro Service Pack 2). No OK.

I receive this message
[Microsoft][ODBC fdriver for Oracle][Oracle]ORA-12154: TNS:could not
resolve service name

Why it's OK into second test and not into Last test?

Problem with SqlAnywhere 10?

Thank's

JCC

Two traces that might help:
1) and ODBC trace from the ODBC Driver manager
2) set the option CIS_OPTION to 7 in SQL10. This dumps a bunch of tracing
information when you access the proxy

--
/steve
Stephen Rice
Sybase iAnywhere

"jc" <jc.cuppens (AT) mouscron (DOT) be> wrote

Hello

i receive this message into sql AnyWhere 10 console:

Connect to 'tintin 172.30.0.241 2007-11-19 09:48:58.783' class 'oraodbc'
using 'persora'
ODBC error (01000). [Microsoft][Gestionnaire de pilotes ODBC] Le pilote ne
gère pas la version du comportement ODBC demandé par l'application (voir
SQLSetEnvAttr).
ODBC error (08001). [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154:
TNS:could not resolve service name

Sorry, but one part of this message in french.

Thank's

JCC

"Stephen Rice" <srice[at]sybase[dot]com> a écrit dans le message de news:
473dbc32$1 (AT) forums-1-dub (DOT) ..

"TNS:could not resolve service name" indicates that you have not
provided the correct information in the DSN to reference the service
(the Oracle database) that you want to use. Please post the content of
the DSN and the ORACLE server information (IIRC there is an TNS file
that holds this information ). Someone may be able to suggest what is
incorrect.



jc wrote:

with iAnywehere ODBC for Oracle outside ASA10 the connexion test is OK but
failed inside ASA10.


"Chris Keating (Sybase iAnywhere)" <keating_spam_free (AT) ianywhere (DOT) com> a écrit
dans le message de news: 474188ea$1 (AT) forums-1-dub (DOT) ..

it is helpful to get the messages that you are seeing when the problem
occurs. The message can help determine the issue for a problem that can
be manifested in many ways...

jc wrote:

Drop .world in the ODBC service name. .world only has context in the TNS
file AFAIK and I am somewhat surprised that it was able to work in 9.x
with that option. In my tests, I get a different error than you but both
errors basically indicate that the service name in the DSN is incorrect.

jc wrote:

i have dropped .world in ODBC service name but no change. Always the same
error. (Oracle 8i)

"Chris Keating (Sybase iAnywhere)" <keating_spam_free (AT) ianywhere (DOT) com> a écrit
dans le message de news: 4741e050$1 (AT) forums-1-dub (DOT) ..

Message with Ianywhere for oracle: (oracle 8i)

La connexion a échoué
La connexion au serveur 'perso 172.30.0.241 2007-11-20 10:38:00.580' n'a pas
pu être établie : [Microsoft][Gestionnaire de pilotes ODBC] Échec
SQLAllocHandle du pilote sur SQL_HANDLE_ENV
[Sybase][ODBC Driver][SQL Anywhere]La connexion au serveur 'perso
172.30.0.241 2007-11-20 10:38:00.580' n'a pas pu être établie :
[Microsoft][Gestionnaire de pilotes ODBC] Échec SQLAllocHandle du pilote sur
SQL_HANDLE_ENV
SQLCODE: -656
SQLSTATE: HY000
SQL Statement: DROP SERVER "perso 172.30.0.241 2007-11-20 10:38:00.580"

No problem with ASA9, only with ASA10


"Chris Keating (Sybase iAnywhere)" <keating_spam_free (AT) ianywhere (DOT) com> a écrit
dans le message de news: 4741dbc9$4 (AT) forums-1-dub (DOT) ..