sql server dts: SSIS fails to connect to Oracle -- sql server dts

SSIS fails to connect to Oracle

TheMadTexan
7/7/2006 4:47:02 AM

sql server dts:

I have SSIS with SP1 installed. I also have the Oracle 10g client installed.

When I attempt to create a data source in an SSIS project for an Oracle
database, testing the connection returns "error initializing the provider ...
TNS error - no listener".

However, if I create a UDL file and specify the same OLEDB provider as I did
in SSIS and the same Oracle system - the connection test works fine (in the
UDL dialog - not in SSIS).

Any ideas on where I should look next?

RE: SSIS fails to connect to Oracle

TheMadTexan
7/7/2006 10:15:02 AM

Found it.

The Oracle client will always look first in your current working directory
for a TNSNAMES file - not in the default location (ADMIN directory).

I had an outdated TNSNAMES file out on a network drive which just happened
to be my working directory at the time I was testing.

One more chapter written in the "man do I hate Oracle" book....

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.