Re: stability of VFP ODBC driver...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks, Lee! Now, so has anyone here actually deployed an app that uses the
OLE-DB provider while others are accessing the same tables using FP2.6 DOS?
Just curious if they play nicely together or not. I don't want to find out
the hard way if I can avoid it!

"Lee Mitchell" <Leemi@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:S4wj%23hJDGHA.3752@xxxxxxxxxxxxxxxxxxxxxxxx
> Hi Brett:
>
> You nearly always want to use the VFP OLE DB Provider instead of the
> VFPODBC driver in a multi user scenario with Web pages. The VFP ODBC is
> not thread safe; the VFP OLE DB Provider is. Therefore, the VFPOLE dB
> Provider is much more reliable.
>
> See:
>
> 288863 ASP/COM+ solutions using Visual FoxPro ODBC driver may fail under
> stress
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;288863
>
> Also, the VFP ODBC driver will not read VFP tables if they have field
> types
> added after VFP 6.0. For example, if you try to open a table with an
> AutoIncrement field type with the VFP ODBC driver, you get an error. The
> VFP OLE DB Provider handles both the old (FoxPro 2.x) and VFP 9.0 tables.
>
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
>>Has anyone used the VFP ODBC driver in a multi-user environment --- how
>>about to access FP2.6 DOS files at the same time as a FP2.6 DOS app is
>>accessing them? Again, I'm curious just about the ODBC driver (being used
>>from a .NET language), not direct access from VFP itself.
>
>>Just want to know if any of you have experience with it and how reliably
>>it's worked!
>


.

Relevant Pages

  • RE: problem with varchar(max) and odbc vfp9 ?
    ... varchar filed from SQL Server. ... technology offered in the VFP OLE DB Provider. ... are there any problem with FOX odbc driver ...
    (microsoft.public.fox.programmer.exchange)
  • RE: ODBC to SQL Server 2005
    ... ODBC driver? ... Isf so, get it here: ... you are better off using the VFP OLE DB Provider if you can. ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: Object reference not set to an instance of an object.
    ... It turned out that I had installed the latest version of VFP ... and the VFP Ole DB provider somehow got ... >>I have narrowed this down to the update string, but I don't see what I am ... >> Greg Gum ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: FoxPro ODBC Driver?
    ... Salad wrote: ... > VFP ODBC driver? ... > wrong with the ODBC driver on the client machine where the ODBC ... > freaks on logicals. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: visual foxpro crashes
    ... Microsoft FoxPro Technical Support ... Keep an eye on the product lifecycle for Visual FoxPro here: ... progam that uses data from VFP is a dos based C program. ...
    (microsoft.public.fox.vfp.dbc)