rechie
rechie

Reputation: 2209

DB2 iSeries AS400 - Database Connection

I am having problem connecting to iSeries DB2 using IBM.Data.DB2.iSeries, but I can easily connect using System.Data.Odbc

Using System.Data.Odbc:

  1. I created System DSN - System: 10.33.15.3, DSN Name: mm370lib, Driver: iSeries Access ODBC Driver

  2. With C# Odbc connection string: "Dsn=mm370lib;Uid=myUsername;Pwd=myPassword;"

How do I make a connection using IBM.Data.DB2.iSeries?

Upvotes: 5

Views: 17297

Answers (2)

rechie
rechie

Reputation: 2209

Finally, I have successfully connect using "IBM Client Access OLE DB provider" with connection string format taken from http://www.connectionstrings.com/as-400#p60.

Provider=IBMDA400;Data Source=MY_SYSTEM_NAME;User Id=myUsername;Password=myPassword;Default Collection=MY_LIBRARY;

So my actual connection string using the parameters above is:

Provider=IBMDA400;Data Source=10.33.15.3;User Id=ICTDEV;Password=******;Default Collection=mm370lib;

I've been using this connection also in my PHP program using COM.

Here is the code snippet:

include('application/libraries/adodb5/adodb.inc.php');
$this->db = ADONewConnection('ado');
$dsn = "Provider=IBMDA400;Data Source=10.33.15.3;UserId=ICTDEV;Password=******;Default Collection=mm370lib;";
$this->db->PConnect($dsn);

Upvotes: 3

Steve
Steve

Reputation: 216243

Taken directly from ConnectionStrings

ODBC
Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;Pwd=myPassword;

NET
DataSource=myServerAddress;UserID=myUsername;Password=myPassword; DataCompression=True;

Upvotes: 2

Related Questions