Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odbc
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Re: Odbc
Divers
Thread ID:
00176409
Message ID:
00176412
Vues:
34
>Does the Windows NT Server with SQL Server running on it use ODBC or does only the client computer use ODBC?
>

SQL Server doesn't talk to itself via ODBC; ODBC (as well as things like DAO, RDO and ADO) is used for other processes on the same machine, and for remote machines, to talk to SQL Server. IOW, if you have an NT Server running SQL Server, and another process, say a VB application running on the same box, would use an ODBC or ADO connection to talk to SQL Server, just like any other SQL Server client. the fact that it runs on the same physical machine doesn't change the interface.

>Is it a problem if the server has an older version of the SQL ODBC driver than the client?

The ODBC driver is invoked client side, not server side; an older ODBC client on one machine shouldn't have an effect on another machine's access.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform