Jump to content


Photo

Crystal Reports XI and accessing MOM DBs


  • Please log in to reply
4 replies to this topic

#1 Rod Tyler

Rod Tyler

    Newbie

  • Members
  • Pip
  • 1 posts

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

CDI Fulfillment

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts

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

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 07 April 2006 - 05:18 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


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

[email protected]

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

CokeDrinker5

    Newbie

  • Members
  • Pip
  • 1 posts
  • Location:Los Angeles

Posted 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

#5 Mach2

Mach2

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 10 September 2007 - 08:22 AM

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




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users