>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.