Arquivos de Configuração ODBC do WebSphere Message Broker

Uma cópia dos arquivos de definição ODBC de amostra que é fornecida com o WebSphere Message Broker.

Finalidade

Configure os arquivos odbc.ini e odbcinst.ini ao definir uma conexão unixODBC para todos os bancos de dados suportados. Siga as instruções no Conectando-se a um Banco de Dados a Partir dos Sistemas Linux e UNIX Utilizando o WebSphere Message Broker ODBC Database Extender.

Algumas linhas neste tópico foram divididas para melhorar a capacidade de leitura; você não deve dividir estas linhas em sua cópia do arquivo.

Arquivo de Amostra 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/db2o.o
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# UNIX para sub-rotina SQLServer
[SQLSERVERDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 ODBC SQL Server Wire Protocol
Address=<Seu Nome da Máquina SQLServer>,<Seu Número de Porta SQLServer>
;# Caminho alternativo para localizar o servidor usando uma instância denominada
;# Address=<Your SQLServer Machine Name>\<Your SQLServer
Instance Name>
AnsiNPW=Yes
Database=<Seu Nome do Banco de Dados>
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;# SolidDB Stanza
[SOLID_DB]
Driver=<Seu diretório de instalação SolidDB>/bin/soca5x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# UNIX para sub-rotina SQLServer
[SQLSERVERDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 ODBC SQL Server Wire Protocol
Address=<Seu Nome da Máquina SQLServer>,<Seu Número de Porta SQLServer>
;# Caminho alternativo para localizar o servidor usando uma instância denominada
;# Address=<Your SQLServer Machine Name>\<Your SQLServer
Instance Name>
AnsiNPW=Yes
Database=<Seu Nome do Banco de Dados>
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;# SolidDB Stanza
[SOLID_DB]
Driver=<Seu diretório de instalação SolidDB>/bin/sochia6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux em 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux em 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# UNIX para sub-rotina SQLServer
[SQLSERVERDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 ODBC SQL Server Wire Protocol
Address=<Seu Nome da Máquina SQLServer>,<Seu Número de Porta SQLServer>
;# Caminho alternativo para localizar o servidor usando uma instância denominada
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=<Seu Nome do Banco de Dados>
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Driver
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux em 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
# Sub-rotina DB2
[DB2DB]
Driver=<Seu diretório de instalação do DB2>/lib32/libdb2.so
Description=IBM DB2 ODBC Database
Database=DB2DB
# Oracle stanza
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
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=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta em que o Oracle está atendendo no host alternativo>:ServiceName=<Seu Nome de Serviço do Oracle Real Application Cluster>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ServerName=<Seu Nome do Servidor Sybase>
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ServerName=<Seu Nome do Servidor Sybase>
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# UNIX para sub-rotina SQLServer
[SQLSERVERDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 ODBC SQL Server Wire Protocol
Address=<Seu Nome da Máquina SQLServer>,<Seu Número de Porta SQLServer>
;# Caminho alternativo para localizar o servidor usando uma instância denominada
;# Address=<Your SQLServer Machine Name>\<Your SQLServer
Instance Name>
Database=<Seu Nome do Banco de Dados>
AnsiNPW=Yes
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Informix
[INFORMIXDB]
Driver=<Seu Diretório Informix Client>/lib/cli/iclit09b.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;# SolidDB Stanza
[SOLIDDB_DB]
Driver=<Seu diretório de instalação SolidDB>/bin/soc12x65.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Linux em 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# UNIX para sub-rotina SQLServer
[SQLSERVERDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 ODBC SQL Server Wire Protocol
Address=<Seu Nome da Máquina SQLServer>,<Seu Número de Porta SQLServer>
;# Caminho alternativo para localizar o servidor usando uma instância denominada
;# Address=<Your SQLServer Machine Name>\<Your SQLServer
Instance Name>
AnsiNPW=Yes
Database=<Seu Nome do Banco de Dados>
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;# SolidDB Stanza
[SOLID_DB]
Driver=<Seu diretório de instalação SolidDB>/bin/socl2x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Solaris em 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.o
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect ODBC 6.0 Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# UNIX para sub-rotina SQLServer
[SQLSERVERDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKmsss24.so
Description=DataDirect 6.0 ODBC SQL Server Wire Protocol
Address=<Seu Nome da Máquina SQLServer>,<Seu Número de Porta SQLServer>
;# Caminho alternativo para localizar o servidor usando uma instância denominada
;# Address=<Your SQLServer Machine Name>\<Your SQLServer
Instance Name>
AnsiNPW=Yes
Database=<Seu Nome do Banco de Dados>
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;# SolidDB Stanza
[SOLID_DB]
Driver=<Seu diretório de instalação SolidDB>/bin/socs0x6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Solaris em 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.                              #
;##########################################################################
;##########################################
###### Lista de sub-rotinas das origens de dados #######
;##########################################
[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
SOLIDDB_DB=IBM Solid DB ODBC Driver
;##########################################################
;########## Sub-rotinas de Origem de Dados Individuais ################
;##########################################################
;# Sub-rotina DB2
[DB2DB]
DRIVER=<Your DB2 install directory>/lib64/libdb2o.so
Description=IBM DB2 ODBC Database
Database=DB2DB
;# Sub-rotina Oracle
[ORACLEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Seu Nome de Serviço Oracle>
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Oracle Real Application Clusters
[ORACLERACDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKora24.so
Description=DataDirect 6.0 ODBC Oracle RAC Wire Protocol
HostName=<Nome da Máquina do Servidor Oracle>
PortNumber=<Porta na qual o Oracle está atendendo no HostName>
ServiceName=<Nome do Serviço do Oracle Real Application Cluster>
;#Isso mostra uma definição de servidor alternativa. Inclua definições extras usando uma ',' para separar cada definição.
AlternateServers=(HostName=<Seu nome de host alternativo>:PortNumber=<Número da porta
na qual o Oracle está atendendo no host alternativo>:ServiceName=<Seu
Nome do Serviço do Cluster de Aplicativo Real Oracle>)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0
;# Sub-rotina Sybase
[SYBASEDB]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Sybase para uma Origem de Dados UTF8
[SYBASEDBUTF8]
Driver=<Seu diretório de instalação do Broker>/ODBC/V6.0/lib/UKase24.so
Description=DataDirect 6.0 ODBC Sybase UTF8 Wire Protocol
Database=<Seu Nome do Banco de Dados>
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<Nome do seu Servidor Sybase>,<Número da sua Porta Sybase>
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3
;# Sub-rotina Informix
[INFORMIXDB]
Driver=libinfWrapper.so
Description=IBM Informix ODBC Database
ServerName=<Seu Nome de Servidor Informix>
Database=<Seu Nome do Banco de Dados>
;# SolidDB Stanza
[SOLID_DB]
Driver=<Seu diretório de instalação SolidDB>/bin/socs0xi6465.so
Description=IBM Solid DB ODBC database
Database=SOLIDDB_DB
;##########################################
;###### Mandatory information stanza ######
;##########################################

[ODBC]
InstallDir=<Seu diretório de instalação do Broker>/ODBC/V6.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

Arquivo de Amostra odbcinst.ini

Todas as plataformas UNIX e 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=<Um Diretório com grande quantidade de espaço livre para conter a saída do rastreio>/odbctrace.out
Threading=2
Avisos | Marcas Registradas | Downloads | Biblioteca | Suporte | Feedback

Copyright IBM Corporation 1999, 2013Copyright IBM Corporation 1999, 2013.

        
        Última atualização
        
        Última atualização : 2013-02-27 20:25:43


Tópico de ReferênciaTópico de Referência | Versão 8.0.0.2 | bk58070_