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.
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.
The name of the Easysoft dbExpress-ODBC Gateway install file varies from platform to platform, but is of the form:
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.
| 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.
You can now download a file and begin the installation process.
Refer to the section relevant to your platform to continue:
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.
1. Copy dbexpodbc.dll into either:
the C:\WINNT\System32 Windows system directory
| Under Windows 9x, the Windows system directory is called C:\Windows\System. |
| 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:
GetDriverFunc=getSQLDriverODBC
where LibraryName points to the Easysoft dbExpress-ODBC Gateway driver and VendorLib to the ODBC Driver Manager.
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.
| 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.
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.
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.
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:
GetDriverFunc=getSQLDriverODBC
where LibraryName points to the Easysoft dbExpress-ODBC Gateway driver and VendorLib to the ODBC Driver Manager.
| 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. |
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.
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.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.
