Access 2 to Oracle database via ODBC reports error -7751 
Author Message
 Access 2 to Oracle database via ODBC reports error -7751

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



Sun, 25 Feb 2001 03:00:00 GMT  
 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



Sun, 25 Feb 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Crystal Reports - Access Database via ODBC - Patternmatching

2. Reserved Error -7751?

3. VB3: Reserved error (-7751)

4. Reserved error (-7751)

5. Help!! VB3: Reserved error (-7751) on OpenDatabase() via ODBC

6. compiled reports on queries (Oracle via ODBC)

7. Oracle Date fields via ODBC in Crystal Reports

8. Opening Oracle 7.3 database via ODBC in VB4

9. How do I get data from an Oracle database via DAO/ODBC on excel7

10. How I update ORACLE 7.2 database from Visual Basic 4.0 via ODBC

11. Opening Oracle 7.3 database via ODBC (16bits) with VB4 16-bits development environnement

12. Help: Excel VB accessing Oracle via ODBC

 

 
Powered by phpBB® Forum Software