Access denied (Authorisation failed) (7512): when connect to progress from C#

[danch]

Hi all,

I write a simple code to get data from Progress DB and fill it to Dataset by C# but it always raise an error "Access denied (Authorisation failed) (7512)".

My c# code:

string odbcString = "DSN=ProgressODBC;Host=localhost;Port=7001;DB=xxxx;UID=xxxx;PWD=xxxx";
using (OdbcConnection Conn = new System.Data.Odbc.OdbcConnection(odbcString))
{
OdbcCommand cmd = new OdbcCommand("SELECT count(*) FROM pub.tablename", Conn);

Conn.Open();

OdbcDataAdapter odbcDA = new OdbcDataAdapter(cmd);

odbcDA.Fill(ds);

dataGridView1.DataSource = ds.Tables[0];
}

I use "Progress OpenEdge 10.2A Driver".

Any help will be appreciated
Dan

 

[RealHeavyDude]

Which user did you use to connect? Maybe a look at the knowledgebase article P14268 "When do I need to create a sysprogress user?" will shed some light on your problem.

HTH, RealHeavyDude.

 

[danch]

Hi RealHeavyDude,

It's worked now

Thanks a lot to you

Dan

 

[RealHeavyDude]

You're welcome.

Since the OpenEdge/Progress database is a 4GL database in the first place you need to prepare the database to be able to connect to it via ODBC/JDBC using the SQL engine.

Regards, RealHeavyDude.

 

[madhead]

Hi,

Can you use this approach to update values aswell as read them?

I was told by a supplier that the ODBC driver is read only?

Or is that just them trying to get money from me?

Cheers,
Mad

 

[RealHeavyDude]

An ODBC/JDBC connection per default is always working both ways ( reading and updating data ). Of course you could make it a read-only connection via several techniques and of course data security does play a role here.

But, if I would need to speculate then I would say your supplier is giving you bulls..t. Most likely they don't understand the thing at all.


Regards, RealHeavyDude