>What needs to be modified to the connection string to use it for a VFP database (as opposed to a free table?lcConnStr = "DRIVER=Microsoft Visual FoxPro Driver; " + ;
"UID=; " + ;
"Deleted=Yes; Null=Yes; Collate=Machine; " + ;
"BackgroundFetch=No ; " + ;
"Exclusive=No; " + ;
"SourceType=DBC; " + ;
"SourceDB=H:\Program Files\microsoft visual foxpro 7\Samples\Data\testdata.dbc; "
>
>How do I create a file DSN, and once created, how do I find it so that I can open it in text editor?In the Control Panel look for ODBC or Data Source (ODBC). When you create file DSN you can pick where to save it.
--sb--