Skip to Content
0
Mar 26, 2010 at 08:03 AM

How to use Data Direct ODBC drivers 5.3 for AS400 connection

149 Views

Dear Experts,

We've installed Data Services XI 3.2 on Suse linux 10, we want to use odbc connection for data transfer from OS400 iseries and Sql Server 2005,

We installed data driver 5.3 on data services server, i think next step is updating the odbc.ini file Db2 Wire Protocol, so which informations we need to enter in odbc.ini file, could you please help ?

Here is the odbc.ini file example ;

[DB2 Wire Protocol]

Driver=/usr/sap/data_direct/DataDirect_5.3_Linux64_x86/lib/DAdb223.so

Description=DataDirect 5.3 DB2 Wire Protocol

AddStringToCreateTable=

AlternateID=

AlternateServers=

ApplicationUsingThreads=1

AuthenticationMethod=0

CatalogSchema=

CharsetFor65535=0

#Collection applies to z/OS and iSeries only

Collection=

ConnectionRetryCount=0

ConnectionRetryDelay=3

#Database applies to DB2 UDB only

Database=<database_name>

DefaultIsolationLevel=1

DynamicSections=200

EncryptionMethod=0

GrantAuthid=PUBLIC

GrantExecute=1

GSSClient=native

HostNameInCertificate=

IpAddress=<DB2_server_host>

LoadBalancing=0

#Location applies to z/OS and iSeries only

Location=<location_name>

LogonID=

Password=

PackageCollection=NULLID

PackageOwner=

ReportCodePageConversionErrors=0

TcpPort=50000

TrustStore=

TrustStorePassword=

UseCurrentSchema=1

ValidateServerCertificate=1

WithHold=1

XMLDescribeType=-10

Best Regards