Re: ODBC or OLE DB

I'm using Native for the cursoradapter with VFP backend, and ODBC for the
cursoradapter with SQL backend. I see now that I could have chosen ADO with
SQL and that would then use the OLE DB connection string but would that mean
I end up with ADO recordsets being returned? I wouldn't want those. I need
to have normal cursors.

What I'm trying to do is use a consistent way of interfacing between our VFP
application and the data, and Crystal reports and the data.

"Cindy Winegarden" wrote:

> Hi Bernie,
>
> I'm confused. Are you working within FoxPro to connect to either Fox tables
> or SQL tables? If you're using CursorAdapters, what are you using for your
> data source type? (Right click on the CA > Builder > Properties tab) If you
> choose ADO and then Connection string, both the VFP and SQL Server OLE DB
> providers should appear in the list of choices on the Provider tab.
>
> You could have one CA and then just change this property when you
> instantiate it.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
>
> "Bernie Beattie" <BernieBeattie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:467492D5-E15F-425F-AA0E-69FBDB844348@xxxxxxxxxxxxxxxx
> > We are trying to decide which method to use to connect reports to VFP data
> > bearing in mind that we also connect to SQL data. Our VFP8 application
> > uses
> > cursoradapters and ODBC is the only choice for connecting to SQL data. We
> > know that the VFP ODBC driver hasn't been updated for years and doesn't
> > cope
> > with the new autoincrement field type but as we don't use these types of
> > fields, we are tempted to stick with ODBC simply so that we are
> > consistently
> > using the same method of connecting via our application and report writer
> > to
> > both datasets.
> >
> > Does anyone have any advice to suggest we shouldn't use ODBC for any other
> > reasons?
> >
> > Thanks,
> > Bernie Beattie
>
>
>
.

Relevant Pages

  • Re: SQL Server
    ... Das sind VFP Connections und sind eigentlich genau das ... Das ist noch mal ne zusätliche "Schicht" zum ODBC Treiber. ... Letztendlich ist für das Ermitteln der Daten ja der SQL zuständig. ... Bei der Verwendung von ADO muss auf Clientseite aus dem Abfrageergebnis ja ...
    (microsoft.public.de.fox)
  • Re: DB_KEYANDMODIFIED BUG
    ... In VFP, I issued ... the trace in SQL Profiler was: ... ODBC? ... >> Denys Rodrigues ...
    (microsoft.public.fox.programmer.exchange)
  • RE: Creating views
    ... a view and a SQL View really man the same thing. ... is a view that shows data from a VFP table. ... This view does not use a ODBC ... a remote view would use ODBC to connect to ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Creating views
    ... a view and a SQL View really man the same thing. ... > is a view that shows data from a VFP table. ... This view does not use a ODBC ... a remote view would use ODBC to connect to ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
Loading