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

8. 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 7 so that the Shared Repository Service can correctly use it.

The ODBC connection needs to be created on the same server on which you plan to install Perception.

You will need to use the 32-bit version of ODBC Data Source Administrator.

SQL Server

To create an ODBC data source:

  1. Open the 32-bit 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 7) and click Next.

  9. Enable the Change the default database to checkbox 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 9.