ODBC Error with Business Objects

R

r.mittal

New Member
Hi,

Well, to start with, my query is about Business Objects. I am having
Business Objects 6.5.1, PROGRESS 9.1D with MERANT 3.60 32-BIT Progress SQL92 v9.1D driver.

The problem is whenever I create any universe and connect it to a
progress database using the MERANT ODBC driver, it shows "Connection Established" and "Server is Responding". But, when I start creating classes and objects, and when I click on "Parse", it gives an error message "Parse failed: Exception DBD, [DataDirect-Technologies][ODBC PROGRESS Driver][PROGRESS]Access Denied(Authorisation
failed)(7512)State: S1000".

I have checked about this error in Business Objects' help but, to no avail.

Also, when I insert tables in the Universe Area, it shows two users
namely, "PUB" and "SYSPROGRESS". Please tell me from where have they come.

Please reply to this and help me ASAP.

Thanks in advance.
 
I have had this with BO and ODBC connectivity to Progress in general.

Ignore the connection established message, it just indicates that you have connected to the database, not whether you have rights to the database tables to retrieve data.

Which user did you connect to the database with?

It may be worth trying to connect with user name of 'sysprogress' with no password.

There is some useful info on using Business Objects with Progress on
http://www.bi4progress.nl/, that I have used in the past although I notice this site is closing at the end of the year.
 
It may be worth trying to connect with user name of 'sysprogress' with no password.
Click to expand...

I think it makes more sense to make a user sysprogress with a password in _user and then connect to the database with sysprogress and password. This way you have DBA priviliges.

For more information on security and SQL92: KB 20143:
http://tinyurl.com/o77l5

HTH,

Casper.
 
You must log in or register to reply here.
Back
Top