Importing an SQL Server Database using an OLE DB Provider
CAUTION:
This direct OLE DB connection to SQL Server only works with SQL Server 7.0 or later.
SQL Server documentation may use the word "database" for the word "catalog."
1. Click the Import button in the CONNX Data Dictionary Manager window.
2. Select SQL Server from the Import Type list box in the Import CDD dialog box.
3. Select OLE DB Provider under Select Provider Type, and then click the Select Provider button.
4. Select the Provider tab, and then select the desired OLE DB Provider for SQL Server.
5. Click the Next button to return to the Connection tab.
6. Enter a server name in the Select or enter a server name textbox on the Connection tab.
Important:
Opening the list box uses the SQLOLEDB Enumerator, which attempts to make network calls.
7. Enter a user name and password.
8. Select a catalog from the list box in Item 3.
SQL Server loads the selected catalog automatically. Click the Test Connection button to verify that the SQL catalog is available. If Item 3 is left blank, the user's default catalog is used.
If you have unattached SQL database files (consult SQL Server documentation), you may reattach the database file as a catalog by selecting Attach a database file as a database name. The system mounts that database file and uses it as the current catalog.
9. Click the OK button.
The Import CDD dialog box appears. Reenter the SQL password, if required.
10. Enable the following if you want and click the OK button.
Normally, only user-defined tables can be selected for import. Select the Include System Tables check box to enable the import of non-user-defined tables.
Select the Get Statistics check box to identify the table sizes. This is used by CONNX query optimization.
11. To import all of the tables in the database, click the Add All button. To import some of the tables in the database, select the tables to import, and then click the Add button.
12. Click the OK button to import the selected catalogs into CONNX.
The imported catalogs appear in the list of accessible objects in the CONNX Data Dictionary Manager window.