Crystal Reports XI and accessing MOM DBs

#1 Rod Tyler

Newbie

Group: Members
Posts: 1
Joined: 22-March 06

Posted 22 March 2006 - 12:52 PM

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

#2 CDI Fulfillment

Advanced Member

Group: Members
Posts: 43
Joined: 11-August 05

Posted 22 March 2006 - 02:26 PM

I has been 4 or 5 years since I used Crystal to access MOM data, but I know that it can be done. Sorry that I don't have a more definitive answer than this: You need Foxpro drivers to access MOM .dbf files. A standard dbf driver won't do the trick because it is trying to read it as something like a dBase4 file. I think that once you are using the foxpro driver that it will also take care of your password issue. I know that when I was using Crystal, it wasn't asking me for passwords.

Hope this guides you in the right direction. If you are still having trouble after this, let me know and I can dig a little deeper into what I was doing before. It's just been so long that it's a little cloudy.

Jay Snelgrove
Fulfillment Manager
CDI Media, Inc.

http://www.cdimedia.com

#3 Videoflicks2004

GLOBAL MODERATOR

Group: Moderators
Posts: 241
Joined: 29-September 04
Gender:Male
Location:Canada
Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 07 April 2006 - 05:18 PM

Rod Tyler, on Mar 22 2006, 04:52 PM, said:

Hi Rod,

Did you manage to get Crystal Reports to work?

I think I have a couple of CR10 reports that we can share if you are using CR.

Best,

Dave

David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#4 CokeDrinker5

Newbie

Group: Members
Posts: 1
Joined: 05-May 05
Location:Los Angeles

Posted 29 June 2006 - 08:29 AM

Rod Tyler, on Mar 22 2006, 01:52 PM, said:

There is an Updated Visual FoxPro driver from Microsoft... http://msdn.microsoft.com/vfoxpro/download...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

#5 Mach2

Newbie

Group: Members
Posts: 2
Joined: 21-August 07

Posted 10 September 2007 - 08:22 AM

Videoflicks2004, on Apr 7 2006, 07:18 PM, said:

Hi Rod,

Did you manage to get Crystal Reports to work?

I think I have a couple of CR10 reports that we can share if you are using CR.

Best,

Dave

Hi Dave,

I know this is an old post, but do you have any info on the OLE DB driver for the MOM 6.0 ver? I downloaded & installed a VFP OLE DB driver, but can't find it in the Data Sources. Any suggestions.

Also, I am using Crystal Reports 11 & am new to CR; does anyone have any reports that you are using that you'd be willing to share? I have done a little 'reverse engineering' to fix errors in existing Access reports a few years ago, but linking data tables is a new skill set that I am scrambling to learn.

I'm new to the forum & am so glad to find it!

Deb