Oracle ODBC Link fails

[Laura]

Does anyone know how to connect an Access 2002 database to
an Oracle data source? Access is installed on a Windows
2000 Terminal Server. I have MDAC 2.7 installed on the
server. I'm trying to use the Microsoft driver for Oracle.

I get the following error: [Microsoft][ODBC driver for
Oracle]ORA-12154: TNS:could not resolve service name
(#12154) [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (#0) [Microsoft][ODBC Driver
Manager] Driver's SQLSetConnectAttr failed (#0)

I'd appreciate anyone's insight!

 

[Laura]

After doing more research, I think the problem is that the
Microsoft ODBC utility isn't seeing the tnsnames.ora
file... Again, I'd appreciate any help.

 

[Joe Fallon]

Never tried over a TS connection.
Is the Oracle client installed on the Server and can it see the db?

Locally:
The Oracle client tools need to be installed!
Then test connectivity using Oracle tools (SQL Plus, etc.)

Create an ODBC DSN using MS ODBC for Oracle and set ServerName to the Oracle
Service Name.

Now it should link fine.

Side Issue:
If Oracle 8i and 9i are on the same box there are 2 tnsnames.ora files and
it might pick the worng one.
My solution was to merge the 2 tnsnames files so it didn't matter which one
it read.
--
Joe Fallon
Access MVP

After doing more research, I think the problem is that the
Microsoft ODBC utility isn't seeing the tnsnames.ora
file... Again, I'd appreciate any help.

-----Original Message-----
Does anyone know how to connect an Access 2002 database to
an Oracle data source? Access is installed on a Windows
2000 Terminal Server. I have MDAC 2.7 installed on the
server. I'm trying to use the Microsoft driver for Oracle.

I get the following error: [Microsoft][ODBC driver for
Oracle]ORA-12154: TNS:could not resolve service name
(#12154) [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed (#0) [Microsoft][ODBC Driver
Manager] Driver's SQLSetConnectAttr failed (#0)

I'd appreciate anyone's insight!



.