Question

ODBC 如何连接 DB2

ODBC 如何连接 DB2

Answer 1

//使用ODBC连接DB2
private void button1_Click(object sender, EventArgs e)
{
string conString = @"driver={IBM DB2 ODBC DRIVER};database=devp;hostname=172.20.30.107;
port=50000;protocol=TCPIP;uid=db2inst1;pwd=db2; CurrentSchema=TK";
OdbcConnection con = new OdbcConnection(conString);
con.Open();
OdbcCommand cmd = new OdbcCommand("select * from tbdesign", con);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("OK");
}