Easysoft dbExpress-ODBC Gateway User Guide - Installation

Installing the Easysoft dbExpress-ODBC Gateway

This section explains how to install, license and remove the Easysoft dbExpress-ODBC Gateway on supported Windows and Unix platforms.

The Windows installation can be carried out by anyone with local administrator privileges for the target machine.

The Unix installation assumes you are, or have available for consultation, a system administrator.

Chapter Guide

Obtaining the Easysoft dbExpress-ODBC Gateway

There are three ways to obtain the Easysoft dbExpress-ODBC Gateway:

Select Download from the Easysoft dbExpress-ODBC Gateway section of the website and then choose the platform release that you require.

First time visitors must complete the new user form and click Register. Note that your personal Internet options may require you to login and click Continue if you have previously registered.

Change to the pub/kylix directory and then choose the platform release that you require.

What to install

The name of the Easysoft dbExpress-ODBC Gateway install file varies from platform to platform, but is of the form:

¯ OR ¯

where "x" is the major version number, "y" is the minor version number and "z" is the build index, which is incremented when minor changes are made.


NB

Select the highest release available for your platform within your licensed major version number (installing software of a different major version number requires a new Easysoft license).


Unix filenames may also be suffixed with .gz for a "gzipped" archive, or .Z for a "compressed" archive.


NB

If you download a Unix file using Windows, the browser may corrupt the filename. For example, if you download a .gz file and Windows corrupts the filename, it may not be obvious that the file is gzipped. Use filefilename to find out the file type of the downloaded file.


You can now download a file and begin the installation process.


Caution!

As long as you stop all running applications (under Windows), or any software either from Easysoft or using Easysoft drivers (under Unix), it is safe to reinstall or upgrade the Easysoft dbExpress-ODBC Gateway without uninstalling.

If you do uninstall, you should first back up any configuration data that you still need, as uninstalling some Easysoft products will result in this information being deleted (license details remain in place).


Refer to the section relevant to your platform to continue:

Installing on Windows

The distribution for the Easysoft dbExpress-ODBC Gateway under Windows consists of a zip file which contains a text file called Readme.win32 and a dynamic link library file called dbexpodbc.dll.

To install:

1.  Copy dbexpodbc.dll into either:

 the C:\WINNT\System32 Windows system directory


Win 9x

Under Windows 9x, the Windows system directory is called C:\Windows\System.


¯ OR ¯

 the Delphi6\Bin directory.


NB

If the Delphi directory is selected then the driver will only be usable within the Delphi6 IDE.


2.  Edit the dbExpress setup files, which should be found in the Program Files > Common Files > Borland Shared > DBExpress directory:

[Installed Drivers]

.

.

.

ODBC=1

[ODBC]

GetDriverFunc=getSQLDriverODBC

LibraryName=DBEXPODBC.DLL

VendorLib=ODBC32.DLL

BlobSize=-1

Database=DBNAME

Password=password

User_Name=user

RowSetSize=

where LibraryName points to the Easysoft dbExpress-ODBC Gateway driver and VendorLib to the ODBC Driver Manager.

[ib]

DriverName=ODBC

BlobSize=-1

Database=ib

Password=masterkey

User_Name=sysdba

RowSetSize=

Database indicates the DSN that will be connected to using ODBC. An alternative syntax allows any Delphi user name or password to be overridden and to specify the "Database" attribute explicitly (see Easysoft dbExpress-ODBC Gateway FAQ):

Database=DSN=test;UID=user;PWD=password;Database=testdb

Password and User_Name are passed to SQLConnect when your data source is accessed.


NB

This example adds a DSN called ib (in this case to Borland InterBase).

The driver type is not important to the Easysoft dbExpress-ODBC Gateway, as the loading of the ODBC driver is performed by the driver manager.


RowSetSize= enables an issue to be addressed where only 20 rows are returned to dbExpress by default (see Easysoft dbExpress-ODBC Gateway FAQ). Amend this line to RowSetSize=0 to return the full RowSet.

Uninstalling on Windows

To uninstall the Easysoft dbExpress-ODBC Gateway under Windows, delete the dbexpodbc.dll file from the install directory into which they were copied, as specified in step 1.

Installing on Unix

The distribution file for the Easysoft dbExpress-ODBC Gateway under Unix consists of a text file called Readme and a dynamic shared library called libsqlodbc.

To install:

1.  Copy all the libsqlodbc.so* files to a location that the dynamic linker on the system can find, such as /usr/lib, /lib or /usr/local/lib (if it is included in /etc/ld.so.conf).

2.  Edit the Borland driver and connection setup files, which are named $HOME/.borland/dbxdrivers and $HOME/.borland/dbxconnections respectively:

 [Installed Drivers]

 .

 .

 .

 ODBC=1

[ODBC]

GetDriverFunc=getSQLDriverODBC

LibraryName=libsqlodbc.so

VendorLib=libodbc.so

BlobSize=-1

Database=DBNAME

Password=password

User_Name=user

RowSetSize=

where LibraryName points to the Easysoft dbExpress-ODBC Gateway driver and VendorLib to the ODBC Driver Manager.


NB

This example adds a DSN called ib (in this case to Borland InterBase).

The driver type is not important to the Easysoft dbExpress-ODBC Gateway, as the loading of the ODBC driver is performed by the driver manager.


[ib]

DriverName=ODBC

BlobSize=-1

Database=ib

Password=masterkey

User_Name=sysdba

RowSetSize=

Database indicates the DSN that will be connected to using ODBC. An alternative syntax allows any Delphi user name or password to be overridden and to specify the "Database" attribute explicitly (see Easysoft dbExpress-ODBC Gateway FAQ):

Database=DSN=test;UID=user;PWD=password;Database=testdb

Password and UID are passed to SQLConnect when your data source is accessed.

RowSetSize= enables an issue to be addressed where only 20 rows are returned to dbExpress by default (see Easysoft dbExpress-ODBC Gateway FAQ). Amend this line to RowSetSize=0 to return the full RowSet.

Uninstalling on Unix

To uninstall the Easysoft dbExpress-ODBC Gateway under Unix, delete all the libsqlodbc.so* files from the install directory into which they were copied, as specified in step 1.