Kod koji koristim za konekciju sa bazom
string Connection string is: "Host=10.1.1.11 ; Port=446 ; User ID=userID ; Password=pass ; Database=S33G2003 ; Collection=DB; Charset For 65535=IBM037"
DataTable myDataTable
DB2Connection myConnection = new DB2Connection(ConnectionString)
try { myConnection.Open(); }
catch (DB2Exception es)
{ MessageBox.Show("Error " + es.Message); }
DB2Command myCommand = myConnection.CreateCommand();
myCommand.Connection = myConnection;
try
{
myCommand.CommandText = "SELECT * FROM myTable";
DB2DataReader myDataReader = myCommand.ExecuteReader();
myDataTable.Load(myDataReader);
}
catch (DB2Exception ex)
{ MessageBox.Show(ex.Message); }
try { myConnection.Close(); }
catch (DB2Exception es)
{ MessageBox.Show(es.Message); }
Hvala
Idemo dalje