General information
Title:
VFP 7 ODBC error connecting to Access 97 .mdb
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only