How to Connect.

Question

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.

 

Rgds,

Answer 1

http://www.connectionstrings.com is the resource to get the connectionstrin you need.
http://www.connectionstrings.com/?carrier=progress

 

This KB shows how to use it
http://support.microsoft.com/kb/310988

Answer 2

Hi Shaji,

Are you able to connect the Progress OpenEdge Database from C#.Net?

Thanks,
Krishna

---

Krishnasandeep

Answer 3

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.

Step One

To configure a DSN, you can follow step by step document mentioned by Progress here,

http://www.oehive.org/files/Enterprise%20Architect%20-%20OpenEdge%2010%20Database%20Configuration%20Guide.doc

Step Two

In C#, you can open a ODBC connection with mentioning Connection string referred to the DSN name created in Step One.

Refer: http://msdn.microsoft.com/en-us/library/aa984313(v=vs.71).aspx

Or

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.

Refer: http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcdataadapter(v=vs.71).aspx

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,

<cite>http://documentation.progress.com/output/OpenEdge102b/pdfs/dvnet/dvnet.pdf</cite>

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.

http://<cite>communities.progress.com/pcom/community/psdn/openedge/architect</cite>

---

Lingaraj Mishra

Answer 4

Thanks Mishra.

I will try and let you know..

---

Krishnasandeep