C#连接到进度数据库 [英] C# to connect to a Progress Database
问题描述
我正在尝试开发一个程序,该程序将使用C#(Visual Studio 2010 Ultimate)连接到进度数据库(9.1E),但是我首先需要从C#程序获取到进度数据库的连接字符串. /p>
我尝试了以下操作,但是无法建立与Progress数据库的连接.我不确定连接字符串应该是什么样子,但是这是我开始扩展所有内容之前的内容.另外,我不确定DSN名称是什么.
private void downloadData_Click(object sender, RoutedEventArgs e)
{
try
{
string connectString = "DSN = QADDB; Host = ipaddress; DB = dbname; UID = user; PWD = password;";
IDbConnection dbConn = new OdbcConnection(connectString);
dbConn.Open();
IDbCommand dbCommand = dbConn.CreateCommand();
string sqlstr = "SELECT pt_part FROM pt_mstr";
dbCommand.CommandText = sqlstr;
IDataReader reader = dbCommand.ExecuteReader();
while (reader.Read())
{
string part = (string)reader["pt_part"];
gridview.Items.Add(part);
}
reader.Close();
reader = null;
dbCommand.Dispose();
dbCommand = null;
dbConn.Close();
dbConn = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
错误消息显示:
System.Data.Odbc.OdbcException(0X80131937):错误[IM002] [Microsoft] [ODBC驱动程序管理器]找不到数据源名称,没有 指定默认驱动程序
string connectString = "DSN=QADDB;uid=username;pwd=password;host=hostname;port=port#;db=dbname;";
using (OdbcConnection dbConn = new OdbcConnection(connectString));
{
try
{
dbConn.Open();
} catch (Exception)
{
mRtnVar = "Couldn't Connect";
return mRtnVar
}
string sqlstr = string.Format(@"SELECT ""FieldName"" FROM PUB.DataBase WHERE ""FieldName"" = 'value'");
using (OdbcCommand comm = new OdbcCommand(sqlstr, dbConn))
{
using (OdbcDataReader reader = dbConn.ExecuteReader())
{
if (reader.Read())
{
mRtnVar = reader["FieldName"].ToString();
}
}
}
return mRtnVar
}
I'm trying to develop a program that will connect to a Progress Database (9.1E) using C# (Visual Studio 2010 Ultimate), but I first need to get a connection string to the Progress Database from the C# program.
I have tried the following, but I'm unsuccessful in establishing a connection to the Progress database. I'm not sure what the connection string should look like, but here's what I have before I start expanding everything. Also, I'm not sure what the DSN name should be.
private void downloadData_Click(object sender, RoutedEventArgs e)
{
try
{
string connectString = "DSN = QADDB; Host = ipaddress; DB = dbname; UID = user; PWD = password;";
IDbConnection dbConn = new OdbcConnection(connectString);
dbConn.Open();
IDbCommand dbCommand = dbConn.CreateCommand();
string sqlstr = "SELECT pt_part FROM pt_mstr";
dbCommand.CommandText = sqlstr;
IDataReader reader = dbCommand.ExecuteReader();
while (reader.Read())
{
string part = (string)reader["pt_part"];
gridview.Items.Add(part);
}
reader.Close();
reader = null;
dbCommand.Dispose();
dbCommand = null;
dbConn.Close();
dbConn = null;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
The error message says:
System.Data.Odbc.OdbcException (0X80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
string connectString = "DSN=QADDB;uid=username;pwd=password;host=hostname;port=port#;db=dbname;";
using (OdbcConnection dbConn = new OdbcConnection(connectString));
{
try
{
dbConn.Open();
} catch (Exception)
{
mRtnVar = "Couldn't Connect";
return mRtnVar
}
string sqlstr = string.Format(@"SELECT ""FieldName"" FROM PUB.DataBase WHERE ""FieldName"" = 'value'");
using (OdbcCommand comm = new OdbcCommand(sqlstr, dbConn))
{
using (OdbcDataReader reader = dbConn.ExecuteReader())
{
if (reader.Read())
{
mRtnVar = reader["FieldName"].ToString();
}
}
}
return mRtnVar
}
这篇关于C#连接到进度数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!