error 7512

[happylucho]

Hi (sorry my english)
I've a progess 9.1d db and try to acces with merant 3.6 odbc driver. When configure the ODBC and test conection work fine, I can read with Brio Query v6 the db structure work fine, but I can't read the data.

The system respond:

SQLExecDirect 1:rc=-1 SQLSTATE S:1000 , Error msg :[DataDirect-Technologies][ODBC PROGRESS driver][PROGRESS]Access denied(Authorization failed)(7512)

I try to connect to QAD mfg database.

Any ideas????

Thanks,

Lucho

 

[Casper]

When using sql92 you have to give acces to the database.tables for some or all users.

Use sql explorer with the default users sysprogress and give the users permission for the tables you want to see.

Look at KB: P21021 and 20143 for some more explanation.

HTH,

Casper.

 

[happylucho]

Casper, big problem: I can't grant acces with sysprogress user!!

We use a qad database. I presume that this user was erased!!

????

 

[Casper]

If you create user sysprogress with password then you should be able to login. The creator of the databse also has DBA permissions, so that should work as well.

Casper.