Home Knowledgebase ODBC driver for jBASE Installation instructions Welcome, Guest. Please login or register.
Installation instructions

Vultar ODBC driver for jBASE is based on three-tier client-server architecture. The following table contains brief descriptions of the installation files for each layer. The files can be downloaded from our website (Download section).

Module name
Description
ODBC database module

Installation package of the database module representing a binary PAK file. The file name has following structure:

File: VTRJBDBXXYY.pak or VTXJBDBXXYYZZ.pak

R- package containing full RELEASE
X
- package containing a PATCH for a given release
XX- Major release version
YY
- Minor release version
ZZ
- Patch number

Ex.: VTRJBDB0092.pak

The packages (both RELEASE and PATCH types) can be installed using Administrator tool (bundled with Application server and Client module).

ODBC application server

Installation kit containing Win32 ODBC application server. For performance considerations, it is advisable to install it on a dedicated server inside the local network.

It may work as a service or as a standalone GUI application (service installation requires administrative privileges; GUI mode is for debugging purposes only).

File: vtodbcas_inst_XX.exe

ODBC client module

Installation kit containing ODBC client module. The module contains Win32 ODBC driver. It should be installed on end user PCs.

File: vtodbcdv_inst_XX.exe


Installation sequence and setup

ODBC Application server

  • Launch vtodbcas_inst_XX.exe on a dedicated Windows server and follow installation instructions of the setup wizard.
Warning: Application server can work in two modes: service or GUI. Service will fail to install without proper administrative privileges. In such case, only GUI mode will be available, which will require to run vtsrvgui.exe in the background.
  • After installation, launch Vultar Administrator tool and create a new jBASE alias. Demo video here (see details below).

Administrator tool will pop up a login dialog. Specify application server name or IP address (if app server runs locally, input "localhost" or "127.0.0.1" ; port 39401). By default, username and password are both blanks.

Once you are logged in, proceed to the next step - creating a new jBASE alias. Alias must be properly configured in order to connect and install successfully the database module. Please check prerequisites below before creating a new alias.

Administrator tool login dialog
 
 
Make sure the following prerequisites are accomplished before creating a jBASE alias:
  • Telnet or SSH connectivity to jBASE server and jBASE shell prompt
  1. jBASE telnetd service is running (jBASE for Windows only)
  2. Opening a telnet/SSH session will bring user to jShell prompt and HOME folder as shown below (actual screen output may vary)
  3. Login process will have 2 optional input prompts:
    a) T24 environment name
    b) T24 "START GLOBUS" input
Telnet login

In order to open a telnet/SSH session you may download and use one of many freeware emulators available on the market (ex. PuTTY).


  • jBASE setup - Paths and Compiler

The jBASE environment must have a compiler installed. Also, system variables have to point to some valid paths, and "jdiag" command is a good starter to check all these settings:

  jsh demo ~ -->jdiag
        jdiag - jBASE diagnostic '$Revision: 1.13 $'

System Information
==================

System                      : WinNT SUBSOL-XP 5.1 i386
OS Release                  : Windows XP Pro, Build 2600, Service Pack 3
NT User                     : demo
Time                        : Tue Dec 24 11:12:19 2009 Environment
===========

JBCPORTNO                   : Not Set
JBCRELEASEDIR               : 'C:\jbase4\4.1'
JBCGLOBALDIR                : 'C:\jbase4\4.1'
JBCDATADIR                  : 'C:\home'
HOME                        : 'C:\home'
JEDIFILENAME_MD             : 'VOC'
JEDIFILENAME_SYSTEM         : 'C:\jbase4\4.1\src\SYSTEM'
SYSTEM File is (DICT)       : 'C:\jbase4\4.1\src\SYSTEM]D'
RELEASE Information         : Major 4.1, Minor 5.17, Patch 5690 (Change 52756)
Spooler dir (JBCSPOOLERDIR) : 'C:\home\jspooler'
JBCEMULATE                  : Not Set
TEMP file path              : 'C:\WINDOWS\TEMP\'
Object path (Default)       : 'C:\jbase4\4.1\lib;C:\home\lib'
VC++ Registry               : Version 7; Path C:\MS Visual Studio.NET 2003\VC7
jBASE Compiler Run-time     : 'C:\jbase4\4.1\config\system.properties'
Program dir (JBCDEV_BIN)    : 'C:\home\bin'
Subroutine dir (JBCDEV_LIB) : 'C:\home\lib'
There are No warnings, jBASE seems to be loaded correctly


 
For more information on how to install a compiler and set up the variables, please consult jBASE documentation.

 

With a valid Unix/Windows user name, you can create a new Vultar alias to jBASE server. Right click on left panel and choose [New Alias...] option. Assign a meaningful name, then input alias details in [Connection] tab.

Administrator tool - Alias
 
 
After filling in all necessary data and applying changes to server, hit [Connect] button in order to check whether ODBC application server is able to establish a connection with jBASE. In case of success, the system will pop up a message dialog as displayed on the nearby screenshot.Administrator tool - Connection error
That means you have to proceed to the next step - installing database module. Otherwise, for some reason Vultar application server could not establish a connection to jBASE. The most common problem in this case is "Connection timeout" issue. Usually, it can be solved by altering some negotiation keys in [Parameters] tab.

In case you fail to establish a connection, please report the issue to This e-mail address is being protected from spambots. You need JavaScript enabled to view it (include a telnet/ssh console screenshot (after login), "jdiag" output and other relevant data).

 
 
ODBC Database module
 
Once you have successfully installed ODBC application server, proceed to the next step - installing ODBC Database module on jBASE server. The procedure runs entirely from Administrator tool. Select an alias, go to [Database Module] tab and choose necessary RELEASE package from your local drive. A detailed information about the package will be displayed, as shown on the screenshot below. Press [Install] button and wait a couple of minutes until the process finishes.
Administrator tool - Database Module
 
PATCH type packages (if any) have to be installed in the same way as RELEASE packages. A series of validations will prevent user from installing inappropriate patch. Also, driver has a built-in version control system. It will check eventual dependencies, and will display information about all ODBC patches installed on jBASE server.
 
 
ODBC client module
  • Launch vtodbcdv_inst_XX.exe on end user's PC and follow the installation instructions of the setup wizard.
  • After installation, open ODBC Administrator and create a new DSN. Demo video here.
ODBC Administrator
 
After successful installation of all three modules, the driver is now ready to be used with any ODBC enabled application (Excel, Crystal Reports, the majority of ETL tools, etc.) or be used by developers to build custom Windows applications that require direct and quick access of jBASE/T24 data.

 

 

http://vultar.md/, Powered by Joomla and Designed by SiteGround web hosting