Creating ODBC Data Source (Windows plans)

Article Details
URL: http://www.mochasupport.com/kayako/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=464
Article ID: 464
Created On: 29 Nov 2008 09:44 PM

Answer

To install a new ODBC driver, creating a connection to an external database:

 

  1. Go to Server > ODBC Data Sources.

  2. Click Add New ODBC DSN.

  3. Specify the ODBC connection name and description in the corresponding fields.

  4. Select the required driver in the Driver field.

  5. Click OK.

  6. Choose the appropriate options on the driver configuration screen. Typically, you should specify the path to the database, user credentials and other connection options, depending on the selected driver.
Click Test to check whether the connection will function properly with provided settings. Click Finish to complete the creation.