10. Create an ODBC connection to your shared repository database | Questionmark

10. Create an ODBC connection to your shared repository database

Applies to the following products: 
Questionmark Perception
Applies to the following Perception versions: 
Perception 5.7

Now, you need to create an ODBC data source to link Perception to the shared repository database you created in step 1 so that the Shared Repository Service can correctly use it.

The ODBC connection needs to be created on your Perception Application Server server.

You will need to use the 32-bit version of ODBC drivers.

The sections below provide details about creating the ODBC connections for the following database systems:

SQL Server 2008 R2

To create an ODBC data source:

  1. Open the ODBC Data Source Administrator on the same server on which you plan to install Perception as an administrative user.

    To do so, navigate to and launch the following ODBC driver:

    • C:\Windows\SysWOW64\odbcad32.exe

  2. Open the System DSN tab
  3. Click Add...
  4. Select the SQL Server driver for your SQL Server instance and click Finish
  5. Enter a name for the new data source, and select the server you want to connect to (that is, the machine on which your database is installed, i.e., your database server) from the drop-down list. Make sure that you enter the actual server name and not "(local)" or "localhost."
  6. Click Next
  7. Ensure that With SQL Server authentication using a login ID and password entered by the user is selected

  8. Enter the ID and password of the login you created for the Perception database (in step 1) and click Next

  9. Enable the Change the default database to check-box and select your Perception database (i.e., Perception_REPO) from the drop-down list and click Next

  10. Click Finish. Review the details of the new ODBC data source that will be created and click OK.

    You can click Test Data Source to check the connection.

  11. Click OK to close the ODBC Data Source Administrator

You can now begin to install Perception. Follow the link at the bottom of this page to continue to step 8.