ODBCLINK/SE Reference Manual (36217-90410)

Troubleshooting ODBCLink/SE Reference Manual
ODBCLink/SE
56 ©M.B. Foster Associates Limited 1995-2000
Using Microsoft ODBC Test (32-bit)
You can use ODBC Test to verify correct functioning of the driver and to enter ad-hoc SQL commands. ODBCTEST
and ODBCTE32 are part of the ODBC SDK that comes with the Microsoft Developers Network.
To run ODBCTE32.EXE:
⊗ Select Connect, Full Connect. You must enter a data source name, User-ID
and a password, and click “OK”. You should get a message “Successfully
connected to databasename”.
⊗ You can get a list of tables by selecting Catalog, SQL Tables, then click OK
and then Results, Get Data All.
⊗ You can enter an SQL statement, such as “Select * from tablename” in the
Query Window and then execute it by choosing Statement, SQLExecdirect
and view the results with “Results, Get Data All”.