PIERCGG
asked on
Attempting an ODBC/DSN connection to Oracle
We have a Windows 2000 server running IIS application server and running Oracle 8.1.7. On my local
machine I am running Windows 2000 and UltraDev 4. When I try to set up a DSN connection, I am getting
the following error message from UltraDev:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS: could not resolve service name.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.
In the DSN setup on my local machine, I have defined the following:
Data Source Name: TEST_FLTPROJ
User Name: TR/<password>
Server: IMAPTIS@MAP3.MSFC.NASA.GOV
IMAPTIS is the name of the ORACLE instance
TR is the table name
Where <password> is shown, I entered the actual password which I do not want to post here.
Where is my problem? What have I not gotten right?
In my TNSNAMES.ora file, the IMAPTIS strings are defined correctly. I can get into the Oracle database
from my machine via SQL*Net but not using the ODBC connectivity.
machine I am running Windows 2000 and UltraDev 4. When I try to set up a DSN connection, I am getting
the following error message from UltraDev:
[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS: could not resolve service name.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.
In the DSN setup on my local machine, I have defined the following:
Data Source Name: TEST_FLTPROJ
User Name: TR/<password>
Server: IMAPTIS@MAP3.MSFC.NASA.GOV
IMAPTIS is the name of the ORACLE instance
TR is the table name
Where <password> is shown, I entered the actual password which I do not want to post here.
Where is my problem? What have I not gotten right?
In my TNSNAMES.ora file, the IMAPTIS strings are defined correctly. I can get into the Oracle database
from my machine via SQL*Net but not using the ODBC connectivity.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That was it. Thanks you.
sora