03-18-2011 11:42 AM
I thought that ActReader would install an ODBC driver to access my Act database, but it doen't seem to have done so. When I run ActReader, it just asks me to input a new password. ??
What I am trying to do is to access my Act database from Crystal Reports. What is my missing component?
03-18-2011 11:47 AM
Try using the OLDDB Provider 2.
Here is a short video on connecting ACT to Crystal Reports. Let me know if you have further questions.
03-18-2011 08:30 PM
04-10-2011 09:39 AM
Jon and Mike,
Using your two replies as a starting point I created a new Crystal report and gained access to the schema. However, after I had designed the report I found that I could not access the data. There were two obstacles and I was not ever cofident that I had overcome either one. Firstly, I was asked for a username and password and couldn't get any of the possible repsonses to be accepted, but then I seemed to get past that and started getting an error message about an ID that couldn't be converted to string.
Anyway, I tried building a new data source using SQL Native Client and I entered the username Actreader with the password that I had set. That worked as expected, so I thought I'd share that with you.
Thanks for your help. It certainly got me on the right road.