|
Home > Archive > MS SQL Server DTS > March 2006 > Connect DTS to Oracle database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Connect DTS to Oracle database
|
|
|
| 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_@u
ncw.edu> wrote in message
news:u$htHvdUGHA.5004@TK2MSFTNGP11.phx.gbl...
> 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!
>
|
|
|
|
|