text as a data source with CR in BOE

scheduling XI Scheduler
1

We have a report developer who has a report that uses a text file as a data source. The text file is on a network share and the report runs fine locally in CR. When we publish it to BOE we cannot get it to work - with a variety of settings / options we consistently get “The database logon information for this report is either incomplete or incorrect.” or a variation on that theme. The one way we can get it to work is to have the text file on a local drive on the server.

We have tried using the “Access/Excel (DAO)” connection and ODBC (MS Text driver). We have set up a DSN pointing to a UNC path and to a mapped drive letter. We have tried a variety of ODBC connection strings.
we have tried supplying domain credentials that have access and we have tried using a share that our BOE service account (a domain account) has access to. And more…

Certainly this must be possible? Any ideas?

sbroam (BOB member since 2006-08-24)

2

Has to be an ODBC setting TEXT driver pointing to a UNC-path, not a mapped-drive.

That UNC-path as to be accessible by the network account that the JobServers (R2) / SIA (R3-1) services are running under.

The source for the saved RPT has to use the same ODBC / UNC-Path configuration on the Crystal desktop application and the BOE server.

MJRBIM :canada: (BOB member since 2007-03-23)

3

Woot! That worked. We had already set up the DSN using the UNC path and that didn’t work. I had found the report server was running under local system and changed it to our domain service account and it still didn’t work. After seeing your post, I rechecked the DSNs, then deleted and published the report again and now it works!

Thanks for confirming what is required!

sbroam (BOB member since 2006-08-24)