HP MPE/iX 6.x Operating System manual Using Microsoft Odbc Test 32-bit, To run ODBCTE32.EXE

Troubleshooting ODBCLink/SE Reference Manual

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”.

	ODBCLink/SE
56	©M.B. Foster Associates Limited 1995-2000