You can now test the newly created DSN from any ODBC-enabled Windows application. You can also test by using the Micro Focus XDBC query tool. If you have loaded the sample database on the remote server, you can select from the PETS sample data file to verify your setup.
Upon successful installation and setup and any other required software from the database provider, clients should now have access to the remote database in the manner that was intended by the database provider or designer. This might include access through use of Microsoft Office applications such as Access or Excel, or through a customized application, or from the XDBC query tool. Chapters Using the Command-line Query Tool, Supported SQL Commands, and Working with Windows and Java Applications provide instructions on accessing databases from Microsoft Office and the XDBC query tool.
To test using the Micro Focus XDBC query tool:
cd C:\Program Files\Micro Focus\XDBC Client 2.0\bin
mfsql -s host [-n port#] [-u user] [-p password]
SELECT * FROM PETS;