469,954 Members | 1,780 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,954 developers. It's quick & easy.

Access97 to Oracle8i odbc-problem (SQLSetConnectAttr failed)

In an Access97 application I fetch data from an Oracle database via a
linked table (via Odbc/sqlnet). The Oracle database now upgrades from
7.3 to 8.0. The Oracle odbc driver I use (2.0.3.1, supplied with 7.3)
always worked fine on all Nt4 workstations. Now with the 8.0 db an
odbc error occurs when the db is contacted: [Oracle]{ODBC Oracle
Driver][Oracle OCI]ORA-01034: ORACLE not available. (#1034)
[Microsoft][ODBC-Driver Manager] SQLSetConnectAttr of the device
driver had failed.

On a standard win2000 pc, and a Xp pc everything works fine. One
tested Nt4 workstation it works fine... but on the others it won't. I
already tried installing different Mdac's, 2 different Oracle odbc
drivers, and read a few Ms-KBase articles about related problems, but
the problem is still there. Can't tell the difference between the one
Nt4 pc that functions allright and the others. Does someone have a
hint ??
I will try to use the odbc-driver for Oracle 8i (in the hope that will
work) but it would be much easier in my situation if an older driver
that's also userd for 7.3 databases could be used (and it can work
allright as proven on the one pc!).

In http://support.microsoft.com/default...NoWebContent=1
I found that the problem might be the fact that it's just an
informational message that may be ignored. Okay when scripting via ADO
but how to deal with it when using Access linked tables ?
Nov 12 '05 #1
0 2805

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by the_rev_dharma_roadkill | last post: by
2 posts views Thread by Andreas Lauffer | last post: by
reply views Thread by Rebecca | last post: by
1 post views Thread by John | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.