jBASE ODBC Connector (jODBC)
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:
The jODBC installer deploys the following files:
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
to obtain more information on how to use this utility.
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"
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:
Alternatively, you can specify which files are visible to jODBC by means of a SQL Catalog file. This file will contain an entry for each file that needs to be accessible to jODBC.
The location of the SQL Catalog file is set via the JSQLFILENAME_CATALOG environment variable, or may be set on a per DSN basis using the UserCatalog option in the jBASE ODBC Data Source.
The entries in the SQL Catalog file are updated via the sqlcatman utility.
Note: The SQL Catalog file will be automatically created by the sqlcatman the first time it is used to add an entry. This file should not be created manually
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, 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.