| Oracle OLEDB provider tnsname connection error [message #67035] |
Thu, 12 June 2003 03:48  |
sorin
Messages: 3
Registered: October 2001
|
Junior Member |
|
|
Hi all,
I have a Oracle 9.0.1.0 client configured to use OracleNames (ONAMES) to connect to a remote Oracle 8.1 server.
My pc runs winXP.
I want to use Oracle OLEDB Provider because Microsoft's drivers have some problems retrieving data.
I configure a connection (e.g. UDL file) to point to my server. I click on "test connection" once and it works. If I click a second time I got a "TNS Name not found" error from Oracle.
sqlplus is working properly. I noticed that after the first called the OCI remains loaded, killing the process will result in a second successfully connection to server.
Further more, if I change ONAMES to TNSNAMES the connection works fine.
Microsoft OLEDB provider for Oracle is connecting in both situation but is not working :(
Obviously I want to use ONAMES because the solution is to be deployed to a big number of client PC...
Is there a known issue with Oracle OLEDB provider and ONAMES solution?
Thank you
Sorin
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
