Consultor Eletrônico

Status: Unverified

GOAL:

C# sample code to connect a Progress Database

GOAL:

Can I use C# to connect a Progress database ?

FACT(s) (Environment):

Progress 9.1x
OpenEdge 10.x

FIX:

It is possible to have C# code accessing a Progress database via ODBC,
this sample code shows, how a simple C# code, can use an ODBC DSN to connect a Progress Database:
using System;
using System.Data;
using System.Data.Odbc;

public class TestConnect
{
public static void Main(string[] args)
{
//The connection string assumes there is a DSN named sports for a Progress database
string connectionString = "DSN=sports;" +
"UID=sysprogress;" +
"PWD=x";
IDbConnection dbconn;
dbconn = new OdbcConnection(connectionString);
dbconn.Open();
IDbCommand dbcmd = dbconn.CreateCommand();
string sqlstr = "SELECT country,name FROM pub.customer";
dbcmd.CommandText = sqlstr;
IDataReader reader = dbcmd.ExecuteReader();
while(reader.Read()) {
string country = (string) reader["country"];
string name = (string) reader["name"];
Console.WriteLine("Customer : " + name + " country is: " + country );
}
reader.Close();
reader = null;
dbcmd.Dispose();
dbcmd = null;
dbconn.Close();
dbconn = null;
}
}