Vultar ODBC driver for TAFC/T24 is based on three-tier client-server architecture. Each layer has its own installation package. Below we'll provide brief information about the installation files for each layer. The files can be downloaded from our website (Download section).
ODBC database module
Installation package of the database module representing a binary PAK file. The file name has the following structure:
VTRJBDBXXYY.pak or VTXJBDBXXYYZZ.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).
ODBC client module
|Installation kit containing ODBC client module. The module contains Win32 ODBC driver. It should be installed on end user PCs.
- Make sure there is a Telnet or SSH connectivity to jBASE server.
- Opening a telnet/SSH session will bring user to jBASE shell prompt and HOME folder as shown below (actual screen output may vary).
- Login process will have 2 optional input prompts:
a) T24 environment name
b) T24 "START GLOBUS" input
Please check whether your jBASE environment is properly configured. It must have compiler installed and system variables must point to some valid paths. You may use jdiag command line tool to see if your jBASE environment is in order:
|jsh demo ~ -->jdiag
jdiag - jBASE diagnostic '$Revision: 1.13 $'
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
You may use one of many freeware emulators available on the market (for example PuTTY) in order to open a telnet/SSH session and check your jBASE environment.
For more information on how to install a compiler and set up the variables, please consult jBASE documentation.
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.
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. You may also check a small video demo on our website showing how to define an 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 shown on the following screenshot:
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.
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.
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.