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

CR 2008 linked to ACCDB on BOE XI 3

CR 2008 linked to ACCDB on BOE XI 3

(OP)
Hi everyone,

We have numerous CR reports that mingle a combination of Access and Oracle data (sometimes just Access data) that have worked fine with the Access MDB format for years.

Now we're moving to the ACCDB format and the reports work fine in the Crystal Reports developer tool using OLE (ADO) database connectivity, but when we put them on the BOE XI 3 server we can't get past the authentication. Every time it tries to load a report, BOE gives the error...

"the database logon information for this report is either incomplete or incorrect"

... but there is NO logon for an ACCDB data source.

We're using
CR 2008 sp 3
BOE XI 3
Access 2010


Anyone?

RE: CR 2008 linked to ACCDB on BOE XI 3

I would try setting up a mapped drive on the server, into the access database, and see, if that helps.  

RE: CR 2008 linked to ACCDB on BOE XI 3

If you are using Windows Server 2008 (not sure which version) and have a Novell network, you will get this issue.  We had a programmer that did extensive research to find a fix for this issue.  I do not know the details, but it is an security issue between Windows and Novell.

I hope this helps.

RE: CR 2008 linked to ACCDB on BOE XI 3

(OP)
Thanks guys,

The problem isn't Novell related or a mapped drive issue. It's that on BOE3 the OLE (ADO) provider requires authentication regardless of whether or not the data source is MS Access. It works fine in the CR Designer.  

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