>>Can the title be done?
>>I realize that VFP must use the 32 bit driver, but I can't seem to find out whether the 32 bit driver will connect with a 64bit server.
>>It sounds as if it can't but is that in fact the case?
>
>A 32-bit driver can connect to a 64-bit SQL Server.
>
>One thing to be aware of is if you're using ODBC Administrator ( odbcad32.exe ) to set up your DSNs, and you're doing it on a 64-bit workstation, then you need to make sure you use the one in \Windows\SysWOW64 rather than the default one in \Windows\System32.
I think M$ unnecessarily complicated things (as usual) by inventing DSNs as a roundabout way to store connectstring (or pieces thereof) in various locations and then giving it different names depending on the location (qv. at
http://en.wikipedia.org/wiki/Data_Source_Name). Kind of security by obfuscation, which is a way to secure misunderstanding by about 80% of programmers, specially as in most cases they don't really need to establish connection by themselves, teams usually have one person in charge of that.
I guesstimate that UT has, in these 18+ years, spent at least a few megabytes of space clearing this up from time to time. It's a theme set on a timer with a random interval.