Space banner This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

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.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*