>>create File DSN and open it in any text editor.
>
>???I don't think I know where to look for it?
>I'm still using VFP database, and will be converting to SQL server in the future. Where can I find a connection string for VFP database?
>
You can create File DSN, open it in any text editor and copy into connection string. There's a working example from my PC for free tables in h:\Temp directory.

lcConnStr = "DRIVER=Microsoft FoxPro VFP Driver (*.dbf); " + ;
			"UID=; " + ;
			"Deleted=Yes; Null=Yes; Collate=Machine; " + ;
			"BackgroundFetch=No ; " + ;
			"Exclusive=No; " + ;
			"SourceType=DBF; SourceDB=h:\Temp; "
lnConn = SqlStringConnect(lcConnStr)