Easysoft JDBC-ODBC Bridge Web Administrator

Version &job_version;

Statistics
Configuration
Demo
Security
Information

Data Access by Easysoft

The Java applet shown above retrieves data from any ODBC System Data Source (DSN) hosted on this server. The DSN can use any third party ODBC driver and be configured to access a local or remote database.

This applet uses the Swing graphics interface, this may not function as expected on Microsoft operating systems. If this problem is encountered use the AWT demo instead.

In this example the Java applet is running on the same server as the DSN and ODBC driver. However, the Easysoft JDBC-ODBC Bridge is a Type 3 driver which means the Java applet or application can run on any remote device which can communicate with the Easysoft JDBC-ODBC Bridge server via TCP/IP. The client component of the Easysoft JDBC-ODBC Bridge is 100% Java. This is a major advantage over other solutions, such as the Sun JDBC-ODBC Bridge, which require a DSN and driver to be installed on every device.

Connecting to a data source

Enter a valid username and password for the target server and click the Connect button. This will display a dialog Window with a drop-down box containing a list of the System Data Sources available. Pick the DSN you wish to access and (if required) enter a valid name and password for the target database. Click the Connect button to display a list of the available database tables. Double-click on any table name to retrieve up to 100 rows of that table. Note that the number of tables and rows displayed is specified in the JDBC URL as connection attribute :limit=100. If you change this or any other element of the connection string remember to press the Connect button again for the changes to take effect.

You can now run ad-hoc queries by typing SQL-92 statements in the SQL box and clicking Submit.

Unicode

The correct display of 16-bit Unicode characters is dependent upon the configuration of your browser.

Netscape users require Version 4.5 or above.

The applet tag used is as follows: