ODBC and unixODBC
Setting Up ODBC and ODBC Data Sources for LinkMaker™
CobolScript LinkMaker™ is the database conduit technology that is integrated with CobolScript Professional Edition. LinkMaker™ uses the Open DataBase Connectivity (ODBC) specification to connect to a broad range of data sources such as DB2®, Oracle®, Informix®, MS SQL Server®, MS Access®, Postgres®, and MySQL™.
For LinkMaker™ to access data sources properly, so that you will be able to embed SQL in your CobolScript programs, some setup and configuration is required. In Microsoft® operating systems, this setup is relatively simple, while on Unix platforms it’s slightly more involved; this is because the normal Unix environment will not have ODBC connectivity software already installed. In this chapter, we provide step-by-step instructions for configuring your data sources in both Windows® and Unix environments, and for setting up unixODBC, an open source ODBC connectivity package for Unix environments.
Prior to configuring a data source, you must obtain and install an ODBC driver for the data source you wish to access. Microsoft® operating systems come with many popular drivers, and many others are available from database and driver vendors. For Unix platforms, the authors of unixODBC provide several database drivers, and several other Unix database vendors provide ODBC drivers. Complete lists of drivers and vendor/author contact information are in the sections titled Microsoft Windows® ODBC Drivers and UnixODBC ODBC Drivers at the end of this appendix.
Note that the setup information in this appendix is for products not developed or supported by Deskware. For this reason, but it is not guaranteed to be current or complete, since Deskware has no control over these external products or their evolution.
Setup and Configuration in Windows® Environments
In most Windows® environments, ODBC will already be installed (an ODBC icon will be visible in the Windows® Control Panel if ODBC is installed). If ODBC is not already on your Windows® machine, you should install it from your Windows® CD prior to continuing.
Once you’ve confirmed that ODBC is installed, the only setup tasks required prior to using LinkMaker™ are:
1. Obtaining a driver for your data source, if one is not already present on your computer;
2. Configuring the data source.
The following subsection describes the steps necessary to configure your data source so that it can be accessed directly by LinkMaker™.
Configuring an ODBC Data Source in Windows®
1.
From the Windows® Start menu, select Settings and then Control Panel. This will bring up your Microsoft Windows® Control Panel, as shown in Figure G.1. You should see an icon named ODBC Data Sources (32bit). If this icon does not exist, you must install ODBC from your Windows® CD before proceeding.
2.
Double-click on the ODBC Data Sources (32bit) icon. This will bring up the ODBC Data Source Administrator window as shown in Figure G.2.
3.
From the ODBC Data Source Administrator, click on the Add button. This will bring up the Create New Data Source window, as shown in Figure G.3. From here you will be able to create a new data source using any ODBC drivers that are installed on your system. Windows® comes with ODBC drivers for many data sources; if your data source is not listed in this window, you will need to purchase a driver from a vendor. This appendix contains an exhaustive list of vendors that produce ODBC drivers. See the section later in this appendix titled Microsoft Windows® ODBC Drivers for more information.
4. Select an ODBC driver for which you want to set up a data source. In Figure G.3, we have selected SQL Server. Click on the Finish button to bring up the next window.
5. In this next window (see Figure G.4), you will give your ODBC data source a name. This is the name that you will use as the first argument of the CobolScript OPENDB command to connect to the data source. In this example we will use deskware. You can also provide a description of the data source name in the Description: input box. The last input box is the Server. This refers to the name of the server that is hosting the data source. In this example we select (local) because our MS SQL Server database is on this machine. Because this window could differ from Figure G.4 depending on your ODBC driver, your configuration here may be slightly different. After you have entered all required information, click on the Next button.
6.
Next, you will see a window similar to Figure G.5 that allows you to enter additional information about the data source that you are connecting to. You may want to enter a data source Login ID and Password here. If you do not know what Login ID and Password to enter here, you should contact your database administrator. The window that you see here may differ slightly from the one in Figure G.5 depending on the ODBC driver that you are installing. After you have finished, click on the Next button.
7. Depending on your driver, the next window (see Figure G.6) may allow you to specify log files that will record and calculate statistics about the queries you send to the data source. These file are good audit trails, but they do slow down the performance of your application. After you have selected the options you want, click on the Finish button.
8.
For most drivers, Figure G.7 is the last window you will see before your data source is set up. It gives you a chance to review the options you have selected. If you need to modify any of these, click on the Cancel button and you will be able to go back and change them. If not, click on the OK button.
9. After you have clicked on the OK button, you will be back at the ODBC Data Source Administrator window. If you are finished adding data sources, click on the Cancel button to exit. If you want to check the settings for the data source that you just added, select it and click on the Configure button.
10. Now you will be able to connect to databases with CobolScript for Windows®. See Appendix H for more information on embedded SQL programming in CobolScript. Remember that you need to use the data source name that you set up and a valid data source Login ID and password.
Setup and Configuration in Unix Environments
UnixODBC Installation and Setup
You must install unixODBC in order to use the LinkMaker™ version of CobolScript Professional for Linux®, FreeBSD®, or SunOS®. UnixODBC also has a GUI (Graphical User Interface) component that requires installation of the QT graphics library, but installation of the GUI is not required in order to use LinkMaker™. If you are running Linux with a kernel older than 2.2.12, you should not install the GUI. Also, if you are interested in getting started as quickly as possible and with the least effort, and you are comfortable working in a non-graphical environment, you can skip the GUI installation.
The next two subsections provide step-by-step instructions on how to install unixODBC. The first subsection describes installation without the GUI; the second, the more involved installation with the GUI component.
Installing unixODBC without the GUI
The unixODBC manager is a freely available open source package developed by unixODBC.org You will need to go to the unixODBC web site to obtain this software.
1. Go to the unixODBC site and download the unixODBC driver manager package. The web site is at http://www.unixodbc.org. You can go directly to the download page by typing the following in URL in your web browser:
http://www.unixodbc.org/download.htm
2. Once you’ve located the unixODBC web site, download the latest copy of unixODBC to your hard drive. The name of the file will be unixODBC*.tar.gz, where * is the version number of the latest release. You should save this file to the /usr/local directory on your machine. If you save it to another directory, bring up a command prompt and go to that directory. Then copy the file to the /usr/local directory by typing the following at the command prompt:
cp unixODBC*.tar.gz /usr/local
3. The unixODBC package is tar’d and compressed with the gzip format. You will need to uncompress it and un-tar it. Uncompress it by using the gunzip program and typing the following at the command prompt, making sure you are in the /usr/local subdirectory on your machine when you do this:
gunzip unixODBC*.tar.gz
4. You will now have what is called a tar file. This file contains many other files. Un-tar this file by typing the following command at the system prompt. It will create a new subdirectory in your /usr/local directory that will contain the unixODBC files. Again, make sure you are still in the /usr/local subdirectory on your machine when you type this command:
tar -xvf unixODBC*.tar
5. Change your current directory to the unixODBC directory that was created by the tar command in step 4. Do this by typing:
cd unixODBC*
6. You will be inside the unixODBC directory at this point. This directory contains the unixODBC make files. These make files will allow you to compile the unixODBC driver manager on your machine. Before you can run the make files you must configure them. Do this by entering the following at the command prompt:
./configure –-enable-gui=no
Notice that the option to the configure script is -–enable-gui=no. This tells that configuration script that you wish to configure the make files for an installation of unixODBC without the graphical user interface.
7. After running the configuration script, you can compile the unixODBC package on your machine. You will do this by running the Unix make command. This command will look at a file named makefile in the current directory. This file was created by the configuration script. Enter the following at the command prompt to begin compiling the unixODBC package (it may take a few minutes to compile):
make
8. After you have run make and compiled the unixODBC package, install it on your machine by typing the following at the command prompt:
make install
9. Now unixODBC is compiled and installed on your system. This installation process creates various shared libraries on your machine and places them in the /usr/local/lib directory. In order for your system to recognize these libraries, you must directly edit the ld.so.conf file on your system and add a line to this file that contains /usr/local/lib in it. To edit this file, type the following at the command prompt (consult your operating system’s documentation for instructions on how to use the vi editor):
cd /etc
vi ld.so.conf
10. After you have edited and saved the ld.so.conf file, run the following from the command prompt. This will update your system that it can find the newly added shared libraries:
ldconfig
11. Next, you will set up the odbcinst.ini file for the data source you wish to access on this machine. You will need to go to the /usr/local/etc directory and edit the file named odbcinst.ini:
cd /usr/local/etc
vi odbcinst.ini
12. You should consult the unixODBC documentation at http://www.unixodbc.org for additional information on how to edit odbcinst.ini. Here is an example of two entries in odbcinst.ini, one for MySQL and one for PostgreSQL:
[MySQL]
Description = MySQL Driver
Driver = /usr/local/lib/libmyodbc.so
Setup = /usr/local/lib/libodbcmyS.so
FileUsage = 1
[PostgreSQL]
Description = PostgreSQL Driver
Driver = /usr/local/lib/libodbcpsql.so
Setup = /usr/local/lib/libodbcpsqlS.so
FileUsage = 1
13. The next step is to create data source definitions in the odbc.ini file that is located in the /usr/local/etc directory: Assuming you are still in the /usr/local/etc directory, just type the following:
vi odbc.ini
14. Below are examples of odbc.ini file definitions for PostgreSQL and MySQL. Consult the unixODBC documentation at http://www.unixodbc.org for additional information on how to create these entries:
[PostgreSQL]
Description = PostgreSQL
Driver = PostgreSQL
Trace = No
TraceFile =
Database = test
Servername = localhost
UserName = postgres
Password = mypass
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
[MySQL]
Description = MySQL
Driver = MySQL
Trace = Yes
TraceFile = /tmp/mysql.odbc.log
Server = localhost
Port = 3306
Database = deskware
User = root
Password = mypass
15. You are now ready to connect to a unixODBC data source using CobolScript LinkMaker™. Since you are working on a Unix platform, make certain that you have renamed the LinkMaker™-enabled version of CobolScript Professional Edition to cobolscript.exe and are using it instead of the default version of CobolScript Professional (see the readme.txt file included with Unix versions of CS Professional for more information). Also, be sure to remember to use the database name that you create in the odbc.ini file for your first argument of the CobolScript OPENDB command. See Appendix H for information on how to use SQL statements with CobolScript.
Installing unixODBC with the X Windows GUI
The GUI portion of the unixODBC package requires the QT graphics library. This library is freely available and can be obtained from a company called Troll Tech. Here are step-by-step instructions that explain where to get it and how to install this library.
1. The first step to installing unixODBC with the X Windows graphical user interface is to install the QT graphics library. Start a web browser and enter the following URL:
http://www.trolltech.com/dl/qtfree-dl.html
2. After the above URL has successfully loaded, download the QT graphics library (the file named qt-2.0.2.tar.gz) to the /usr/local directory on your machine. If you download it to another directory, bring up a command prompt and go to that directory. Now copy the file to the /usr/local directory by typing the following at the prompt:
cp qt-2.0.2.tar.gz /usr/local
3. This file is a tar’d file that is compressed with the Unix gzip program. You will need to uncompress it. Do so by typing the following at the command prompt:
gunzip qt-2.0.2.tar.gz
4. Now you will have a tar file in your /usr/local directory. It contains many files. To extract these files, type the following at the command prompt. This will un-tar the files into a directory named /usr/local/qt-2.0.2:
tar –xvf qt-2.0.2.tar
5. You now need to change the name of the /usr/local/qt-2.0.2 directory to just plain /usr/local/qt. You will accomplish this by typing the following at the command prompt:
mv qt-2.0.2 qt
6. The next step involves setting environment variables in either your .profile or .login files, depending on which Unix shell you are using.
In .profile (if your shell is bash, ksh, zsh or sh), add the following lines:
QTDIR=/usr/local/qt
PATH=$QTDIR/bin:$PATH
if [ $MANPATH ]
then
MANPATH=$QTDIR/man:$MANPATH
else
MANPATH=$QTDIR/man
fi
if [ $LD_LIBRARY_PATH ]
then
LD_LIBRARY_PATH=$QTDIR/lib:$LD_LIBRARY_PATH
else
LD_LIBRARY_PATH=$QTDIR/lib
fi
LIBRARY_PATH=$LD_LIBRARY_PATH
if [ $CPLUS_INCLUDE_PATH ]
then
CPLUS_INCLUDE_PATH=$QTDIR/include:$CPLUS_INCLUDE_PATH
else
CPLUS_INCLUDE_PATH=$QTDIR/include
fi
export QTDIR PATH MANPATH LD_LIBRARY_PATH LIBRARY_PATH
export CPLUS_INCLUDE_PATH
In .login (if your shell is csh or tcsh), add the following lines:
if ( ! $?QTDIR ) then
setenv QTDIR /usr/local/qt
endif
if ( $?PATH ) then
setenv PATH $QTDIR/bin:$PATH
else
setenv PATH $QTDIR/bin
endif
if ( $?MANPATH ) then
setenv MANPATH $QTDIR/man:$MANPATH
else
setenv MANPATH $QTDIR/man
endif
if ( $?LD_LIBRARY_PATH ) then
setenv LD_LIBRARY_PATH $QTDIR/lib:$LD_LIBRARY_PATH
else
setenv LD_LIBRARY_PATH $QTDIR/lib
endif
if ( ! $?LIBRARY_PATH ) then
setenv LIBRARY_PATH $LD_LIBRARY_PATH
endif
if ( $?CPLUS_INCLUDE_PATH ) then
setenv CPLUS_INCLUDE_PATH $QTDIR/include:$CPLUS_INCLUDE_PATH
else
setenv CPLUS_INCLUDE_PATH $QTDIR/include
endif
7. After you have completed this step, you will need to either login again, or re-source the profile before continuing, so that the $QTDIR environment variable is set. This step is crucial; if you don’t do this, the installation will fail. To re-source the profile, type one of the following (depending on whether you have a .profile or .login file) at the system prompt:
source .profile
source .login
8. Now that you have logged in again or re-sourced the profile, bring up a command prompt and enter the following command.
cd /usr/local/qt
9. You are now in the QT directory. This directory contains the configuration script that is required for the installation of the QT library. Run the configuration script by typing the following at the prompt:
./configure
10. The above step will create the make file that is required to compile QT on your system. You now need to run make to build QT on your system. Do this by entering the following at the command prompt (this step will take several minutes to complete):
make
11. You are now ready to install unixODBC with the graphical user interface. Go to the unixODBC web site and download the unixODBC driver manager package. Their web site is at http://www.unixodbc.org. You can go directly to the download page by typing the following in URL in your web browser:
http://www.unixodbc.org/download.htm
12. Now that you are at the unixODBC web site, download the latest copy of unixODBC to your hard drive. The name of the file will be unixODBC*.tar.gz, where * is the version number of the latest release. You should save this file to the /usr/local directory on your machine. If you save it to another directory, bring up a command prompt and go to that directory. Then copy the file to the /usr/local directory by typing the following at the command prompt:
cp unixODBC*.tar.gz /usr/local
16. Now that you are at the unixODBC web site, download the latest copy of unixODBC to your hard drive. The name of the file will be unixODBC*.tar.gz, where * is the version number of the latest release. You should save this file to the /usr/local directory on your machine. If you save it to another directory, bring up a command prompt and go to that directory. Then copy the file to the /usr/local directory by typing the following at the command prompt:
cp unixODBC*.tar.gz /usr/local
17. The unixODBC package is tar’d and compressed with the gzip format. You will need to uncompress it and un-tar it. Uncompress it by using the gunzip program and typing the following at the command prompt, making sure you are in the /usr/local subdirectory on your machine when you do this:
gunzip unixODBC*.tar.gz
18. Now that you have uncompressed the file, you will have what is called a tar file. This file contains many other files. Un-tar this file by typing the following command at the system prompt. It will create a new subdirectory in your /usr/local directory that will contain the unixODBC files. Again, make sure you are still in the /usr/local subdirectory on your machine when you type this command:
tar -xvf unixODBC*.tar
19. Change your current directory to the unixODBC directory that was created by the tar command in step 4. Do this by typing:
cd unixODBC*
20. You will be inside the unixODBC directory at this point. This directory contains the unixODBC make files. These make files will allow you to compile the unixODBC driver manager on your machine. Before you can run the make files you need to configure them. You will do this by entering the following at the command prompt:
./configure
21. Continue on by performing Steps 7-15 in the previous subsection, Installing unixODBC without the GUI.
unixODBC non-GUI Component (isql)
UnixODBC has a special interactive mode that can be entered with the isql command. You can connect to your data sources, send SQL commands to the data source, and receive results from the data source by using isql. You can start this tool by typing the following at the system prompt:
/usr/local/bin/isql
Specify an ODBC data source name as an argument in order to directly interact with your database, as in the following command line entry:
/usr/local/bin/isql MySQL
This will bring up an isql interactive session like the one shown in Figure G.9.
UnixODBC GUI Components
These components are only available if you have installed the GUI portion of unixODBC.
The unixODBC Data Source Administrator, or ODBCConfig, is a tool designed to allow you to easily set up data sources. Start the Data Source Administrator by typing the following at the system prompt:
/usr/local/bin/ODBCConfig
A window similar to Figure G.10 will appear. From here, you can add, remove, and configure data sources.
Data Manager is a graphical tool for exploring data sources. Start the Data Manger by typing the following at the system prompt:
/usr/local/bin/DataManager
A window like the one in Figure G.11 will appear on your desktop. Using this tool, you can browse your data sources and execute SQL queries against them.
Microsoft Windows ODBC Drivers
Some ODBC drivers are included with the Microsoft Windows operating system. If you plan to work with a data source that Microsoft does not provide an ODBC driver for, you will need to purchase an ODBC driver from one of these companies.
Company
ODBC Driver
Data Source
Acucorp, Inc.
Telephone: 619-689-4500
Fax: 619-689-4550
AcuODBC Vision Driver
Vision indexed file system
Aonix
Telephone: 415-543-0900
Fax: 415-543-0145
NOMAD
RP/Server
OD/Server
DB2
Teradata
IMS
IDMS
ISAM
QSAM
VSAM
Applied Information Services
Telephone: 301-489-1024
Fax: 301-489-1021
UniAccess ODBC Server
Unisys RDBMS
MAPPER
Applix, Inc.
Telephone: 508-870-0300
Fax: 508-366-2278
TM1 ODBC
TM1 databases
Ardent Software Corporation
Telephone: 508-366-3888
Fax: 508-366-3669 http://www.ardentsoftware.com
UniVerse ODBC
UniDesktop ODBC
UniVerse
UniData RDBMS
August Software Corp.
Telephone: 714-454-9007
Fax 714-454-9032
OverDriver
ODBC Router (server)
Data sources with ODBC drivers
Autodesk Inc.
Telephone: 415-507-5000
Fax: 415-507-5100
AutoCAD ODBC Driver
AutoCAD SQL Extension (ASE)
Automation Technology Inc.
Telephone: 408-473-0200
Fax: 408-473-0201
OpenAccess ODBC SDK
OpenRDA ODBC drivers
Any non-SQL database and SQL Server, Microsoft Access from non-Window platforms
BORN Information Services
Telephone: 612-404-4000
Fax: 612-404-4444
ODBC for the AS/400
IBM AS/400
Company
ODBC Driver
Data Source
Bull Worldwide Information Systems
Telephone: 602-980-8575
Telephone: 602-862-6062
Fax: 602-862-3606
DDA ODBC
Oracle
DB2
Informix
Teradata
IMS
VSAM
OpenIngres
Rdb
RMS
IDS II
RFM II
UFAS
Byte Designs, Ltd.
Telephone: 604-534-0722
Fax: 604-534-2601 http://www.bytedesign.com
Byte Design ODBC
C-ISAM
D-ISAM
DISAM96
Informix
Centura Software Corp.
Telephone: 415-321-9500
Fax: 415-321-5471 http://www.centurasoft.com
ODBC Drivers for SQLBase
SQLHost/DB2
SQLBase
DB2
Velocis
Cincom Systems
Telephone: 513-662-2300
Fax: 513-459-7145
Supra ODBC Driver
UniSQL ODBC Driver
Supra Server UniSQL (except Japan)
Computer Associates Int'l, Inc.
Telephone: 800-225-5224
CA-IDMS Server ODBC
CA-Visual Express
ODBC Driver for Ingres
CA-Datacom Server
IDMS
OpenIngres
IBM DB2
IMS
Rdb
RMS
VSAM
AllBase/SQL
Image/SQL
CA-Datacom/DB
Computer Corporation of America http://www.cca-int.com
ODBC V2, Connect*
System 1032
Model 204
Computer Solutions Limited
Telephone: +44 (0) 1905 794400
Fax: +44 (0) 1905 794 464 http://www.csllink.com/products.html
Linkway 32
AllBase/SQL
Image/SQL
Cornerstone
Telephone: 603-595-7480
Fax: 603-882-7313
Dyna Access
Tandem NonStop SQL
Tandem Enscribe
Cross Access Corp.
Telephone: 408-735-7545
Fax: 408-735-0328 http://www.crossaccess.com
Cross Access ODBC Driver
Adabas
Datacom
DB2
DL/1
IDMS
IMS
Oracle
Sequential
VSAM
Datafit Ltd.
Telephone: 011-44-1-480-454-604
Datafit DP4
Datafit DP4
Company
ODBC Driver
Data Source
Decision Support, Inc.
Telephone: 704-849-8904
Fax: 704-487-4875
UniStar ODBC Driver
DMS II
DARGAL server
Dharma Systems
Telephone: 603-886-1400
Fax: 603-883-6904 http://www.products.dharma.com
Dharma ODBC SDK
ODBC SDK Lite
BASISplus
GT.M
PROMIS
custom drivers
Doric Computer Systems International
Telephone: 800-223-2942
Telephone: 206-367-7974 http://www.doric.com
INFO~ODBC Direct Client INFO~ODBC Server
C-ISAM
D-ISAM
ESRI ARC/INFO Coverages
INFO DBMS & 4G/L
Egan Systems, Inc.
Telephone: 800-645-9898
Telephone: 516-588-8000
Fax 516-588-8001 http://www.egns.com/ODBC/
Interactive COBOL ODBC Driver
ICOBOL Server
COBOL files
Easysoft Ltd.
Telephone: +44 (0)1132220400
Fax: +44 (0)1132220500 http://www.easysoft.com
ODBC for RMS
ODBC for ISAM
ODBC for CODA
ODBC for ROSS
RMS files
C-ISAM
D-ISAM
T-ISAM
EasiRun Software
Telephone: 619-587-0467
Fax: 619-587-0466
EasiODBC
Relativity
USQL Client-Server drivers
AcuCOBOL files
RM-COBOL
EXTFH
C-ISAM
Business BASIC ISAM
U/FOS
Empress Software Inc.
Telephone: 301-220-1919
Fax 301-220-1997
Empress ODBC driver
Empress
Ensodex, Inc.
Telephone: 612-766-8787
Fax 612-766-8792
Hot Sockets ODBC Driver (server)
Data sources with 32-bit ODBC drivers
Esker, Inc.
Telephone: 415-675-7777
Fax: 415-675-7775
ODBC Driver Pack
TunSQL
C-ISAM
D-ISAM
IBM DB2
Informix
Oracle
Progress
Sybase
EveryWare Development Corp.
Telephone: 905-819-1173
Fax 905-819-1172
Butler SQL ODBC Driver
Butler SQL
Farabi Technology Corp.
Telephone: 800-565-3455
Telephone: 514-332-3455
Fax 514-332-3915
ODBC for Ultima/400
AS/400
FairCom Corp.
Telephone: 800-234-8180
Telephone: 314-445-6833
Fax 314-445-9698
FairCom ODBC Driver
FairCom Server
c-tree Plus
Company
ODBC Driver
Data Source
FFE Software
Telephone: 510-232-6800
Fax 510-237-7433
FirstSQL ODBC
FirstSQL
dBASE
Filemaker, Inc.
Telephone: 800-325-2747
Telephone: 408-987-7000 http://www.filemaker.com
Filemaker Pro ODBC Driver
Filemaker
FLEXquarters
Telephone: 602-732-9217
Fax: 602-732-9590 http://www.flexquarters.com
Flex/ODBC
DataFlex files
M.B. Foster Associates
Telephone: 613-448-2333
Fax: 613-448-2588 http://www.mbfoster.com/
DataExpress ODBCLink
HP 3000 Allbase
TurboImage
Fulcrum Technologies, Inc.
Telephone: 613-238-1761
Fax: 613-238-7695
Fulcrum SearchServer
Fulcrum Search Server
Generix Limited
Telephone: +44 (0) 1924 500151
Fax: +44 (0) 1924 500515 http://www.generix.ltd.uk
CONNX
DB2
Oracle
RDB
RMS
gfs Gesellschaft fur Informationssysteme mbH
Telephone: +49-40-450232-0
Fax: +49-40-450232-66
ODBC-Rocket
BS2000 DBMS
SESAM/SQL
UDS/SQL
LEASY
ISAM
Harbinger Corporation
Telephone: 800-555-2989
Telephone: 404-467-3000
Fax: 404-841-4364
STX for Windows
STX
Hill Croft Information Technologies
Telephone: +44 1908 666244
Fax: +44 1908 666244 http://www.LinkEase.co.uk
LinkEase
DataEase
HiT Software, Inc.
Telephone: 408-369-7290
Fax: 408-369-7299
HS*ODBC
AS/400
DB2
Hewlett Packard
Telephone: 800-637-7740
AllBase
Image
AllBase/SQL
Image/SQL
HOB GmbH & Co. KG Germany Brandstaetterstrasse 2-10 D-90513 Zirndorf
Telephone: +49-911-9666-393
Fax: +49-911-9666-271
HOBLink DRDA
DB2 OS/390
DB2 UDB
DB2 MVS
DB2 VSE&VM
DB2/400
DB2/6000
DB2/2
VSAM*
IMS/DB*
DL/1*
* requires HOBDB online
Company
ODBC Driver
Data Source
IBM Corp.
Telephone: 800-IBM-4YOU
http://www.software.ibm.com/data/db2/db2connect
DB2 Connect
DB2 for OS/390
DB2 for MVS/ESA
DB2/400
DB2 for VSE and VM
DB2 UDB (UNIX, Windows NT and OS/2 servers)
IBM Corp. http://www.networking.ibm.com/gso/gsohome.html
Connection ODBC Client
Connection Server
Information Builders, Inc.
Telephone: 800-969-4636
Telephone: 212-736-4433
Fax 212-629-8819
EDA/Extender for ODBC
EDA/SQL (server)
DB2
IMS
VSAM
IDMS
Datacom
TOTAL
Teradata
ADABAS
Oracle
SQL Server
OpenIngres
Informix
Supra Server
SQL/DS
RMS
Rdb
M
Sharebase
C-ISAM
Image/SQL
Allbase/SQL
Others
Informix Software, Inc.
Telephone: 800-388-0366
Telephone: 415-926-6300
Fax: 913-599-8753
Informix ODBC Driver
Informix OnLine Dynamic Server, SE
Intersoft, Inc.
Essentia ODBC
Essentia SQL-Server
Intersolv, Inc. (see MERANT)
DataDirect ODBC Drivers
SequeLink
See MERANT
IQ Software
Telephone: 770-446-8880
Fax: 770-448-4088
IQ Smart Server
Several DBMSs
Company
ODBC Driver
Data Source
ISG International Software Group
Telephone: 781.221.1450
Fax: 781.272.2531
ISG Navigator/ODBC
ISG Navigator/Bridge
ADABAS
Btrieve
C-ISAM
D-ISAM
DB2
IMS
Informix
Mumps
OpenIngres
Oracle
SQL Server
Sybase
Rdb
Red Brick
RMS
TANDEM Enscribe
TANDEM SQL-MP
TANDEM SQL-MX
Text
VSAM
ODBC data sources, OLEDB data sources any 3GL Application (Application connector), any database (SDK)
Bridge to OLE DB providers (Windows, NT and Unix)
Javera Software, Inc.
Telephone: 412-397-4061
Fax 412-397-4062
JetConnect
Any ODBC data source
KB Systems, Inc.
Telephone: 703-318-0405
Fax: 703-318-0569
KB_SQL ODBC Driver
KB_SQL
M
Kerridge Computer Company, Ltd.
Telephone: +44(1635) 523456
Fax: +44(1635) 30300 http://www.kerridge.com
K-ISAM ODBC Driver
K-ISAM
KE Software, Inc
Telephone: 604-877-1960
Fax: 604-877-1961 http://www.kesoftware.com
TexODBC
KE Texpress ODBMS
Liant Software Corporation
Telephone: 800-349-9222
Telephone: 508-872-8700
Fax 508-626-2221
Relational Data Bridge (formerly Relativity)
VSAM
ISAM
Btrieve
RMS
Micro Focus COBOL files
RM/COBOL files
Company
ODBC Driver
Data Source
Liberty Integration Software
Telephone: 604-682-8293
Fax: 604-682-8499 http://www.libertyodbc.com
Liberty ODBC Driver
PICK
UniData
UniVerse
PI-Open
Sequoia/Pro
GA-Power95
GA-R91
mvBase
jBase
Reality/X
UltPlus
Alpha Microsystems
Mentor/Pro
Advanced PICK
D3
Lotus Development Corp.
Telephone: 617-577-8500
Fax: 617-693-6080
NotesSQL Driver
Lotus Notes
Marxmeier Software GmbH
Telephone: +49 202 24314-40
Fax: +49 202 24314-20 http://www.msede.com
SQL/R ODBC (server)
HP Eloquence databases
MEGAsoft, Inc.
Telephone: 407-423-0460
Email: 72702.1303@compuserve.com
ODBC driver for MEGAdata
PASSdata
MEGAdata
MERANT
Telephone: 800-876-3101
Telephone: 919-461-4200
Fax 919-461-4526 http://www.merant.com/datadirec
DataDirect ODBC Drivers
DataDirect SequeLink (server)
Btrieve
Clipper
DB2
dBASE
FoxPro
Excel
Informix
OpenIngres
Oracle
Paradox
Progress
AS/400
SQL/DS
SQLBase
SQL Server
Teradata
Text
XDB
DB2-DDCS/2
MDI Gateway
Sybase Net-Gateway
IBM DB2
Oracle
Microsoft SQL Server
Sybase
Informix OnLine and SE
OpenIngres
any ODBC-compliant database
Company
ODBC Driver
Data Source
Micro Data Base Systems Inc.
Telephone: 800-445-6327
Telephone: 765-463-7200
Fax 765-463-1234
Titanium ODBC Driver
GURU ODBC Driver
Titanium
GURU
KnowledgeMan
Object/1
Micro Focus (see MERANT)
Telephone: 415-856-4161
Fax: 415-856-6134
Correlate
Micro Focus files
Microrim Inc. (see R:BASE Technologies)
Ottero ODBC
Ottero
Microsoft Corp.
Telephone: 800-426-9400
Telephone: 206-882-8080
Fax: 206-936-7329
ODBC Desktop Database Drivers
Microsoft SQL Server Driver
DB2/Integrator
SQL Server
Excel
Text
dBASE
Paradox
Access
FoxPro
Btrieve
DB2
MiniSoft, Inc.
Telephone: 800-682-0200
Telephone: 360-568-6602
Fax: 360-568-2923
MiniSoft ODBC/32
HP Image/SQL
Monette Information Systems
Telephone: 1-800-MONETTE
Fax: 757-357-5163
Synergex ODBC Driver
Monette application data
NCR Corporation
Telephone: 513-445-5000
Teradata ODBC Driver
Teradata
Neon Systems
Telephone: 218-491-4200
Telephone: 800-505-6366
Fax: 281-242-3880
ShadowDirect Enterprise Direct (server)
DB2
IMS
VSAM
Oracle
Sybase
ADABAS
NobleNet, Inc. (Rogue Wave)
Telephone: 508-460-8222
Fax: 508-460-3456
NobleNet One Driver SDK (server)
Data sources with ODBC drivers
Nogginware Corporation http://www.nogginware.com
RemoteDB Gateway (server)
Data sources with ODBC drivers
NTT Data Corporation
Telephone: 03-3647-8611
Fax: 03-3647-7511 http://unisql.www.nttdata.co.jp
Inforover ODBC Driver
Inforover
UniSQL
Oberon microsystems, Inc.
Telephone: ++41-1-445-1751
Fax: ++41-1-445-1752
ODBC Driver for Sql Subsystem
Oberon/F Sql Subsystem (Black Box Component Builder)
Object Design, Inc.
Telephone: 617-674-5000
Fax: 617-674-5010
ObjectStore ODBC Driver
Open Access (server)
ObjectStore
Company
ODBC Driver
Data Source
Objectivity, Inc.
Telephone: 650-254-7100
Fax: 650-254-7171
Objectivity ODBC Driver
Objectivity/DB
Ocelot Computer Services
Telephone: 780-472-6838
Email: 71022.733@compuserve.com
Ocelot ODBC Driver
Ocelot SQL-92
Open Horizon Inc. (See IBM)
Connection ODBC Client
Connection Server
OpenLink Software Inc.
Telephone: 781-273-0900
Fax: 781-229-8030 http://www.openlinksw.com
OpenLink Universal Data Access Driver Suite (client or server-side)
Informix
Ingres
Kubl
Oracle
Microsoft SQL Server
Postgres
Progress
SOLID
Sybase
Velocis
Operating System Support
Telephone: 561- 241-9900
Telephone: 800-333-5899
Fax 561-241-0003
ViaODBC-32
Advanced Plus
UltPlus
Oracle Corporation 415-506-7000 http://www.oracle.com
Oracle ODBC Driver
Rdb ODBC Driver
Oracle Open Gateways
Oracle
ADABAS
Access
Btrieve
IDMS
Datacom
DB2
DMS II
FOCUS
Image/SQL
IMS
Infoman
Informix
Ingres
ISAM
M
Model 204
QSAM
Rdb
RDMS
RMS
SAP
SESAM
SQL Server
Supra
Sybase
System 2000
Teradata
TOTAL
UDS
Jukebox
VSAM
Company
ODBC Driver
Data Source
PARKWAY Software GmbH
Telephone: +49 089 6518-034
Fax: +49 089 6518-161
http://www.parkway-software.com
ConnectWare
Btrieve
C-ISAM
CA-Realia
D-ISAM
Micro Focus files
mbp
VSAM
Persistent Systems Private Limited Fax
Telephone: +91 20 37 6701 http://www.pspl.co.in/PSEnList/
PS EnList
LDAP servers
Pervasive Software
Telephone: 800-287-4383
Telephone: 512-794-1719
Btrieve
Pervasive SQL ODBC driver
Pervasive SQL
Phoenix Systems, Inc.
Telephone: 404-633-2466
Fax: 404-634-9975
http://www.phoenix-systems-inc.com
FUNDS ODBC Interface
FUNDS System Databases
Pioneer Systems, Inc.
Telephone: 513-247-1500
Fax: 513-247-1400
INFOAccess ODBC driver
Unisys A series and NX systems: DMS II and keyed files.
Unisys 2200 and IX: DMS 1100 and DMS2200
Platinum Technology Inc. (see Computer Associates)
Telephone: 800-442-6861
Telephone: 708-620-5000
Fax: 708-691-0417
InfoHub
IDMS
IMS
ADABAS
DB2
VSAM
Sequential Files
Poet Software Corp.
Telephone: 800-950-8845
Telephone: 415-286-4640
Fax: 415-286-4630
Poet ODBC Driver
Poet ODBMS
Professional Data Associates, Inc.
Telephone: 718-263-1334
Fax: 718-263-1350 http://www.pdaco.com/tbred.htm
TS ODBC Data Server
Thoroughbred files
Progress Software
Telephone: 781-280-4000
Fax: 781-280-4895
Apptivity Server
Progress
Oracle
Microsoft Access
SQL Server
Informix
Sybase
other ODBC or JDBC data sources
R:BASE Technologies, Inc.
Telephone: 724-733-0053
Fax: 724-733-0196
http://www.rbasetechnologies.com
Ottero ODBC
Ottero Engine
QBS Software Ltd.
Telephone: +440 181 956 8001
Fax: +440 181 956 8010
Advantage ODBC Driver
Advantage Database Server
Quadbase Systems Inc.
Telephone: 408-982-0835
Fax: 408-982-0838
Quadbase-SQL ODBC Driver
Quadbase-SQL
Raima (see Centura Software)
Telephone: 800-327-2462
Telephone: 206-515-9477
Fax: 206-748-5200
Velocis ODBC Driver
RDM ODBC Gateway
Raima Data Manager++
Velocis Database Server
Real Time eXecutive, Inc.
Telephone: 508-384-7717
Fax: 504-384-9074
ODBC for RTXHDB
RTXHDB
Recital Corporation
Recital ODBC Developer
Recital
Red Brick Systems (see Informix)
Red Brick ODBC Driver
Red Brick Warehouse VPT
Red Point Software
Telephone: 214-355-5200
Fax: 214-355-5201
SnmpQL ODBC Driver
Data from SNMP devices
Santa Cruz Operation
Telephone: +44(0) 113 251 2222
Fax: +44(0) 113 251 2223 http://www.sco.com
SCO SQL Retriever
Informix
Oracle
OpenIngres
InterBase
Sybase
Progress
SAS Institute
Telephone: 919-677-8000
Fax: 919-677-8123
SAS/Access Interface to ODBC
SAS
ShowCase Corp.
Telephone: 800-829-3555
Telephone: 507-288-5922
Fax: 507-287-2803 http://www.showcasecorp.com
ShowCase ODBC Driver
IBM AS/400
Siemens Nixdorf Informationssysteme
DBA.D
DBA.X
DBA.2000
Informix
Oracle
OpenIngres
SESAM/SQL
UDS/SQL
Simba Technologies Inc.
Telephone: 800-388-4933
Telephone: 604-601-5300
Fax: 604-601-5320
Simba Express (server)
Simba ODBC Driver SDKs
ODBC drivers
Oracle
Sybase
DB2
Informix
SQL Server
Software AG
Telephone: 800-423-2227
Telephone: 703-860-5050
ADABAS ODBC Driver
ADABAS D
ADABAS
Software Clearing House
Telephone: 513-579-0455
Fax: 513-579-1064
Open/A ODBC Driver
Open/A
A-Series
Software Migration and Conversion
Telephone: 612-452-9270
Fax: 612-688-2191
Open CQL Driver
DMS-1100
PCIOS
RDMS-1100
SoftOption
Telephone: +44(0)1322 278603
Fax: +44(0)1322 289630
ODBC for CTOS
CTOS ISAM
Company
ODBC Driver
Data Source
Solid Information Technology, Ltd.
Fax: +358-9-4774 7390 http://www.solidtech.com
SOLID ODBC Driver
SOLID Server
SolutionsIQ
Telephone: 888-882-6669
Telephone: 425-519-6613
Fax: 425-453-8871
CONNX
Oracle
DataFlex
Rdb
RMS
SQLData Systems, Inc. http://www.sqldata.com
SQLData Enterprise Server (server)
ODBC data sources
StarQuest Software
Telephone: 510-704-2000
Fax: 510-704-2001 http://starweb.starware.com
StarSQL ODBC Driver
DRDA
DB2
SQL/DS
Superbase Developers plc 310-374-4125 +44 1223 365550 Fax +44 1223 363302 http://www.superbase.com
Superbase ODBC Driver
Superbase
Sybase, Inc.
Telephone: 800-879-2273
Telephone: 800-221-3634
Telephone: 510-922-3500
Fax: 510-922-4850
Adaptive Server
Adaptive Server Anywhere
ODS ODBC-ODS
EnterpriseCONNECT Gateway
Adaptive Server Anywhere
Adaptive Server
DB2
SQL/DS
Teradata
SQL/400
VSAM
IMS
IDMS
ADABAS
Oracle
SQL Server
DB2/2
Sysdeco Mimer AB
Telephone: +46 18-185000
Fax: +46 18-185100
MIMER ODBC Driver
MIMER SQL RDBMS
SYWARE, Inc.
Telephone: 617-497-1376
Fax: 617-697-8729
Dr. DeeBee ODBC Driver Kit
Xbase
ISAM
Synergex International Corporation
Telephone: 800-366-3472
Telephone: 916-635-7300
Fax: 916-635-6549
Synergy ODBC Driver
Synergy databases
Tandem Computers
Telephone: 800-482-6336
Telephone: 408-285-5446
Fax: 408-285-6010
NonStop ODBC Server
Tandem NonStop SQL
TimesTen Software
Telephone: 800-970-1248
Telephone: 650-526-5100
Fax: 650-526-5199
TimesTen ODBC
TimesTen Server
TopSpeed Corporation
Telephone: 800-354-5444
Telephone: 954-785-4555 http://www.topspeed.com/tsodbc.htm
TopSpeed ODBC Interface
Clarion TopSpeed databases
Transoft, Ltd.
Telephone: 770-933-1965
Fax: 770-933-3464
Transoft U/SQL Client-Server (server)
C-ISAM
Micro Focus COBOL
EXTFH
AcuCOBOL
Oracle
Informix
Sybase
Trifox, Inc.
VORTEXodbc
ADABAS D
DB2
Ingres
Informix
GENESIS
Oracle
Rdb
Microsoft SQL Server
Sybase
Trilogy Technology International
Telephone: 818-854-6288
Fax: 818-854-6289
OpenPath RDA/ODBC
Informix
Oracle
Sybase
IBM DB2
RDA
UniSQL, Inc. (for Japan, see NTT Data Corp. Otherwise, see Cincom.)
UniSQL/X
UniSQL/M
UniSQL
Unisys
Telephone: 800-874-8647
Telephone: 800-448-1424
Telephone: 714-380-6460
TransIT ODBC
HDBC Component
HMP NX
A_Series: DMS II
LINC
SQLDB
KEYED1011
sequential files
Usoft
Telephone: +31 (0) 35 6990699
Fax: +31 (0) 35 6950124 http://www.usoft.com
USoft Open Rules API
DB2
Informix
Oracle
SQL Server
Solid
Sybase (via USoft Open Rules Engine)
Vertisoft
Telephone: 905-474-1862
Telephone: 800-361-0099
Fax: 905-474-0006
C-ISAM ODBC Driver
C-ISAM
Versant Object Technology
Telephone: 510-789-1500
Fax: 510-789-1515
Versant/ODBC
Versant
Viaserv, Inc.
Telephone: 800-348-3964
ViaSQL for VSE-VSAM
ViaSQL for VSE-SQL/DS
Viaserv Gateway
SQL/DS
Wall Data Inc.
Telephone: 206-814-9255
Fax: 206-861-3175
Rumba
Arpeggio
DB2
IBM DB/VM
IBM AS/400
IMS
White Cross Systems, Inc.
Telephone: 310-577-8188
Fax: 310-577-8192
Telephone: 44 1344 300 770
Fax: 44 1344 301 424 http://www.whitecross.com
White Cross 9000
White Cross RDBMS
Company
ODBC Driver
Data Source
XDB Systems, Inc. (see MERANT)
Telephone: 410-312-9300
Fax: 410-312-9500
ExpressLane (server)
XDB
IBM DB2
IBM AS/400
YARD Software Gmbh
Telephone: +(49) 221/98664-0
Fax: +(49) 221/98664-99
ODBC Driver for YARD-SQL
YARD-SQL
UnixODBC ODBC Drivers
The following table is a list of unixODBC drivers and the companies that produce them. Most of these are freely downloadable unixODBC drivers. There is also a project underway to create a unixODBC driver for Oracle.
Because some of the drivers below are freeware products, they may not be production-worthy or free of bugs. You should contact the driver author if you have problems installing or using a specific driver. For data sources marked with a plus sign (+), we successfully installed and tested the driver with unixODBC. For those marked with a minus ( - ), we were unable to succeed in making the driver work with unixODBC. The drivers for data sources not marked by a plus or minus were not tested.
Company
unixODBC Driver
Data Source
unixODBC
PostgreSQL Driver included with unixODBC
PostgreSQL (+)
T.C.X DataKonsult AB
Fax: +46-8-7296905 http://www.mysql.com/download_myodbc.html
MyODBC Driver for unixODBC
MySQL, version 3.23 and higher (+)
IBM Corp.
Telephone: 800-IBM-4YOU
http://www.software.ibm.com/data/db2
The libdb2.so library, part of DB2 for Linux, can serve as an ODBC driver.
DB2 for Linux
YARD Software GmbH
Telephone: +49 221 98664-0
Fax: +49 221 98664-99 http://www.yard.de
YARD unixODBC Driver
YARD-SQL
Ke Jin's Net News ODBC Driver
Internet News Server Driver included with unixODBC
Internet News Server
Easysoft
Telephone: +44 (0) 113 222 0400
Fax: +44 (0) 113 222 0500 http://www.easysoft.com/
Easysoft's ODBC-ODBC Bridge
ODBC-ODBC
unixODBC
MiniSQL Driver included with unixODBC
MiniSQL ( - )
unixODBC
SQL unixODBC Driver for Text Files
Text Files ( - )