SQL Server with ODBC connection

SQL Server with ODBC connection

To create an ODBC connection (System DSN) follow the general procedure for SQL Server 2008/2012/2014 and then proceed as follows:

1. Open the window ODBC Data Source Administrator and select the System DSN tab.
2. Click Add and select the SQL Server driver from the list, then click Next .
3. In the window that opens enter the name for the data source (for example, bcmdb ), select the SQL Server to which to connect and click Next .
4. Select the authentication type Windows or SQL Server and click Next .
5. Select the previously created database (for example, bcmdb ), click Next and then Finish .
6. In the window that appears click Test Data Source to verify the connection.