>Hello all,
>
>I am trying to establish a DSNless Connection to a VFP DBC and I always get negative conn. handle indicating failure, I am using VFP 7 SP1 on Windows XP Professional and the same commands seem to work fine on Win 2K PC's which raises the likelihood of it being a driver issue.
>
>Is there something wrong with this syntax:
>
>**********
>cConnStr="Driver=Microsoft Visual FoxPro Driver;SourceDB=c:\dev\focus.DBC;SourceType=DBC"
>lnConnHdl=SQLSTRINGCONNECT(cConnStr)
>? lnConnHdl
>***********
>
>Any feedback is greatly appreciated.

The first thing I always try is to install the lastest MDAC files from Microsoft, www.microsoft.com/data. Which may or maynot help. To see what the latest version is on a PC you can do.

lo_MDAC = NEWOBJECT('MDACVer.Version')
? lo_MDAC.String
Mine prints 2.80.1022.3