problem to access Progress DB via ODBC

T

tchupin

New Member
I try to access a Progress V9.1D database on a HPUX server fromawindows 2000 client with the MERANT 3.60 32-BIT Progress SQL92 v9.1Ddriver.

From Brio or Excel, I can see the tables of the Progress database, but when I do a simple retrieve, I have the following error :

SQLExecDirect1:rc=-1, SQLSTATE:S1000,ErrorMsg:[DataDirect-Technologies][ODBCPROGRESSdriver][PROGRESS]Accèsrefusé[Autorisationa échoué]. [7512]

Is someone can help me ?

Thierry
 
I have created a user "thch" in the Progress database with a password.
I put this user and password in the odbc.ini file on the Progress Unix Server.
When I connect to the DSN from the Windows client, I use this user.
But when I look to the odbc log file on the Windows client, I see that the SQL order which is sent to the server is "SELECT * FROM PUB.diligcde".

I try to create a "PUB" user in the progress database, and doing this, it works. I succeeded to retrieve data from Brio on the Windows client.

Does another solution exist to retrieve data without creating the "PUB" user ?

Thanks
 
PUB should not be a user... You should grant rights to your user "thch" to the tables the user needs to access. See also Progress Knowledge base entry 19170 (and many others in the KB) about using a Progress database with SQL 92. You can use http://www.techweb.progress.com to search for more information regarding SQL access to a Progress db.
 
I granted rights to the user "thch" to the tables the user needs to access, but when I connect to the DSN on the Windows client with the user thch, the SQL order sent to the server is "select * from PUB.diligcde".
Without creating the PUB user on the database server, it doesn't work.

I tried the http://www.techweb.progress.com link, but it doesn't work.
 
You must log in or register to reply here.
Back
Top