CR 2008 Issue

building reports crystal reports
1

Hi,

Im not sure if Im missing something really simple but here goes.

On my local machine I created a CR going against Oracle using a ‘Microsoft ODBC for Oracle’ system DSN.

Report runs fine, refreshes fine.

I published this to a folder within BusinessObjects XI 3.1 and when I try to refresh this from Infoview, I get the error “The database logon information for this report is either incomplete or incorrect.”

I have created the exact same ODBC connection on the server. I have also gone into the CMC and tried to enter the password for that object.

What am I missing?

Thanks,

Amit

amitmishra4 :us: (BOB member since 2007-11-05)

2

Try designing the report on the server and refreshing it. That may show you a better error message.

tbrady (BOB member since 2007-09-25)

3

Did you test the ODBC on the job server itself? Not sure about Oracle but most ODBC have two auth modes, “Integrated Security” and “supplied credentials.” If set to integrated the report is going to try and connect to the database with the credentials that your SIA is running as.

If you want to pass credentials from the report itself be sure to set the authentication to Supplied username and password.

Also, if you have more than one server running the Crystal Reports Job Server you will need the ODBC on all of them if they are enabled in the CMC

skeeter :us: (BOB member since 2008-05-22)

4

Issue resolved.

Thanks for your replies.

The issue was with the ODBC drivers.

I uninstalled the Oracle client tools, deleted all traces of Oracle on the server including deleting all registry entries and re-installed the cllient 9.2 and everything worked great.

Thanks again.

Amit

amitmishra4 :us: (BOB member since 2007-11-05)