Symfoware Server V12.1.0 Application Development Guide

3.2.1 Registering ODBC Drivers

When using the ODBC driver on a Linux platform, register the ODBC driver using the following procedure:

1. Installing the ODBC driver manager (unixODBC)

   Information

   • Symfoware Server supports unixODBC Version 2.3 or later.

     You can download unixODBC from the following site:

     http://www.unixodbc.org/

   • To execute unixODBC, you must first install libtool 2.2.6 or later.

     You can download libtool from the following website:

     http://www.gnu.org/software/libtool/

   [Note]

   • ODBC driver operation is supported.

   • unixODBC operation is not supported.

2. Registering ODBC drivers

   Edit the ODBC driver manager (unixODBC) odbcinst.ini file.

   Information

   [location of the odbcinst.ini file]

   unixOdbcInstallDir/etc/odbcinst.ini

   Set the following content:

   Definition name	Description	Setting value
   [Driver name]	ODBC driver name	Set the name of the ODBC driver. Select the two strings below that correspond to the application type. Concatenate the strings with no spaces, enclose in "[ ]", and then specify this as the driver name. Note The placeholders shown below are enclosed in angle brackets '<>' to avoid confusion with literal text. Do not include the angle brackets in the string. Application architecture For data sources used by 32-bit applications "SymfowareServer<symfowareServerClientVersAndLvl>" For data sources used by 64-bit applications "SymfowareServer<symfowareServerClientVersAndLvl>x64" Encoding system used by the application In Unicode (only UTF-8 can be used) "unicode" Other than Unicode "ansi" Example: In a 32-bit application, where the encoding system used by the application is Unicode: "[SymfowareServer<symfowareServerClientVersAndLvl>unicode]"
   Description	Description of the ODBC driver	Specify a supplementary description for the current data source. Any description may be set.
   Driver	Path of the ODBC driver (32-bit)	Set the path of the ODBC driver (32-bit). If the encoding system is Unicode: symfowareServerClientInstallDir/odbc/lib/psqlodbcw.so If the encoding system is other than Unicode: symfowareServerClientInstallDir/odbc/lib/psqlodbca.so
   Driver64	Path of the ODBC driver (64-bit)	Set the path of the ODBC driver (64-bit). Setting is not required when you are using a 32-bit operating system. If the encoding system is Unicode: symfowareServerClientInstallDir/odbc/lib/psqlodbcw.so If the encoding system is other than Unicode: symfowareServerClientInstallDir/odbc/lib/psqlodbca.so
   FileUsage	Use of the data source file	Specify 1.
   Threading	Level of atomicity secured for connection pooling	Specify 2.

   Example

   • Setting example when using 32-bit ODBC driver on 32-bit Linux

     [SymfowareServerV12.1.0unicode]
     Description = Symfoware Server V12.1.0 unicode driver
     Driver      = /opt/symfoclient32/odbc/lib/psqlodbcw.so
     FileUsage   = 1
     Threading   = 2

   • Setting example when using 64-bit ODBC driver on 64-bit Linux

     [SymfowareServerV12.1.0x64unicode]
     Description = Symfoware Server V12.1.0 x64 unicode driver
     Driver64    = /opt/symfoclient64/odbc/lib/psqlodbcw.so
     FileUsage   = 1
     Threading   = 2

   • Setting example when using both 32-bit and 64-bit ODBC drivers on 64-bit Linux

     [SymfowareServerV12.1.0unicode]
     Description = Symfoware Server V12.1.0 unicode driver
     Driver      = /opt/symfoclient32/odbc/lib/psqlodbcw.so
     FileUsage   = 1
     Threading   = 2
     
     [SymfowareServerV12.1.0x64unicode]
     Description = Symfoware Server V12.1.0 x64 unicode driver
     Driver64    = /opt/symfoclient64/odbc/lib/psqlodbcw.so
     FileUsage   = 1
     Threading   = 2