Db2

Hi everyone, I'm using the net.ibm.data.db 7.0.0.2 driver (c# environment) to connect on i5/OS vers. 7R3 .. when i try to open a connection,  I get the error in the subject with any user I use (with qsecofr profile too).

the test code is very simple:

DB2ConnectionStringBuilder buildConf = new DB2ConnectionStringBuilder();

buildConf.UserID = ConfigurationManager.AppSettings["user"]; 
buildConf.Password = ConfigurationManager.AppSettings["psw"];
buildConf.Server = ConfigurationManager.AppSettings["server"];
buildConf.Database = ConfigurationManager.AppSettings["db"];

string ConnectionString = buildConf.ConnectionString;

DB2Connection conn = new DB2Connection(ConnectionString);

conn.Open();
conn.Close();
conn.Dispose();

Anyone have any suggestions?

What makes you think that user with given credentials actually CAN connect to target database?

Hi everyone, I'm using the net.ibm.data.db 7.0.0.2 driver (c# environment) to connect on i5/OS vers. 7R3 .. when i try to open a connection,  I get the error in the subject with any user I use (with qsecofr profile too).

the test code is very simple:

DB2ConnectionStringBuilder buildConf = new DB2ConnectionStringBuilder();

buildConf.UserID = ConfigurationManager.AppSettings["user"]; 
buildConf.Password = ConfigurationManager.AppSettings["psw"];
buildConf.Server = ConfigurationManager.AppSettings["server"];
buildConf.Database = ConfigurationManager.AppSettings["db"];

string ConnectionString = buildConf.ConnectionString;

DB2Connection conn = new DB2Connection(ConnectionString);

conn.Open();
conn.Close();
conn.Dispose();

Anyone have any suggestions?

Hi everyone, I'm using the net.ibm.data.db 7.0.0.2 driver (c# environment) to connect on i5/OS vers. 7R3 .. when i try to open a connection,  I get the error in the subject with any user I use (with qsecofr profile too).

the test code is very simple:

DB2ConnectionStringBuilder buildConf = new DB2ConnectionStringBuilder();

buildConf.UserID = ConfigurationManager.AppSettings["user"]; 
buildConf.Password = ConfigurationManager.AppSettings["psw"];
buildConf.Server = ConfigurationManager.AppSettings["server"];
buildConf.Database = ConfigurationManager.AppSettings["db"];

string ConnectionString = buildConf.ConnectionString;

DB2Connection conn = new DB2Connection(ConnectionString);

conn.Open();
conn.Close();
conn.Dispose();

Anyone have any suggestions?

Hi max inter,

a quick search via Google and your error message points me to "bind utilities" https://www.ibm.com/support/pages/sql30060n-error-during-rebind

Maybe you want to check, if the correct packages for the newer driver are bound.

I don't think, this issue https://www.ibm.com/support/pages/sql30060n-connecting-database will bite you here.

cheers

Hi everyone, I'm using the net.ibm.data.db 7.0.0.2 driver (c# environment) to connect on i5/OS vers. 7R3 .. when i try to open a connection,  I get the error in the subject with any user I use (with qsecofr profile too).

the test code is very simple:

DB2ConnectionStringBuilder buildConf = new DB2ConnectionStringBuilder();

buildConf.UserID = ConfigurationManager.AppSettings["user"]; 
buildConf.Password = ConfigurationManager.AppSettings["psw"];
buildConf.Server = ConfigurationManager.AppSettings["server"];
buildConf.Database = ConfigurationManager.AppSettings["db"];

string ConnectionString = buildConf.ConnectionString;

DB2Connection conn = new DB2Connection(ConnectionString);

conn.Open();
conn.Close();
conn.Dispose();

Anyone have any suggestions?