Cannot Connect to Oracle 9i from Access via ODBC

[dpatrickcollins]

I am attempting to connect to a Personal Oracle 9i database from Access 2002 using ODBC. The data source is configured correctly and tests successfully. However, when I try to link an Oracle database table, I receive the following Oracle Error message via ODBC:

ORA - 12545 Connect Failed because target host or object does not exist (#12545) Driver's SQLSetConnectAttr failed (#0)

Please note that I cannot establish the odbc connection via code, either. I AM able to connect to an Oracle 8.x database (running on a remote server) via code and via GET EXTERNAL DATA>LINK TABLES. Lastly, I am able to connect successfully using Visual Basic 6.0 with the same code.

Any assistance would be HIGHLY appreciated.

 

[sem]

This error may mean that you specified incorrect HOST (or it can not be resolved by DNS). This may be due to using default domain suffix or a typo or anything else. Try to specify IP explicitly.

Regards, Dima

 

[dpatrickcollins]

Thanks, Dima. Could you give me the syntax for specifying an IP address? I did not see this listed as one of the options when connecting programmatically.

BUT I did stumble upon a solution. I left the server name field blank (when connecting via table linking; I did not try it programmatically). And voila! I got connected. So something is definitely happening per the server name. (Keep in mind the Oracle server is located on the same machine.)

 

[sem]

No specific syntax: just specify an address instead of DNS name. Obviously by default localhost (127.0.0.1) is used.

Regards, Dima