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 16:51:38
 
 
To
26/02/2015 15:23:40
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:
01615897
Views:
51
>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.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform