WebSphere® Message Broker に付属のサンプル ODBC 定義ファイルのコピー。
このトピックの行の中には、読みやすくするために分割されているものがあります。ファイルのコピー内でこれらの行を分割しないでください。
;########################################################################## ;# 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 Oracle Wire Protocol ORACLERACDB=DataDirect 6.0 Oracle Wire Protocol (Real Application Clusters) SYBASEDB=DataDirect 6.0 Sybase Wire Protocol SYBASEDBUTF8=DataDirect 6.0 Sybase UTF8 Wire Protocol SQLSERVERDB=DataDirect 6.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver SOLIDDB_DB=IBM solidDB Datasource
;########################################################## ;########## Individual data source stanzas ################ ;##########################################################
;# DB2 stanza [DB2DB] DRIVER=<Your DB2 install directory>/lib64/db2o.o Description=DB2DB DB2 ODBC Database Database=DB2DB
;# Oracle stanza [ORACLEDB] Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKora24.so Description=DataDirect 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 Oracle 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>
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port 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 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
;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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
Charset=UTF8
LoginTimeout=0
TimestampTruncationBehavior=1
;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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=db
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>
;# SolidDB Stanza [SOLID_DB] Driver=<Your solidDB Install Directory>/bin/saca5x6465.so Description=Solid_DB ODBC Database Database=SOLID_DB
;########################################## ;###### Mandatory information stanza ###### ;########################################## [ODBC] ;# To turn on ODBC trace set Trace=1 Trace=0 TraceOptions=3 TraceFile=<A Directory with plenty of free space to hold trace output>/odbctrace.out TraceDll=<Your Broker install directory>/ODBC/V6.0/lib/odbctrac.so InstallDir=<Your Broker install directory>/ODBC/V6.0 UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
;########################################################################## ;# 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 Oracle Wire Protocol ORACLERACDB=DataDirect 6.0 Oracle Wire Protocol (Real Application Clusters) SYBASEDB=DataDirect 6.0 Sybase Wire Protocol SYBASEDBUTF8=DataDirect 6.0 Sybase UTF8 Wire Protocol SQLSERVERDB=DataDirect 6.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver SOLIDDB_DB=IBM solidDB Datasource
;########################################################## ;########## Individual data source stanzas ################ ;##########################################################
;# DB2 stanza [DB2DB] Driver=<Your DB2 install directory>/lib32/libdb2.so Description=DB2 ODBC Database Database=DB2DB
;# Oracle stanza
[ORACLEDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 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 Cluster stanza [ORACLERACDB] Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKor824.so Description=DataDirect 6.0 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 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
;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 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
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Informix Stanza [INFORMIXDB] Driver=<Your Informix Client Directory>/lib/cli/iclit09b.so Description=IBM Informix ODBC Driver ServerName=<Your Informix Server Name> Database=<Your Database Name>
;# SolidDB Stanza [SOLID_DB] Driver=<Your solidDB Install Directory>/bin/saca5x6465.so Description=Solid_DB ODBC Database Database=SOLID_DB
;########################################## ;###### Mandatory information stanza ###### ;########################################## [ODBC] ;# To turn on ODBC trace set Trace=1 Trace=0 TraceOptions=3 TraceFile=<A Directory with plenty of free space to hold trace output>/odbctrace.out TraceDll=<Your Broker install directory>/ODBC/V6.0/lib/odbctrac.so InstallDir=<Your Broker install directory>/ODBC/V6.0 UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
;########################################################################## ;# 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 Oracle Wire Protocol
ORACLERACDB=DataDirect 6.0 Oracle Wire Protocol (Real Application Clusters)
SYBASEDB=DataDirect 6.0 Sybase Wire Protocol
SYBASEDBUTF8=DataDirect 6.0 Sybase UTF8 Wire Protocol
INFORMIXDB=IBM Informix ODBC Driver
SOLIDDB_DB=IBM solidDB Datasource
;########################################################## ;########## Individual data source stanzas ################ ;##########################################################
;# DB2 stanza [DB2DB] DRIVER=<Your DB2 install directory>/lib64/libdb2o.so Description=DB2DB DB2 ODBC Database Database=DB2DB
;# Oracle stanza [ORACLEDB] Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKora24.so Description=DataDirect 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 Oracle 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>
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port 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.s0
Description=DataDirect 6.0 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
;# Sybase Stanza for a UTF8 datasource
[SYBASEDBUTF8]
Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 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
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
;# Informix Stanza [INFORMIXDB] Driver=libinfWrapper.so Description=IBM Informix ODBC Driver ServerName=<Your Informix Server Name> Database=<Your Database Name>
;# SolidDB Stanza [SOLID_DB] Driver=<Your solidDB Install Directory>/bin/saca5x6465.so Description=Solid_DB ODBC Database Database=SOLID_DB
;########################################## ;###### Mandatory information stanza ###### ;########################################## [ODBC] ;# To turn on ODBC trace set Trace=1 Trace=0 TraceOptions=3 TraceFile=<A Directory with plenty of free space to hold trace output>/odbctrace.out TraceDll=<Your Broker install directory>/ODBC/V6.0/lib/odbctrac.so InstallDir=<Your Broker install directory>/ODBC/V6.0 UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8
;########################################################################## ;# 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 Oracle Wire Protocol ORACLERACDB=DataDirect 6.0 Oracle Wire Protocol (Real Application Clusters) SQLSERVERDB=DataDirect 6.0 SQL Server Wire Protocol INFORMIXDB=IBM Informix ODBC Driver
;########################################################## ;########## Individual data source stanzas ################ ;##########################################################
;# DB2 stanza [DB2DB] DRIVER=libdb2o.so Description=DB2DB DB2 ODBC Database Database=DB2DB
;# Oracle stanza [ORACLEDB] Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKora24.so Description=DataDirect 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 Oracle 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>
AlternateServers=(HostName=<Your alternative host name>:PortNumber=<Port 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
;# SQLServer stanza [SQLSERVERDB] Driver=<Your Broker install directory>/ODBC/V6.0/lib/UKmsss24.so Description=DataDirect 6.0 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=db 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] ;# To turn on ODBC trace set Trace=1 Trace=0 TraceOptions=3 TraceFile=<A Directory with plenty of free space to hold trace output>/odbctrace.out TraceDll=<Your Broker install directory>/ODBC/V6.0/lib/odbctrac.so InstallDir=<Your Broker install directory>/ODBC/V6.0 UseCursorLib=0 IANAAppCodePage=4 UNICODE=UTF-8