Testing the Installation and Setup from ODBC

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:

  1. Open a command window.
  2. Go to the bin subdirectory of your install location:

    cd C:\Program Files\Micro Focus\XDBC Client 2.0\bin

  3. Start the XDBC command line query tool:
    mfsql -s host [-n port#] [-u user]
    [-p password]


    • -s host is the name or IP address of the host to contact. Since the XDBC Client only functions in a client-server mode, this is a required field.
    • -n port# is an optional port number if the server is started on a port other than the default of 20222.
    • -u user is an optional user name to log into the remote database as. The default is the authorization ID system.
    • -p password is an optional password to use when logging into the remote database. The default is manager.
  4. Execute a sample query to select data from the remote database. If you loaded the sample database, you can use the SQL command:
  5. Exit the command line query tool with the /q command.