Connecting To An ODBC Data Source

You can either select an existing ODBC data source or create a new one.

ODBC driver requirements

Your ODBC driver must be fully compliant with the ODBC 3.5 standard. ODBC Info is provided as a convenience by TIBCO. However, it is not supported by TIBCO.

To check the version of your ODBC driver:

  1. From Windows Explorer, open the ODBC Info utility, ..\Scribe\Utilities\odbcinfo.exe.
  2. From ODBC Info, click Data Source in the lower left corner. The Select Data Source dialog box appears.
  3. Click the Machine Data Source tab.
  4. Select the data source you want to check from the list of available ODBC data sources, and click OK. The Driver Information tab appears.
  5. If a password is required, a Login window appears. Enter the password and other required login information and click OK to log in to the data source and close the Login window.
  6. Confirm the Driver ODBC Version is 3.5 or later.

Selecting an ODBC data source

To use an existing ODBC data source

  1. In the Workbench, click View > Connections. The Connection Manager appears.
  2. On the Connection Manager, click New. The Add a Connection dialog box appears.
  3. Expand the ODBC Data Sources branch of the Data Sources tree and select an existing source.
  4. Click OK. The Connection Settings dialog box opens to allow you to optionally rename your connection, manage connection settings, or add scripts to run before or after this DTS.

    Note: Connection names can be up to 32 characters long.

  5. When you are done making changes to the connection settings, click OK to close the Connection Settings dialog box to return to the Connection Manager.

To define a new ODBC data source

  1. Select View > Connections. The Connection Manager appears.
  2. On the Connection Manager, click New. The Add a Connection dialog box appears.
  3. Select Add/Modify ODBC Data Source in the ODBC Data Sources tree and click OK to launch the Windows ODBC Data Source Administrator.
  4. Click Add to view the supported ODBC drivers.
  5. Select the ODBC driver you want to use for this data source.
  6. Follow the directions in the ODBC Data Source Administrator to create your data source. The ODBC Administrator enables you to define, modify, and remove ODBC data sources.

    Note: If you need help configuring ODBC, click Help in an ODBC Administrator dialog box, or see your ODBC driver documentation.

  7. After you define the data source, test it. If you have problems, troubleshoot the connection. 
  8. Click OK. The Connection Settings dialog box opens to allow you to optionally rename your connection, manage connection settings, or add scripts to run before or after this DTS.

    Note: Connection names can be up to 32 characters long.

  9. When you are done making changes to the connection settings, click OK to close the Connection Settings dialog box to return to the Connection Manager.

See also

Connections

Adding a Connection

Connection Settings Dialog

Creating DTS Files

Troubleshooting an ODBC Source connection