SQL Server Connection String Properties Connection Property Description A5API Each of the properties are described below. The SQL Server connection string dialog has tab pages for general properties, timeouts, SSH tunneling, and advanced properties. SQL Server Version Client Driver Name 2017,2019Ĭonsult the documentation for Microsoft SQL Server for more information about downloading and installing client drivers. You may need to update your client driver from time to time as updates are made available from Microsoft.Īgain, the client driver name is the one that you want to match the database version.Īs of this writing the following client drivers are available for the various versions of the SQL Server database. It is independent of the database server version. The version that you see in the Microsoft ODBC administrator dialog is for the client driver of that name specifically. The list below shows the database version and the recommended driver for that database.
SQL SERVER CONNECTION STRING PARAMETERS INSTALL
If you do not install the version of the ODBC driver Microsoft recommends for your database, you may be able to connect, but you could get errors or unexpected results when executing SQL. The values you select will be generated into the connection string at the top of the dialog for you as you make changes. Select the version of your database, enter the server name and provide any authentication information required to connect to your database. When you select SQL Server as your connection type in the connection string dialog, the dialog below will be displayed.
Using the SQL Server Connection String Dialog In the connection string dialog, select the version of the database you are connecting to.Īlpha Anywhere will select the installed driver that is the best fit for the target version. You must first install the appropriate driver for the version of your SQL Server database.