Cannot Insert Data into Tables via C#/ODBC

[asimhg]

Hi there,

I am trying to insert data into a Progress table via C# using ODBC but I get the "Access denied (Authorization failed)" message.

I can query the tables to retrieve results (using the Select statement) but cannot insert data.

Any suggestions ?


Thanks,

 

[RealHeavyDude]

You don't say anything about your Progress/OpenEdge version.

Which user do you use to connect to the Progress database?
Did you grant write privileges to that user for the particular tables?


Regards, RealHeavyDude.

 

[asimhg]

Hi RealHeavyDude,

Thanks for replying to my post.

Here is the information you asked for:

1) OpenEdge ver 10.1 C
2) We are using a user created by Sysprogress
3) That user has write permissions to the table


Thanks,

 

[RealHeavyDude]

Just to make sure that we understand each other.

The error message you are seeing is indicating that the user under which you want to update the data does not have write privileges granted on the database table.

You must grant the write privilege to that user while logged in as SYSPROGRESS. Be sure to commit the grant.

It might be confusing, but the security for the SQL92 and the 4GL engine are handled differently. The 4GL engine is using the corresponding settings in the 4GL schema ( for example CAN-WRITE ), but the SQL92 engine does not use these setting. You must explicitely grant these privileges using the SQL92 engine ( via the ODBC connection ) to be acknolewdged by the SQL92 engine.

HTH, RealHeavyDude.