ORA-12203 error in ODBC connection

G

Guest

Help! I have searched the net for a solution for this one to no avail.

I have a DSN: SPDDBD02 that I can connect to through 32bit ODBC test and
also from VB but I can't connect through MSAccess when attempting to link a
table.

The server name has recently changed and up until then I could connect but
when I updated the tnsnames.ora file with the new server name and updated the
DNS names in the data sources tool I can no longer connect from Access. I
can use Access to connect to other Oracle data sources but not this
particular one. Again, I can connect through any other method except through
linked tables in MSAccess.

I know that the entry in the data sources tool is correct and I know that my
method of connecting from Access is correct. I heard something about Access
caching the old connection settings and reusing them even though the tnsnames
file has been updated with new connections? I have made sure that connection
pooling is turned off. Is there something else I can do? I have MDAC 2.8
installed.

The error is:

[Microsoft][ODBC Driver for Oracle][Oracle] ORA-12203: TNS: Unable to
connect to destination, Driver's SqlSetConnectAttr failed IM006 0, etc...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top