You should use SQLSTRINGCONNECT() in this case.
Do you have VFP ODBC driver on the PC?
Keep in mind that VFP ODBC driver does not support any new features introduced after VFP6SP5.

>
>I tried this
>
>

>CLEAR
>
>sDatabase = "C:\Projects\mydatabase.dbc"
>sConnString = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB="+sDatabase+";
Exclusive=No; NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;"
>
>iHandle = SQLCONNECT(sConnString, .T.)
>
>IF iHandle > 0
>
>	? "Connect"
>	
>	SQLDISCONNECT(iHandle)
>
>ELSE
>
>	? "Unable to connect"
>	AERROR(aErrInfo)
>	? aErrInfo[1]
>	? aErrInfo[2]
>	
>	_cliptext = aErrInfo[2]
>	
>ENDIF
>

>
>I got "Connectivity error: [Microsoft][ODBC Driver Manager] Data source name too long"
>
>I got the connection string info from http://www.connectionstrings.com/?carrier=visualfoxpro