>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.
Bob:
Make sure you have a recent VFP ODBC dreiver (does not come with MDAC anymore).
Check your ODBC connections (DSN( dialog and see the driver's version.
"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry