I've written some reports using CRXIR2 pointing at SQL Server data. I've managed to set up the OLE link, got through the security and returned the data I want to see.
Now, I've saved the files to Enterprise and I can see the titles fine in InfoView. When I run them on demand, I get the Database Logon screen which, when I enter the correct details, brings back my report hunky-dory.
However, when I SCHEDULE the reports they fail with the following error
"Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\AX401VPC.reportjobserver\~tmp18144eafec9d230.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: 18456 ]"
I'm certain that this is because it's not getting the logon details (OK - stating the obvious). My question is, can I set these parameters as a default. If so, where do I do it?
Hope someone can help.
Now, I've saved the files to Enterprise and I can see the titles fine in InfoView. When I run them on demand, I get the Database Logon screen which, when I enter the correct details, brings back my report hunky-dory.
However, when I SCHEDULE the reports they fail with the following error
"Error in File C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\AX401VPC.reportjobserver\~tmp18144eafec9d230.rpt: Unable to connect: incorrect log on parameters. Details: [Database Vendor Code: 18456 ]"
I'm certain that this is because it's not getting the logon details (OK - stating the obvious). My question is, can I set these parameters as a default. If so, where do I do it?
Hope someone can help.