Re: Help with FoxPro and Crystal

From: Craig Berntson (iamcraig_at_craigberntson.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 09:27:40 -0600

You may actually see a performance decrease going with ODBC. I would use OLE
DB before ODBC.

As for changing location, have you looked at the articles on my web site? 

-- 
Craig Berntson
MCSD, Visual FoxPro MVP
Author, CrysDev: A Developer's Guide to Integrating Crystal Reports
www.craigberntson.com
email iamcraig@craigberntson.com (remove iam)
Salt Lake City Fox User Group
www.slcfox.org
"Altman" <NotGiven@SickOfSpam.com> wrote in message
news:emzwTnHKEHA.208@tk2msftngp13.phx.gbl...
> We just got Crystal Reports Developer 10 and I'm just starting to get into
> it.  We have always just done our reports in FoxPro but needed more
> functionality.  I would like to be able to use Crystal with a dynamic
> database location.  I have looked at some stuff online and found that you
> could get this to work with the COPY TO FOX2X.  I was wondering if there
is
> any reason why this would be a bad idea.  Will there be a performance
> benefit by going with an ODBC?  Is there a possible way to change my
> database location in the ODBC with FoxPro if I would do it that way?  I
> would be OK with using the ODBC but would rather I use the FOX2X thing.
>
> TIA
>
> Altman
>
>

Relevant Pages

  • Re: Word mail merge with foxpro
    ... I did come across an article about using FoxPro with earlier Word ... > The dbf is not attached to a dbc as I have always found that more ... The MDAC 2.5 installaion helpded greatly I am just a bit worried ... >> is to switch on ODBC logging in the ODBC administrator. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Foxpro and crystal 9 - data location at runtime
    ... crpDatabaseTables.ConnectionProperties.Add "SourceDB", strNewLocation ... I suspect that the property to set is very dependant on the odbc driver that ... properties available and none are for the database location. ... > My reports use an ODBC connection to the foxpro data. ...
    (microsoft.public.vb.crystal)
  • Re: Linking to ODBC in A2003 aborts
    ... Do you have an ODBC driver for FoxPro installed? ... Server I'd have to buy a new computer and install Access on it. ... It's really easy to connect to those tables in A97. ...
    (comp.databases.ms-access)
  • Re: Access import off Fox Pro Tables
    ... I am having an issue installing the visual fox pro driver. ... and try to install from the link you provided, I am getting the error "The ... How can I get this VFP odbc driver? ... > Start with the latest ODBC driver for FoxPro and Visual FoxPro, ...
    (microsoft.public.access.externaldata)
  • Re: VFP 8 and ODBC connection
    ... Using ODBC in a Foxpro ... dedicated application server and the database part of the software on ... I have tried giving full access to all the folders available read, ...
    (microsoft.public.fox.helpwanted)