Symfoware Server V12.0.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]

   unixOdbcInstallationDir/etc/odbcinst.ini

   Set the following content:

   Definition name	Description	Setting value
   [Driver name]	ODBC driver name	Set the name of the ODBC driver. When the character set is EUC_JP or Shift-JIS on Linux (32-bit) "[SymfowareServerV12.0ansi]" When the character set is UTF-8 on Linux (32-bit) "[SymfowareServerV12.0unicode]" When the character set is EUC_JP or Shift-JIS on Linux (64-bit) "[SymfowareServerV12.0x64ansi]" When the character set is UTF-8 on Linux (64-bit) "[SymfowareServerV12.0x64unicode]"
   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). When the character set is EUC_JP or Shift-JIS /opt/symfoclient32/odbc/lib/psqlodbca.so When the character set is UTF-8 /opt/symfoclient32/odbc/lib/psqlodbcw.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. When the character set is EUC_JP or Shift-JIS /opt/symfoclient64/odbc/lib/psqlodbca.so When the character set is UTF-8 /opt/symfoclient64/odbc/lib/psqlodbcw.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.0unicode]
     Description = Symfoware Server V12.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.0x64unicode]
     Description = Symfoware Server V12.0x64 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.0unicode]
     Description = Symfoware Server V12.0 unicode driver
     Driver      = /opt/symfoclient32/odbc/lib/psqlodbcw.so
     FileUsage   = 1
     Threading   = 2
     
     [SymfowareServerV12.0x64unicode]
     Description = Symfoware Server V12.0x64 unicode driver
     Driver64    = /opt/symfoclient64/odbc/lib/psqlodbcw.so
     FileUsage   = 1
     Threading   = 2