Databridge Installation Guide > Setting Up a Relational Database > Setting Up a SQL Server Database > Create an ODBC Data Source

Create an ODBC Data Source

Use this procedure to set up an ODBC data source. If you have not created a new SQL Server database, and are not using an existing database, you must create a new database as outlined in the previous section. This database will hold your Databridge Client control tables and the replicated DMSII tables.

To create an ODBC Data Source

  1. Click Start > Settings > Control Panel > Administrative Tools. The Administrative tools dialog box opens.

  2. Double-click Data Sources (ODBC). The ODBC Data Source Administrator dialog box opens.

  3. Click the User DSN or System DSN tab. User DSNs are limited to the user who created them. System DSN data sources are available to all users of the computer and are required if you use the service.

  4. Click the Add button.

  5. In the Create New Data Source dialog box, select the Microsoft ODBC driver for SQL Server (recommended) or the driver SQL Native Client, and then click Finish.

    CAUTION:The driver SQL Server doesn't support columns longer than 32K, multi-threaded updates, and several other important Databridge features.

  6. In the Create a New Data Source to SQL Server wizard, name the data source (for example, databasenameDS). You will enter this name as the data source parameter value in the Databridge Client Configuration file.

  7. In the Server field, choose your local computer name, and then click Next.

  8. To connect to this data source, choose an authentication method, and then click Next:

    Integrated Windows Authentication

    SQL Server uses the credentials of the user currently logged in to validate the login. Most installations use Integrated Windows Authentication.

    NOTE:If you select this option on Microsoft SQL Server 2012 and are running the service using the default account, you must add NT AUTHORITY\SYSTEM to the sysadmin Server Role. In the Microsoft SQL Server 2012 Management Studio, use the left pane to navigate to Security > Server Roles , right-click sysadmin, select Properties, and click the Add button.

    SQL Server Authentication

    Databridge connects to SQL Server using the user ID/password pair specified in the Databridge configuration file.

  9. Click Finish to create the ODBC data source.