db2 Zugriff
im Projekt Verweis auf ibm.data.db2.dll
using IBM.Data.DB2;
private void test
{
String MyDb2ConnectionString = "";
MyDb2ConnectionString = "Server=server:50000;Database=D3P;UID=user;PWD=passwort;";
DB2Command MyDB2Command = null;
DB2Connection MyDb2Connection = new DB2Connection(MyDb2ConnectionString);
MyDb2Connection.Open();
MyDB2Command = MyDb2Connection.CreateCommand();
MyDB2Command.CommandText = "SELECT * from Schema.Tabelle where Feld1 = 'aaaa'";
Console.WriteLine(MyDB2Command.CommandText);
DB2DataReader MyDb2DataReader = null;
MyDb2DataReader = MyDB2Command.ExecuteReader();
while (MyDb2DataReader.Read())
{
try
{
MessageBox.Show(MyDb2DataReader["Feldname"].ToString());
}
catch (Exception e)
{
Console.Write(e.ToString());
}
}
MyDb2DataReader.Close();
MyDB2Command.Dispose();
MyDb2Connection.Close();
}
Access Zugriff
OleDbConnection TTTConn;
OleDbCommand oleDbCmd = new OleDbCommand();
String connParam = @“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c‘:\daten\db.mdb‘;Persist Security Info=False“;
TTTConn = new OleDbConnection(connParam);
InitializeComponent();
TTTConn.Open();