Can any one tell me what the connection string is for useing free
foxpro tables with ado. When I connect I allways get the error.
"[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"I want to use a DNS-less connection and the Microsoft Data Link file
but all I get is the message I even tryed a DNS connection and still
the same.
My connection string is:
"Provider=MSDASQL.1;Password="";Persist Security Info=True;Extended Properties="DSN=Visual FoxPro Tables;UID=;PWD=;SourceDB=C:\DATA\;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;"
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers