Hi. We've got a SQL Server 2000 DTS package that needs to read/write to an
Oracle 9i database. We're pulling our hair out and can't figure out how to
do it. We've installed the Oracle Client Tools on the SQL Server database
machine and on the workstation of the developer, but it's giving errors:

Error Source : Microsoft OLE DB Provider for ODBC Drivers

Error Description : [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve
service name

We're using the same TNSNames.ora file on the workstation that we've got on
other system, but that one machine refuses to allow the connection to be
created. Help!

We believe we found the answer: After changing the TNSNames.ora file, it
worked.

"dw" <cougarmana_NOSPAM_ (AT) uncw (DOT) edu> wrote