Importing Tables from a Sybase ODBC Compliant Data Source
The CONNX Sybase module provides access to Sybase data source objects through the Sybase ODBC driver.
For multiple connections to Sybase via ODBC through a single CONNX Data Dictionary, either the Sybase data source name must be a file-based DSN and installed on a shared network server, or the same DSN must be configured on each client computer.
Important:
The selected data source driver must be installed on all client machines that have access to the data source tables since they will be using the same DSN (Data Source Name) as described in ODBC Data Source Names Used with Multiple Users.
The driver used to import table information must support ADO and be fully ODBC Level 2 compliant.
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select Sybase from the Import Type list box.
3. Select ODBC Provider under Select Provider Type, and then click the Select DSN button in the Logon Information pane.
4. Select a user, system, or file based DSN in the Select OBDC DSN dialog box and click the OK button.
We recommend you use a file DSN, because it can be accessed through a network by multiple users.
Your ODBC data source may require additional information. Review the documentation provided by your driver vendor for additional configuration options.
Click the Browse for File DSN button to open a file browser in which you can browse to a .dsn file.
Alernatively, mark the Show Only System DSN check box to view a list of system DSNs. Clear the check box to show a list of both user and system DSNs.
The ODBC Driver Information text box displays information about the selected ODBC DSN. The same information can be found in the ODBC Data Source Administrator dialog box.
Note:
Some applications, such as web servers, can only access system DSNs or file-based DSNs.
5. If you want, check the following boxes:
Include System Tables check box to access system tables.
Get Statistics check box to identify table sizes. This is used by the CONNX query optimization.
6. Click the OK button again.
The CONNX Import Table Selection dialog box appears with a list of available table names.
7. Click the Add or Add All button to move the tables to the Select Tables for Import pane.
8. Click the OK button to import the selected tables into CONNX.
The imported tables are added to the list of accessible objects in the CONNX Data Dictionary Manager window.