Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting from VFP to 64 bit SQL Server
Message
De
26/02/2015 16:51:38
 
 
À
26/02/2015 15:23:40
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01615893
Message ID:
01615897
Vues:
50
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform