
Access 2 to Oracle database via ODBC reports error -7751
Have you verified that all your Oracle stuff is installed correctly using
TNS Ping (to test the SQL-Net) and ODBC Test (to test, of course, the ODBC)?
If those test out OK, then the next question is: Have you installed the
Access 2.0 Service Pack? It's free, available from Microsoft. Check out
Dev's or Tony's page. Links provided on my page below.
This service pack has corrected a couple ODBC problems for us - as a matter
of fact, ones that didn't show up until we started hitting a 7.3.3 database.
So I hope it works for you.
--
HTH,
John Powell
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You can believe anything you want. The universe is not
obliged to keep a straight face.
This page contains links to many MS Access FAQ's and
resources (including places to post job related ads, which
do NOT belong here!).
http://www.wavefront.com/~pow/johnmsaccess.htm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Quote:
>Sorry if this is in the wrong group!
>Running on win 3.11
>Trying to attach some tables to an Access 2 database from an Oracle 7.3.3
database!
>Using the latest ODBC driver from Oracle's web site but keeps coming up
with error -7751 and no
Quote:
>description.
>What's funny is that when entering the connection details if I delibrately
enter the wrong password
Quote:
>Access reports this. If I enter the correct one is waitr a bit longer then
reports trhe above error
Quote:
>message
>It must be talking to the Oracle database to know that the password was
incorrect!
>Any ideas
>Thanks
>A.H
>Thanks in advance!
>A.H