Jump to content


CokeDrinker5

Member Since 05 May 2005
Offline Last Active Jun 29 2006 08:29 AM
-----

Posts I've Made

In Topic: Crystal Reports XI and accessing MOM DBs

29 June 2006 - 08:29 AM

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