Re: 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Adrian Harrison wrote in message
<35f6c90b.587464_at_read.news.globalnet.co.uk>...


>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


>description.

>

>What's funny is that when entering the connection details if I delibrately

 enter the wrong password


>Access reports this. If I enter the correct one is waitr a bit longer then

 reports trhe above error


>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