IBM Integration Bus, Version 9.0.0.8 Operating Systems: AIX, HP-Itanium, Linux, Solaris, Windows, z/OS

See information about the latest product version

Sample IBM Integration Bus ODBC configuration files

A copy of the sample ODBC definition files that are supplied with IBM® Integration Bus.

Purpose

Configure the odbc.ini and odbcinst.ini files when you define a unixODBC connection to all supported databases. Follow the instructions in Connecting to a database from Linux and UNIX systems by using the IBM Integration ODBC Database Extender.

Some lines in this topic have been split to improve readability; you must not split these lines within your copy of the file.

Sample odbc.ini file
Sample odbcinst.ini file

SQL Server driver UKsqls26.so was introduced with IBM Integration Bus V9.0.0.3. If you are at an earlier version than V9.0.0.3, SQL Server driver UKmsss26.so should be used.

Sample odbc.ini file

AIX®

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Legacy Wire Protocol
SQLSERVERWP=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver
IDSDB=IBM Informix Data Server Driver for ODBC and CLI

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/db2o.o
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
EncryptionMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza using the SQL Server Legacy Wire Protocol driver
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# UNIX to SQLServer stanza using the SQL Server Wire Protocol driver
[SQLSERVERWP]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKsqls26.so
Description=DataDirect 7.1 SQL Server Wire Protocol
Database=<Your Database Name>
HostName=<Your SQLServer Machine Name>
PortNumber=<Your SQLServer Port Number>
AnsiNPW=1
LoginTimeout=0
QueryTimeout=0

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;# SolidDB Stanza
[SOLID_DB]
Driver=<Your SolidDB install Directory>/bin/soca5x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

HP-Itanium

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;# SolidDB Stanza
[SOLID_DB]
Driver=<Your SolidDB install Directory>/bin/sochia6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux on POWER®

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux on IBM z Systems

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;#Alternative way to locate server using a named instance
;#Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Driver
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux on x86

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

# DB2 stanza
[DB2DB]
Driver=<Your DB2 install directory>/lib32/libdb2.so
Description=IBM DB2 ODBC Database
Database=DB2DB

# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

# Oracle Real Application Cluster stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative hostname>:PortNumber=<Port number on which Oracle is listening on the alternative host>:ServiceName=<Your Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ServerName=<Your Sybase Server Name>
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ServerName=<Your Sybase Server Name>
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
Database=<Your Database Name>
AnsiNPW=Yes
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=<Your Informix Client Directory>/lib/cli/iclit09b.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;# SolidDB Stanza
[SOLIDDB_DB]
Driver=<Your SolidDB install Directory>/bin/soc12x65.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux on x86-64

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;# SolidDB Stanza
[SOLID_DB]
Driver=<Your SolidDB install Directory>/bin/socl2x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Solaris on SPARC

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;# 2. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 3. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;##########################################################################

;##########################################
;###### List of data sources stanza #######
;##########################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;# SolidDB Stanza
[SOLID_DB]
Driver=<Your SolidDB install Directory>/bin/socs0x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Solaris on x86-64

;##########################################################################
;# ODBC database driver manager initialisation file.                      #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. For each data source, add the name of the data source into          #
;# the 'List of data sources stanza' section.                             #
;#                                                                        #
;# 2. For each data source, create a stanza in the                        #
;# 'Individual data source stanzas' section.                              #
;#                                                                        #
;##########################################################################

;#######################################
;#### List of data sources stanza ######
;#######################################
[ODBC Data Sources]
DB2DB=IBM DB2 ODBC Driver
ORACLEDB=DataDirect 7.1 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
ORACLESSLDB=DataDirect 7.1 ODBC Oracle SSL Wire Protocol
SYBASEDB=DataDirect 7.1 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 7.1 ODBC SQL Server Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM Solid DB ODBC Driver
IDSDB=IBM Informix Data Server Driver for ODBC and CLI

;##########################################################
;########## Individual data source stanzas ################
;##########################################################

;# DB2 stanza
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB

;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle Real Application Clusters stanza
[ORACLERACDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle RAC Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Real Application Cluster Service Name>
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port number on
which Oracle is listening on the alternative host>:ServiceName=<Your
Oracle Real Application Cluster Service Name>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0

;# Oracle using SSL stanza
[ORACLESSLDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.1 ODBC Oracle Wire Protocol
HostName=<Your Oracle Server Machine Name>
PortNumber=<Port on which Oracle is listening on HostName>
ServiceName=<Your Oracle Service Name>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
AuthenticationMethod=1
EncryptionMethod=1
KeyPassword=<Your SSL Key Password>
KeyStore=<Your fully qualified key store file name>
KeyStorePassword=<Your SSL Key Store Password>
TrustStore=<Your fully qualified trust store file name>
TrustStorePassword=<Your SSL Trust Store Password>
ValidateServerCertificate=1

;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.1 ODBC Sybase UTF8 Wire Protocol
Database=<Your Database Name>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Your Sybase Server Name>,<Your Sybase Port Number>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3

;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.1 ODBC SQL Server Wire Protocol
Address=<Your SQLServer Machine Name>,<Your SQLServer Port Number>
;#Alternative way to locate server using a named instance
;#Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Your Database Name>
QuotedId=No
ColumnSizeAsCharacter=1

;# Informix Stanza
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Your Informix Server Name>
Database=<Your Database Name>

;# SolidDB Stanza
[SOLIDDB_DB]
Driver=<Your SolidDB install Directory>/bin/socs0xi6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB

;# IDS stanza
[IDSDB]
DRIVER=<Your Data Server Driver Package install directory>/lib/libdb2o.so
Description=IBM Informix DRDA Database
Database=IDSDB

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Your Broker install directory>/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Sample odbcinst.ini file

All UNIX and Linux systems

;##########################################################################
;# ODBC database driver manager system initialisation file.               #
;##########################################################################
;# It is recommended that you take a copy of this file and then edit the  #
;# copy.                                                                  #
;#                                                                        #
;# 1. Complete the 'Mandatory information stanza' section                 #
;# at the end of the file.                                                #
;#                                                                        #
;##########################################################################

;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
;# To turn on trace set Trace=yes
Trace=no
TraceFile=<A Directory with plenty of free space to hold trace output>/odbctrace.out
;# Threading is not a configurable property
Threading=2

On UNIX and Linux systems, you can check that the ODBC environment is configured correctly by running the mqsicvp command. This command also validates the connection to all data sources that are listed in the odbc.ini file that have been associated with a broker by using the mqsisetdbparms command. For more information, see mqsicvp command.

bk58070_.htm |

Last updated Friday, 21 July 2017