Codebase Odbc Driver Download

by

This guide is aimed at Java developers who wish to add JDBC connectivity to their applications using the Easysoft JDBC-ODBC Bridge.

Mar 06, 2020  Microsoft ODBC Driver 17 for SQL Server is a single dynamic-link library (DLL) containing run-time support for applications using native-code APIs to connect to Microsoft SQL Server 2008. Codebase Odbc Driver Download. Is this connection string still valid and / or does it use a DSN to connect to the Access database? If it uses a DSN, have you.

  • Installing the JOB Driver Classes

Introduction

The Easysoft JDBC-ODBC Bridge (JOB) comes in two components:

  • The JOB Driver: a 100% Java JDBC compliant driver.
  • The JOB Server: a server built specifically for the platform where your target ODBC System Data Source is configured.

The JOB Server incorporates a lightweight HTTP server ('webserver') that provides access to administration, monitoring and test facilities through a standard web browser interface.

Assumptions

This guide assumes the JOB Server has been successfully installed and configured. You will also need to know the hostname for the JOB Server to which you intend to connect.

If you need to install the JOB Server refer to the Getting Started Guide.

Installing the JOB Driver Classes

The classes that make up the driver are in the Java archive file EJOB.jar. The driver class is easysoft.sql.jobDriver.

Java Applications

  • Download EJOB.jar (which can be found on the JOB Server machine at http://hostname:8031/jars/EJOB.jar if you used the default path for your installation) onto the client machine.

    On the client you must either amend or create the 'CLASSPATH' setting in the Environment Variables, which are found under Start > Settings > Control Panel > System > Advanced in Windows 2000 (this may vary with other versions of Windows).

    If 'CLASSPATH' already contains a value then you must add a semi-colon and then the full path and file name of your EJOB.jar file to the existing value.

    To add a new 'CLASSPATH' click on the Environment Variables tab, click New, enter 'CLASSPATH' in Variable Name and the full path and file name in Variable Value and click OK.

    Please note that you need to update either the User variables or System variables list as your application requires.

Java Applets

  • For applet deployment you are advised to place EJOB.jar with your applet in a directory readable by your full-featured web server and to add the appropriate ARCHIVE=EJOB.jar attribute within the APPLET tag on your HTML page. Ensure that you download EJOB.jar from your installed server pages. You can do this by right clicking on EJOB.jar.

    Example Applet Tag:

    Using ez.class to Make Applets Portable

    In the example above the jdbcUrl explicitly specifies the host on which the JOB Server is running. Applet restrictions dictate that an applet can only open socket connections to a machine from which they have been downloaded, so there is no browser independent way of determining where a jar file has been downloaded from.

    The Easysoft JDBC-ODBC Bridge includes a facility that enables a short form of the URL to be used, eliminating the need to specify the hostname in your applet tag or Java code. To achieve this the web server must be installed on the same machine as the JOB Server. Ensure the ez.class file is placed in the same directory as the HTML file that is used to run your applet or in the directory specified as the CODEBASE attribute in your applet tag. The driver will now attempt to discover the name of the host that it is loaded from and will attempt a connection to the default 8831 port.

    Example Applet Tag using ez.class:

    ez is a subclass of the easysoft.sql.jobDriver and as such it can be used as an alternative short name in interactive applications which require you to enter the JDBC driver class name. Instead of typing easysoft.sql.jobDriver, type ez.

    You will find ez.class in http://hostname/demo/ez.class.

Loading the JOB Classes

You can load the JOB Driver classes in your code using:

Alternatively you could use:

which in turn will instantiate the easysoft.sql.jobDriver class.

Connecting to an ODBC Data Source with the JOB Driver

To connect to an ODBC data source with the JOB driver, use a connection URL of the form:

where:

  • <hostname> (optional) is the name or IP address of the remote host on which the JOB Server is running.

    –Or–

    <hostname> is localhost or 127.0.0.1, or can be omitted if:

    • The Java applet was loaded from the same machine as the one on which the JOB Server is running.
    • The Java application is running on the same machine as the JOB Server.
  • <port> (optional) is the JOB Server port. The default is 8831.
  • <odbc-data-source> is the system ODBC data source you want to connect to. For example, MY-SYSTEM-ODBC-DATA-SOURCE, DSN=MY-SYSTEM-ODBC-DATA-SOURCE or FILEDSN={C:TempMY-ODBC-FILE-DSN.dsn}. Alternatively, specify a DSN-less connection string. For example, Driver={Microsoft Access Driver (*.mdb)};DBQ=C:Program FilesMicrosoft OfficeOffice1033Nwind2000.mdb.
  • <odbc-driver-attribute> (optional) is one or more connection string attributes supported by the ODBC driver.
  • <easysoft-jdbc-url-attribute> (optional) is one or more Easysoft JDBC URL Attributes.

Example URLs:

Easysoft JDBC URL Syntax

The JOB Driver uses the easysoft subprotocol. URLs for this subprotocol are of the form:

where separates optional items, [ ] denotes an optional item and { }* denotes zero or more occurrences.

Easysoft JDBC URL Attributes

northwind', in the same way as the Sun JDBC-ODBC Bridge.jdbc:easysoft:DSN=northwindEquivalent to the above.jdbc:easysoft:Connect to the host, but since no database is specified, a list of available DSNs will be presented in a dialog box.jdbc:easysoft:FILEDSN={C:TempNorthwindFileDSN.dsn}Connect to a file DSN data source, rather than a system DSN data source.jdbc:easysoft://:8899/northwindConnect to a non-default port.jdbc:easysoft://demo.easysoft.com/northwindConnect to the Easysoft JDBC-ODBC Bridge server at Easysoft.

Minimal Java Applet Demonstration

This is a very simple demonstration of an applet connecting to an ODBC data source using the Easysoft JDBC-ODBC Bridge. The APPLET tag used is shown here:

The CODE tag specifies the QueryApplet.class class file for the applet code.

The ARCHIVE tag specifies the './jars/EJOB.jar' Java archive file that contains the Easysoft JDBC-ODBC Bridge driver's classes.

The applet takes two parameters:

  • The jdbcUrl required to connect to an ODBC data source on the machine where the JOB Server is installed and from which this HTML page is served.
  • The JOB SQL pseudo-query to be executed on the specified data source.

You can view the source in HTML format. Download toca race driver 3 pc ita gratis.

When the page is loaded the applet is started and if the JOB Server is running it will popup a dialog box allowing a selection of available ODBC data sources to which to connect:

Upon successful connection, the result of running the pseudo-query tables is displayed: