INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Publishing A Crystal Report Using MS Access

Publishing A Crystal Report Using MS Access

(OP)
Hello all,

I fear this question may be a bit obvious to all but me, but I'm clearly doing something wrong ...

Most of our crystal reports (published on SAP BO Enterprise XI) are hitting an Oracle DB, and are all set the same way in the "Default Settings/Database Config" option. I am now trying to publish a report that uses an MS Access db (on a network drive), and am having no luck getting it to run. It runs just fine when I preview it directly from Crystal 2008, but not when I try to do a "recurrence/now" in BO.

The run keeps failing, and giving me this message when I look at the instance details:
"The database logon information for this report is either incomplete or incorrect."

I can't think of what I'm doing wrong, but I've tried checking and unchecking everything I can think of in the Database Config. Any help would be greatly appreciated.

-TS

RE: Publishing A Crystal Report Using MS Access

It may be an OS issue. We had a major issue where Windows security (Windows server 2008) would not communicate properly with our Novell network drives (we were trying to access Paradox and Access tables). Lucky for us, we have a local expert that was able to 'fix' the security issue. Unfortunately I do not have the details of the fix.

RE: Publishing A Crystal Report Using MS Access

1. If the Access databse is on the network and not on your BO server, you need to make sure that the User ID that is being used to run the "servers" that you see in the Central Configuration Manager (CCM) can "see" the network location of the Access database file. By default, they're installed to use the "Local Service" account which doesn't have any network access. You need a network "Services" account that can be used to run BO. Usually this type of account has a password that never expires. In XI 3.x, you would set the login for the SIA to this account in the CCM, in XI through version r2, you would have to set ALL of the servers in the CCM to use this account.

2. What type of connection are you using for your report - OLE or ODBC? If it's ODBC, you need to make sure that you have a System ODBC connection set up on the server. You also want to make sure that the appropriate Access data driver is set up on the server.

3. In the CMC, navigate to the report, right-click and go to Database Configuration. Make sure that you have the correct UserID and Password set up for the report.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close