Friday, June 08, 2007 5:24 AM
Hai All Gurus,
I am working with Progess OpenEdge DataBase.My problem is that i want to know how to connect with the database using ODBC connection from C#.NET. it is very help full to me if any one provide step-by-step solution for this problem. Thanks in advance.
Sunday, June 10, 2007 3:56 AM
http://www.connectionstrings.com is the resource to get the connectionstrin you need.
This KB shows how to use it
Monday, June 04, 2012 5:47 AM
Are you able to connect the Progress OpenEdge Database from C#.Net?
Tuesday, June 12, 2012 11:38 AM
Yes. OpenEdge expose ODBC driver by which you can connect from C#.
A safer way is to create DSN and give the DSN name as reference to your ado.net ODBC connection object.
To configure a DSN, you can follow step by step document mentioned by Progress here,
In C#, you can open a ODBC connection with mentioning Connection string referred to the DSN name created in Step One.
System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection (); // TODO: Modify the connection string and include any // additional required properties for your database. conn.ConnectionString = "DSN=YourDsnNameCreatedbyStepOne; Uid=myUsername;Pwd=;";
Then you can use normal Ado.net ODBCAdopter,Dataset,ODBCCommand to do any CRUD operation.
You may also like the the complete document Communications between OpenEdge and dotNET.doc by progress.
Recently I learned that, OpenEdge has its own API for .Net to connect in native way. This will give batter performance and many more features which ODBC cannot. You can refer the API documentation from here,
Anyway these API are not supported by micrsoftforum as it is developed by Progress, So for any query on this API, you can always use Openedge forum as below.
- Proposed As Answer by sanny521 Tuesday, June 19, 2012 9:24 AM
Tuesday, June 19, 2012 9:24 AM
I will try and let you know..