Hi,
I am having problem creating a connection to Oracle database using DTS
designer.
We have Oracle 9i on a Linus box. I installed oracle 8i client for windows
on the SQL Server box ( we don't have the 9i client). I configured the
tnsname and listener and tested ok. I am able to run the SQLPlus from the
client machine and can run connect to the oracle database to run querries.
The problem is when I use the DTS I am not able to connect. I get the
message:
"ORA-12514: TNS: Listener could not resolve the SERVICE_NAME given in the
connect decriptor."
Please I need your help.

Thanks.

Egbon.