Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting from VFP to 64 bit SQL Server
Message
From
26/02/2015 17:10:25
 
 
To
26/02/2015 16:51:38
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01615893
Message ID:
01615900
Views:
33
>>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.

Thank you, Al.
Yes, I was aware of syswow64.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform