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
Crystal Reports XI and accessing MOM DBs
Started by Rod Tyler, Mar 22 2006 12:52 PM
4 replies to this topic
#2
CDI Fulfillment
-
- Members
-
- 43 posts
Advanced Member
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.
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.
#3
Videoflicks2004
-
- Moderators
-
- 241 posts
GLOBAL MODERATOR
- 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.
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
-
- Members
-
- 1 posts
Newbie
- 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
-
- Members
-
- 2 posts
Newbie
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
