jBASE ODBC Connector (jODBC)


jODBC Configuration

Package Contents

The ODBC Connector is included in jBASE 5.2 but may also be deployed on Windows operating systems which do not have jBASE 5.2 installed. A self-contained installer (from now on mentioned as jODBC installer) is available which installs and registers the ODBC driver. Below is the list of release packages containing the ODBC Connector:

 

  • jBASE 5.2 for Windows

  • jBASE ODBC Installer

 

 

The jODBC installer deploys the following files:

 

jodbc.dll jBASE ODBC Driver Library
libjODBCSetup.dll jBASE ODBC Setup Library
jODBCManager.exe jBASE ODBC Manager
ACE.dll ACE (Adaptive Communication Environment) Libraries
ACE_SSL.dll  
libeay32.dll OPENSSL Libraries
ssleay32.dll  
icuuc40.dll ICU (International Components for Unicode) libraries
icudt40.dll  

 

NOTE:  The ODBC installer copies the ODBC driver and setup libraries under the Windows\System32 directory.

 

 

ODBC Setup library is a separate library implementing the ODBC Setup API required by the driver manager to display graphical components such as connection dialogs. Connection dialogs enables users to configure DSNs inside Windows’ ODBC Manager (odbcad32.exe) or input connection details when requested by the driver.

 

jBASE ODBC Manager is a small console application used to register the ODBC libraries with the system, create/remove DSNs or test a connection to a remote jBASE instance. Please run

 

            jODBCManager –h

 

to obtain more information on how to use this utility.

 

 

Installing the driver

 

The ODBC installer will automatically register the ODBC driver and ODBC Setup libraries. The registration process is required to inform the ODBC Manager about the location of the ODBC driver libraries. The ODBC installer will also add the installation directory to the global user environment variable PATH. This is necessary since the jBASE ODBC driver depends on other shared libraries as e.g. ACE, etc.

 

When installing on Windows 7 x64, the following extra steps are required:

 

Start a command shell as Administrator

 

Navigate to the directory where you installed the driver then run the following ‘jodbcmanager’ command.

 

C:\Program Files (x86)\jBASE ODBC Connector>jodbcmanager -i -driver="C:\WINDOWS\system32\jodbc.dll" -setup="C:\WINDOWS\system32\libjODBCSetup.dll"

 

 

 

Configuring DSNs

 

ODBC applications usually obtain the connection details from DSNs which may be configured via Microsoft’s ODBC Data Source Administrator (also known as ODBC Manager / odbcad32.exe or Control Panel -> Administrative Tools -> Data Sources (ODBC))

 

When installing on a 64 bit client, the version of ODBCAD that should be used is the version in 'c:\windows\syswow64'

 

If the installation has been successful, the following driver should appear in the list of available ODBC drivers:

 

jBASE ODBC Driver

 

Adding a DSN for this driver will present the following dialog:

 

 

Most of the parameters shown in the previous picture refer to the connection details required by the remote jAgent instance. Server specifies the IP/machine name and Port specifies the TCP port of the remote jAgent instance.

 

Please refer to the jAgent user guide for more information about the available options.

 

Pressing the test button will attempt to establish a connection to the server using the provided user/account credentials. If the driver is not correctly registered with the system or the PATH environment variable does not contain the path to the installation directory, the following message box will appear:

 

 

 

Connection strings

 

Connection strings, as defined by the ODBC SQL CLI, specify the connection parameters supplied to the server when attempting to establish a connection. All connection attributes are defined in a single string separated by semicolons. jBASE ODBC Connector accepts the following attributes:

 

DSN Data Source Name
DRIVER Name of ODBC Driver. Must be jBASE ODBC Driver
DESCRIPTION DSN Description
SERVER Server Address
PORT jAgent Port Number
UID User ID
ACCOUNT jBASE Account. User Authentication will be used if this field is blank
PWD User/Account Password
SCHEMA Schema Name. used. Reserved for future yse
SSL Enable SSL Encryption (1 = Enable SSL, 0 = Disable SSL [default])
SSL_CERTIFICATE Path to SSL Certificate File
SSL_KEY Path to SSL Public Key File
COMPRESSION Enable Data Compression (1 = Enable comp., 0 = Disable comp. [default])
COMP_THRESHOLD Compression Threshold. Default = 1024 byte

 

 

DSN, DRIVER, UID and PWD are attributes defined by the SQL CLI, all other attributes are jBASE ODBC Connector specific attributes. Attributes highlighted in bold are mandatory attributes.

 

Example:

            DSN=T24;SERVER=127.0.0.1;PORT=20002;UID=test;PWD=test

 

 

 

 

 


jBASE ODBC Connector