Re: ODBC - Access 2.0

[Gary L Peskin <garyp@xxxxxxxxxxxx>]

The -77xx errors from Access indicate that the ODBC driver called by
Access does not conform to the ODBC standard.  Specifically, -7761 means
that when access issued the SQLGetInfo(SQL_OUTER_JOINS), the return
value was not 'Y' or 'N' as required by what Access 2.0 things the
standard is supposed to be.

I believe the new ODBC drivers return "F" indicating "Full support",
hence the error.  This *is* a supported value per ODBC 2.0.  Access was
just not current with the standard.

To find out if you have an older version of Access 2.0, go into file
manager and find the jet engine:  msajt200.dll.  Then, select file |
properties.  If the version is earlier than 2.50.1606, you can download
the Access service pack which might correct this problem.  It is at 

http://support.microsoft.com/download/support/mslfiles/Accsvc.exe

HTH.  Please let us know.

Gary
Scott, Shadrach wrote:
> 
> Hi,
> 
> I am testing the new Enhanced Client Access for win 3.1. The ODBC driver
> works fine with the database access tool that is provided with Client
> Access. When I uses ODBC with Microsoft Access 2.0 it retrieves the
> tables list fine but when I try to import a table I get an "ODBC
> Specification Conformance Error[-7761]." I am using TCP/IP with OS/400
> V3R7.
> 
> Any Ideas?
> 
> Thanks,
> Shadrach Scott
> sscott@hiu.edu
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---