Reputation: 2209
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:
I created System DSN - System: 10.33.15.3, DSN Name: mm370lib, Driver: iSeries Access ODBC Driver
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
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
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