Well.. I didn't see anyone discussing what I am about to post....
Basically I am trying to access the raw MOM dbfs with Crystal Reports v11. I am choosing xBase as the connection type (as suggested by Crystal) and keep getting a connection screen to login to the .dbf. I have full access to the database file, which is located on my Desktop, but CR is still thinking I need to put a username and password.
Has anyone else experienced this? Do I need to get a special Visual FoxPro driver? Help!
I have contacted Crystal Reports and I don't think they have a clue over there.
Frustrated....
Rod
There is an Updated Visual FoxPro driver from Microsoft... http://msdn.microsof...bc/default.aspx
You will need to set up MOM in your Systems ODBC, so Crystal knows where / how to connect. (I setup a System DSN called "MOM" for Visual FoxPro, and tell it where the tables are. That's what has been working for me!)
Then, it all just works! And, best of all, using reports designed by others is easy!
--Brian