Setting Up ODBC

Before setting up an external data source in the application you must set up the ODBC System Data Source Name (DSN) on the SmartSolve server.

NOTE: To define an ODBC data source you must nave the appropriate database driver installed.

Follow the steps below to define an ODBC Data Source.

In Windows, select Control Panel > Administrative Tools > Data Sources (ODBC).
Result: The System DSN tab is displayed.
Select the data source.
Result: The Delegate Setup window is displayed.

NOTE: The System DSN (Data Source Name) MUST be defined.

System DSN: Any application or user can access the database connection information.

User DSN: Only the user that creates the DSN can access the database connection information.

Click Add.
Select the SQL Server driver.
Click the Finish button.

NOTE: Make a note of the date source name, database, user ID and password that you set up. This information will be required to set up the SmartSolve application.

Specify the Name and Server values on the Create a New Data Source to SQL Server window.
- Name: Enter any value. This is the data source name that SmartSolve refers to.
- Server: Select the external database MS SQL Server.

Click the Next button.
Result: The following question is displayed: How should SQL Server verify the authenticity of the login ID?.
Select With SQL Server Authentication using a login ID and password entered by the user.
Select the following option (if it is not already selected). Connect to SQL Server to obtain default settings for the additional configuration options.
Enter the Login ID (User ID of the external database).
Enter the Password (Password of the external database).
Click the Next button.
Select the option labeled Change the default database to.
Select the applicable external database from the drop down list.
Click the Next button.
Click the Finish button.