Information générale
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement