Kbase P114094: How to get a list of database tables in ODBCtest.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/03/2006 |
|
Status: Unverified
GOAL:
How to get a list of database tables in ODBCtest.
GOAL:
Will ODBCtest list the tables in a database?
GOAL:
How to run ODBCtest.
FIX:
1. To run ODBCtest, click on the executable odbcte32.exe.
2. To connect, press the button showing 2 hands shaking. You will be prompted with your list of data sources. Select the data source for the Connect ODBC Progress driver version 4.1 and press the OK button. A login box will appear. Enter your database user id and password, then press the OK button. A window should appear which is divided in half. In the lower section, you should see the words "Successfully connected to DSN?<data source name>
3. From the main menu, select Catalog->SQLTables. In the SQLTables dialog box, clear out the value in the TableType field and type the word "TABLE". Press the OK button. You should see the SQLTables function executed and the return code SQL_SUCCESS=0 displayed.
4. Press the button immediately to the right of the red exclamation point, you should get a table list back.