ODBC Connection with C#

[Jehosephat]

I feel like I'm missing something obvious here but I can't seem to find out how to connect to the ODBC driver via C#. Can someone point me to an example?

Driver: MERANT 3.60 32-BIT Progress SQL92 v9.1D

Here's where I'm stuck:

OdbcConnection journalConnection = new OdbcConnection("DRIVER={????};SERVER=ROVXXXX;DATABASE=CC8X_Journ;UID=manager;PWD=\"manager\"");
journalConnection.Open();

Thanks!
Jeff

 

[Casper]

Use the DSN name:

string connectionString = "DSN=<dsnname>;" +
"UID=sysprogress;" +
"PWD=x";
IDbConnection dbconn;
dbconn = new OdbcConnection(connectionString);
dbconn.Open();

Casper

 

[rusguy]

Also (untested but i think it shold work) in case you dont want to use a DSN you can try to use a driver name and these parameters:

DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};
HOST=ROVXXXX;DATABASE=CC8X_Journ;UID=SYSPROGRESS;PWD=;
PORT=11090;

 

[4GLNewbie]

The .NET Framework Data Provider for ODBC wrapper class library can be used to connect to the Progress db, i think.

Try this connection string.

HOST=myServerAddress;DB=myDataBase;UID=myUsername;PWD=myPassword;PORT=port_number;

 

[Rajesh3182]

How to know the correct port number?

 

[Casper]

How to know the correct port number?

Ask the Progress DBA.