Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Server Alias-Less connection
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00671908
Message ID:
00672336
Vues:
12
>What do you mean that you need "to configure sql server client and register the server alias" ?
>
>With a DSN-less connection you shoudn't need to do anything in the workstation to have it connect to the server.

Hi Hector.
Maybe i did not grasp the concept of DSN-less connection to the full. But i don't use DSN for connecting.
So far there was the following routine. I install SQL Server client on a workstation, then configure the client for connection to the server (defining network protocol and creating SQL Server ALIAS on the workstation), then install my app with the connection string which contains the ALIAS of the SQL Server.
App can not connect to the server without naming sql server ALIAS in the connection string.
Users don't really need sql server client on their workstations.
The best option is to install a SQL Server ODBC driver and define the workable connection string in such a manner that it would contain only the reference to the driver.
Kamil.
A moment of silence is our cosmic reset button.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform