>>>VFP doesn't use ODBC drivers anymore, it uses OLEDB drivers (sorry for the confusion).
>>
>>Speak for yourself :). I use ODBC drivers every day, daily, and (just in case) on a daily basis (switching to hourly as needed).
>
>Which version of VFP? 'Cuz I couldn't find anything out there for ODBC past VFP6.
Same as yours. Nothing much changed since VFP6, the stuff still works. We only get new drivers for newer versions of SQL... presently, my connection string looks like this:
DRIVER=SQL Server Native Client 10.0;UID=myusername;Trusted_Connection=Yes;pwd=blabla;AutoTranslate=No;WSID=ZMYCHECK5;database=donna;APP=FixMe0.99;SERVER=ZMYCHECK5\SqlE7;