ODBC Error SQL 6.5/Access 97 
Author Message
 ODBC Error SQL 6.5/Access 97

 We keep getting the following errors when using Access 97 with SQL Server

ODBC  update on a linked table <table> failed. (Error 3157)
*  What causes the link to drop when you are connected to the DB?  Is there
some settings that need to be adjusted?

ODBC call failed. (Error 3146)
* I have seen this posted in the News Group, and it seems to be a fairly
popular error.  Does anyone have any Ideas where we can get more information
on how to narrow down the problem?

Reserved error <Item>; there is no message for this error. (Error 3000)
*  This is another error description that does tell us a whole lot.  It also
returns different neg. numbers like:
Are these of any significance?  Does anyone know where we can look to get
more information on the reserved errors?

Any information/resources or direction would be greatly appreciated.


Wed, 05 Apr 2000 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Access 97 ODBC to SQL 6.5/Sp4 error 3156

2. ODBC Error Treatment after upsizing Access 97 to MS SQL 6.5

3. Linked Table between SQL 6.5 and Access 2.0 or Access 97 through ODBC

4. Use link ODBC to replicate tables SQL 6.5 to database Access 97

5. access 97 -> sql server 6.5 via odbc

6. ODBC timeout when connecting from ACCESS 97 to SQL Server 6.5 (heavy loaded server)

7. ODBC on SQL 6.5 and Access 97 remote clients

8. Connecting to SQL Server 6.5 with MS Access 97 via ODBC

9. Connecting to MS SQL Server 6.5 via MS Access 97 and ODBC

10. Cannot access SQL Server 6.5 SP4 databases via Access 97

11. MS ACCESS 97/SQL server 6.5: deadlock problems when accessing server tables

12. Import Access 97 data into SQL Server 6.5 using Transac-SQL

Powered by phpBB® Forum Software