Access 2000, Crystal Reports 8, and choice between ADO or straight query
Posted on 2003-11-19
First, I'm using Crystal Reports 8 Developer edition. I have created a report based on a query from an Access 2000 database. I'd like to be able to run this report from an Active Server Page on our intranet where I can declare just one parameter - the date values. Here are my questions:
1) Would this be better or more efficient if I were to run this report by calling a .ttx file and ADO recordset as opposed to going straight to the query?
2) I was experimenting with the example files from Crystal Decisions. When I was experimenting with using a .ttx file and ADO connection, I kept getting the error that my DSN was not available or didn't have the correct driver. In all the comments from the experts here, I never heard of anyone having to declare which driver - just the .mdb driver, which was set up according to the instrctions. Am I missing something? I did actually open the example database and it did ask me if I wanted to convert it to the current version. Would this be the problem and, if so, how do I fix it?
Thank you in advance.