on 04-04-2012 9:53 PM
I am trying to create a new connection to a test Oracle database (pTest). I go into the database expert > OLE DB (ADO) > > Microsoft OLE DB Provider for Oracle > enter my service, userID and password. This is the error message I get :
Logon failed
Details: ADO Error Code 0x80004005
Source: Microsoft OLE DB Provider for Oracle
Description: ORA-12203 : TNS: unable to connect to destination
Native Error: 12203 [database vendor code: 12203]
Now, the intesting problem is I can connect to the dev version of this database without any problems. (pDev). I was able to connect other test databases as well. I am not sure what I am doing wrong.
By the way, I can go into to Toad and connect to pTest, run queries, etc. etc.
Thanks in advance.
Hi Burak,
You can't use Microsoft's Oracle driver. They stopped support Oracle as of Oracle 7. Use Oracle ODBC or OLE DB Provider or download CR's Data Direct 5.3 drivers.
http://msdn.microsoft.com/en-us/library/windows/desktop/ms713590(v=vs.85).aspx
Then it should all work for 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 error is being passed from Oracle through the CR database engine unaltered. E.g.; have a look at Oracle documentation to see what the error means. I came up with the following:
ORA-12203: TNS:Unable to connect to destination
Cause: Invalid TNS address supplied or destination is not listening.
This error can also occur because of underlying network
transport problems.
- Ludek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.