C#连接到进度数据库

本文介绍了C#连接到进度数据库的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试开发一个程序，该程序将使用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 }