Strange ODBC errors using DAO to access linked tables in Access .MDB 
Author Message
 Strange ODBC errors using DAO to access linked tables in Access .MDB

We have an MFC/DAO application which is encountering all sorts of trouble
accessing an .MDB file which links tables via an ODBC data source (SQL
Server 6.5).

The same tables and queries seem to work fine if run directly from Access
via the same MDB file, so I believe that the tables and links are all set
up correctly. The original .MDB file (prior to upsizing to SQLServer and
then linking the tables) also works great in both places.

Turning on ODBC tracing indicates that DAO/Jet is supplying an invalid
window handle to ODBC on the SQLDriverConnect call, but this happens only
intermittently and with only some of the queries. Has anyone seen anything
like this? Is there a workaround?

I'd be interesting in hearing from anyone who has successfully used the MFC
CDao classes to access ODBC data sources to any significant extent. VB's
VisData sample can access the .MDB file with the linked tables
successfully, but Stingray's DAO grid sample has problems accessing it.
This leads me to suspect the MFC/DAO interface, but I don't have enough
data yet.

Randy Baker (remove Z from address in email replies)

Sun, 16 Jan 2000 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. DAO, ODBC with an Access MDB

2. Where to get the ODBC error codes of Access mdb

3. Accessing description of Access Table through DAO

4. Problems with linked tables in Access through ODBC

5. Problem adding record to blank Access Table using DAO

6. Updating Access tables Using DAO with VC++

7. Accessing Paradox 5.0 (and below) tables using MFC/DAO

8. Updating or Inserting into an Access 97 table using ODBC

9. Lock Access Tables using ODBC in VC++

10. Creating tables in an access database using ODBC???

11. Is it possible to access Visual FoxPro5.0 tables directly from VC++ MFC(without using ODBC)

12. Error accessing access table


Powered by phpBB® Forum Software