>>By any chance did you upgrade to windows 7 64? if so you need to run C:\Windows\SysWOW64\odbcad32.exe to create the DSN
>
>The DSN creates just fine, no problem. The problem is getting a connect string that works or using the DSN with sqlconnect(). I have VFP apps running fine under 64bit Win 7, but this machine fails. It's running 32 bit Win 7 enterprise by the way.

Hugo is absoilutely correct. Make sure to run the version of odbcad from Sys/Wow64 folder. DSN created regularly will not work with VFP.