Attempting an ODBC/DSN connection to Oracle
Posted on 2002-05-06
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>
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.