Search code examples
c#sqlopenedgeprogress-db

Connect to a progress openedge database from C#


Is it possible to connect to a Progress openedge database in C# and ask it progress questions? In threads like: C# to connect to a Progress Database

You show how its done, but you only reach the slow SQL engine. Isnt it possible to reach real progress engine? Today our company use a webservice to reach Progress openedge data.

/Staffan


Solution

  • Use the Progress Openedge ODBC driver. I was able to do this by creating a DSNLess connection in my C# code to connect to the database.

    Here is some of the code:

     OdbcConnection DBConnectionTester = new OdbcConnection("Driver={" + ODBCDriverName + "};DB=" + DatabaseName + ";host=" + HostServerName + ";port=" + HostPortnumber + ";UID=" + ODBCusername + ";PWD=" + ODBCPassword + ";DIL=" + isolationlevel);