Pages

Friday, May 27, 2011

WebSphere Message Broker odbc.ini 32 bit and 64 bit files in UNIX.

Broker to access any database. You need to make a stanza in the .odbc.ini file. The configuration is slightly differs from 32bit to 64bit. 





##########################################################################
# 32 bit 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]
WMBDB1=IBM DB2 version 8 ODBC Driver


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


# DB2 version 8 stanza
[WMBDB1]
ServerName=WMBDB1
Driver=/export/home/db2usr1/sqllib/lib/libdb2.so
Description=DB2V8DB DB2 ODBC Database
Database=WMBDB1




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


[ODBC]
# To turn on ODBC trace set Trace=1
Trace=1
TraceFile=/.../IBM/mqsi/6.1/odbctrace.out
TraceDll=/.../IBM/mqsi/6.1/ODBC32/V5.3/lib/odbctrac.so
InstallDir=/.../IBM/mqsi/6.1/ODBC32/V5.3
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8

 ######## END of 32 bit ODBC file#########




--------------------------------------------------------------------------------------------------------------





#######################################
#### 64 bit ODBC database driver manager initialisation file. ######
#######################################


[ODBC Data Sources]
WMBDB1=IBM DB2 ODBC Driver


##########################################################
########## Individual data source stanzas ################
########################################################## 
# DB2 stanza
[WMBDB1]
ServerName=WMBDB1
Driver=libdb2Wrapper64.so
Description=DB2DB DB2 ODBC Database
Database=WMBDB1


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


[ODBC]
# To turn on ODBC trace set Trace=1
Trace=1
TraceFile=/..../IBM/mqsi/odbctrace64.out
TraceDll=/..../IBM/mqsi/6.1/ODBC64/V5.3/lib/odbctrac.so
InstallDir=/..../IBM/mqsi/6.1/ODBC64/V5.3
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8


################## END of 64 bit ODBC file####################






Suggestions are always welcome...! Without signing also you can send your comments. 

No comments: