Skip to Content
0
Former Member
Oct 02, 2007 at 07:07 PM

Microsoft Access is giving me problems

10 Views

Post Author: Crystal32

CA Forum: Publishing

Guys, I need some help. I can't for the life of me figure out what is going on. I have a report that I want Enterprise so I can schedule it to run. The report accesses two databases, one being an excel file within an Access database and the other is our core processing system. The report runs fine when I run it from my computer. After I upload it to the Enterprise server and try to run it, I am presented with the following error: Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise

11\Data\procSched\fdicin.reportjobserver\~tmp7104efe2355160.rpt: Unable to

connect: incorrect log on parameters.It sounds like the log on credentials are wrong, but I am 100% sure they are right. The access database doesn't even have a log on. I've already set up the OBDC on the server and mapped it to the network location of the Access Database. It seems like I'm having an ODBC problem like maybe I didn't set it up properly. Why does it bomb out when I run it and what is so complicated about this!!??!!?? Thanks, Adam