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;"