on 01-20-2010 9:12 AM
When trying to connect to an Oracle 10g DB via the native driver, I get an "Unknown Database Connector Error".
Using the same credentials with the OLEDB driver, my connection attempt is successful. Am I doing something wrong?
I checked the version of crdb_oracle.dll, which is 12.2.3.467 . There are some dlls that have the same version, but many others have other versions with 12.1.0.882 and 12.2.0.290 occurring most often.
Hello,
Is the Oracle \bin folder in your PATH statement? As a test can you create a DSN to the Oracle server, test the connection also. I use the ODBC DSN test to verify the client install and PATH is configured properly.
I suggest you re-install SP2, try doing it from the Add/Remove Programs and use the Repair option to see if that updates the dll's.
Important ones are crqe.dll, querybuilder.dll and crdb_oracle.dll, they should all be the same version.
Thank you
Don
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The bin folder of my oracle installation is in the system-wide path statement. I also successfully created an ODBC System DSN via the Microsoft ODBC Administrator.
Using the ODBC driver for a connection however fails as well: "Internal error - unable to initialize NLS during driver load".
The native connection still does not work. Any more ideas?
What finally resolved my problem was the installation of the latest [Oracle Data Access Components|http://www.oracle.com/technology/software/tech/windows/odpnet/index.html ] .
Now I can make a connection via the native driver.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.