Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 7 ODBC error connecting to Access 97 .mdb
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
VFP 7 ODBC error connecting to Access 97 .mdb
Miscellaneous
Thread ID:
00756110
Message ID:
00756110
Views:
40
I've placed a connection in my .dbc and whenever I first grab data with it I receive the following errors:

Warning: The query timeout cannot be set.
Warning: The connection sync/async mode cannot be set.

Here are the specifics:

The connection in my project is using a system data source and has the following connection string:

DSN=Upload;DBQ=C:\Projects\Upload\DATA.MDB;DriverId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;

I have a connection timeout of 100, an idle timeout of 100, a query timeout of 15 and a wait time of 1000. I have ticked batch processing, automatic transactions and display warnings.

When I verify the connection I still receive the aforementioned warnings but the connection does succeed.

I am using MDAC 2.6 (SP2) with VFP 7.0 (SP1) on a Windows 2000 machine. My VFPODBC.DLL is version 6.1.8629.1 dated 12/7/1999.

Here are the specifics on the data source:
page timeout: 5
buffer size: 2048
DefaultDir:
Driver:
ExtendedAnsiSQL: 0
FIL: MS Access;
ImplicitCommitSync:
MaxBufferSize: 2048
MaxScanRows: 8
Page Timeout: 5
ReadOnly: 0
SafeTransactions: 0
Threads: 3
UserCommitSync: Yes

Any help would be greatly appreciated. Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform