WebSphere Message Broker バージョン 8.0.0.5 オペレーティング・システム: AIX、HP-Itanium、Linux、Solaris、Windows、z/OS

製品の最新バージョンについては、IBM Integration Bus バージョン 9.0 をご覧ください。

WebSphere Message Broker ODBC 構成ファイルのサンプル

WebSphere® Message Broker に付属のサンプル ODBC 定義ファイルのコピー。

目的

サポートされるすべてのデータベースへの unixODBC 接続を定義するときに、odbc.ini ファイルと odbcinst.ini ファイルを構成します。 WebSphere Message Broker ODBC Database Extender を使用する Linux および UNIX システムからのデータベースへの接続の説明に従ってください。

このトピックの行の中には、読みやすくするために分割されているものがあります。ファイルのコピー内でこれらの行を分割しないでください。

サンプル用 odbc.ini ファイル

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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 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/db2o.o
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=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/V6.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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=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/sochia6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

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

Linux (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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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
;# 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/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux (System z®

;##########################################################################
;# 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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SQLSERVERDB=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=0
;# 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/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux (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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=0
;# 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/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux (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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=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/socl2x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

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

Solaris (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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 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.o
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=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/socs0x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

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

Solaris (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 6.0 ODBC Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
SYBASEDB=DataDirect 6.0 ODBC Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
SQLSERVERDB=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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/V6.0/lib/UKora24.so
Description=DataDirect 6.0 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
;# Sybase Stanza
[SYBASEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
LoginTimeout=0
;# 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
;##########################################
;###### Mandatory information stanza ######
;##########################################

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

サンプル用 odbcinst.ini ファイル

すべての UNIX および Linux システム

;##########################################################################
;# 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=2

変更の始まりUNIX および Linux システムでは、mqsicvp コマンドを実行することにより、ODBC 環境が正しく構成されていることを確認できます。 このコマンドはまた、mqsisetdbparms コマンドを使用してブローカーに関連付けられた、odbc.ini ファイルにリストされているすべてのデータ・ソースへの接続も検証します。 詳しくは、mqsicvp コマンドを参照してください。変更の終わり

特記事項 | 商標 | ダウンロード | ライブラリー | サポート | フィードバック

Copyright IBM Corporation 1999, 2014Copyright IBM Corporation 1999, 2014.

        
        最終更新:
        
        最終更新: 2015-02-28 17:49:17


参照トピック参照トピック | バージョン 8.0.0.5 | bk58070_