oneloudogg
November 17th, 2009, 09:14 PM
I am running Crystal Reports X to develop reports primarily using an SQL database. Typically we then use these reports through 3rd party software. There are a couple applications where I would like to use an excel database instead. These reports (the ones using excel db) run fine in development, but fail when run through the 3rd party app. The errors vary depending on connection type, but look to be connection errors (logon failed, table '' can't be located, failed to openrowset, etc).
I have tried multiple techniques for connecting to excel, including DAO, OLE DB, and ODBC. All have the same basic problems...work fine in development but not when run from the 3rd party app.
After searching forums and trying multiple different solutions I am not sure what else to try. I am thinking that it is some type of connection issue....ie the connection to the excel db is getting changed when run through the 3rd party.
I would appreciate any info on this topic. Hopefully there is a known solution but I would also be happy to have some tips for diagnosing this. Thanks in advance.
-scott
I have tried multiple techniques for connecting to excel, including DAO, OLE DB, and ODBC. All have the same basic problems...work fine in development but not when run from the 3rd party app.
After searching forums and trying multiple different solutions I am not sure what else to try. I am thinking that it is some type of connection issue....ie the connection to the excel db is getting changed when run through the 3rd party.
I would appreciate any info on this topic. Hopefully there is a known solution but I would also be happy to have some tips for diagnosing this. Thanks in advance.
-scott