odbc.ini

;##########################################################################
;# 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]


ORACLEDB=DataDirect 7.0 ODBC Oracle Wire Protocol
SQLSERVERDB=DataDirect 7.0 ODBC SQL Server Wire Protocol
SYBASEDB=DataDirect 7.0 ODBC Sybase Wire Protocol
;###########################################
;###### Individual data source stanzas #####
;###########################################


;# Oracle stanza
[ORACLEDB]
Driver=/opt/ibm/mqsi/8.0.0.3/ODBC/V7.0/lib/UKora26.so
Description=DataDirect 7.0 ODBC Oracle Wire Protocol
HostName=10.0.10.217
PortNumber=1521
ServiceName=oradb
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
LoginTimeout=0


;# UNIX to SQLServer stanza
[SQLSERVERDB]
Driver=/opt/ibm/mqsi/8.0.0.3/ODBC/V7.0/lib/UKmsss26.so
Description=DataDirect 7.0 ODBC SQL Server Wire Protocol
Address=10.0.3.21,1433
;# Alternative way to locate server using a named instance
;# Address=<Your SQLServer Machine Name>\<Your SQLServer Instance Name>
AnsiNPW=Yes
Database=WFMIS
QuotedId=No
ColumnSizeAsCharacter=1
LoginTimeout=0


;# Sybase Stanza
[SYBASEDB]
Driver=/opt/ibm/mqsi/8.0.0.3/ODBC/V7.0/lib/UKase26.so
Description=DataDirect 7.0 ODBC Sybase Wire Protocol
Database=ssmis
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=10.0.3.25,5000
SelectUserName=1
ColumnSizeAsCharacter=1
EnableSPColumnTypes=2
LoginTimeout=0
TimestampTruncationBehavior=1
XAConnOptBehavior=3


;# Oracle Real Application Clusters stanza
;##########################################
;###### Mandatory information stanza ######
;##########################################


[ODBC]
InstallDir=/opt/ibm/mqsi/8.0.0.3/ODBC/V7.0
UseCursorLib=0
IANAAppCodePage=4
UNICODE=UTF-8