Testing AcuXDBC connection with AcuXDBC Server without a 3rd party application



Is there a way of testing AcuXDBC's connection with AcuXDBC Server without using a 3rd party application?


This is possible.  On the client machine open a command prompt and navigate to the AcuGT\bin directory.  Type:

odbcsql.bat -d "DSN-NAME"

where DSN-NAME is the name specified for the dsn in the Data Source Administrator.

This directly queries AcuXDBC Server that the DSN-NAME points to.  Assuming that the sample data was used during the creation of the system catalog, at the odbcsql prompt type in a query to the database:

select * from pets;

This should return all of the rows from the sample pets table.

Old KB# 2835
Comment List
Related Discussions