CR 2008 linked to ACCDB on BOE XI 3

[cully651]

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?

 

[jmd0252]

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

 

[kray4660]

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.

 

[cully651]

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.