Can someone tell me the driver to open a fox pro database (not the
odbc one) with Visual Basic.

Provider=MSDASQL.1;Extended
>Properties="DefaultDir=C:\Control\;Driver={Microsoft dBase Driver
>(*.dbf)};DriverId=21;FIL=dBase
>III;MaxBufferSize=2048;PageTimeout=600;UID=admin;"


Thanks,

RE: opening a fox pro database with VB by Leemi

Leemi
Tue Jul 01 09:59:12 CDT 2003

Hi mundym:

Are you talking about using the VFP OLEDB Provider? If so, you can use this
connection string to connect:

OleDbConnection("Provider=VFPOLEDB.1;Data Source=C:\Program Files\Microsoft
Visual FoxPro 7\Samples\Tastrade\Data\tastrade.dbc;")

I hope I understand your question.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retires June 30th, 2003
- VFP6 Mainstream Support retires Sept. 30th, 2003

>Can someone tell me the driver to open a fox pro database (not the
>odbc one) with Visual Basic.

>Provider=MSDASQL.1;Extended
>Properties="DefaultDir=C:\Control\;Driver={Microsoft dBase Driver
>(*.dbf)};DriverId=21;FIL=dBase
>III;MaxBufferSize=2048;PageTimeout=600;UID=admin;"


>Thanks,


Re: opening a fox pro database with VB by Manuel

Manuel
Tue Jul 01 11:40:01 CDT 2003

Will the VFP OLEDB Provider be provided separately from VFP 8. I have some
Foxpro tables that I want to access with Visual Studio .Net and I don't
want to use the ODBC.Net provider.

"Lee Mitchell" <Leemi@microsoft.com> wrote in message
news:t5C1bF%23PDHA.1720@cpmsftngxa09.phx.gbl...
> Hi mundym:
>
> Are you talking about using the VFP OLEDB Provider? If so, you can use
this
> connection string to connect:
>
> OleDbConnection("Provider=VFPOLEDB.1;Data Source=C:\Program
Files\Microsoft
> Visual FoxPro 7\Samples\Tastrade\Data\tastrade.dbc;")
>
> I hope I understand your question.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP8 HAS ARRIVED!! --*
> Read about all the new features of VFP8 here:
> http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> Purchase VFP8 here:
> http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retires June 30th, 2003
> - VFP6 Mainstream Support retires Sept. 30th, 2003
>
> >Can someone tell me the driver to open a fox pro database (not the
> >odbc one) with Visual Basic.
>
> >Provider=MSDASQL.1;Extended
> >Properties="DefaultDir=C:\Control\;Driver={Microsoft dBase Driver
> >(*.dbf)};DriverId=21;FIL=dBase
> >III;MaxBufferSize=2048;PageTimeout=600;UID=admin;"
>
>
> >Thanks,
>



Re: opening a fox pro database with VB by Rick

Rick
Tue Jul 01 13:25:44 CDT 2003

Manuel,
It's been publicly stated that perhaps as early as this month (July =
2003), that there will be a VFP OLEDB Provider made freely available =
that's just got a couple fixes/changes from the one released with VFP =
8.0. The last time I heard it was from Ken Levy, product manager of =
Visual FoxPro at Microsoft at the recent MS/Advisor DevCon in Palm =
Springs, CA.

Rick

"Manuel Toranzo" <mannyt@cargilusa.com> wrote in message =
news:%23TIYZ9%23PDHA.2852@tk2msftngp13.phx.gbl...
> Will the VFP OLEDB Provider be provided separately from VFP 8. I have =
some
> Foxpro tables that I want to access with Visual Studio .Net and I =
don't
> want to use the ODBC.Net provider.
>=20
> "Lee Mitchell" <Leemi@microsoft.com> wrote in message
> news:t5C1bF%23PDHA.1720@cpmsftngxa09.phx.gbl...
> > Hi mundym:
> >
> > Are you talking about using the VFP OLEDB Provider? If so, you can =
use
> this
> > connection string to connect:
> >
> > OleDbConnection("Provider=3DVFPOLEDB.1;Data Source=3DC:\Program
> Files\Microsoft
> > Visual FoxPro 7\Samples\Tastrade\Data\tastrade.dbc;")
> >
> > I hope I understand your question.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > Sincerely,
> > Microsoft FoxPro Technical Support
> > Lee Mitchell
> >
> > *-- VFP8 HAS ARRIVED!! --*
> > Read about all the new features of VFP8 here:
> > http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
> > Purchase VFP8 here:
> > http://shop.microsoft.com/Referral/Productinfo.asp?siteID=3D11518
> >
> > Keep an eye on the product lifecycle for Visual FoxPro here:
> > http://support.microsoft.com/default.aspx?id=3Dfh;[ln];lifeprodv
> > - VFP5 Mainstream Support retires June 30th, 2003
> > - VFP6 Mainstream Support retires Sept. 30th, 2003
> >
> > >Can someone tell me the driver to open a fox pro database (not the
> > >odbc one) with Visual Basic.
> >
> > >Provider=3DMSDASQL.1;Extended
> > >Properties=3D"DefaultDir=3DC:\Control\;Driver=3D{Microsoft dBase =
Driver
> > >(*.dbf)};DriverId=3D21;FIL=3DdBase
> > >III;MaxBufferSize=3D2048;PageTimeout=3D600;UID=3Dadmin;"
> >
> >
> > >Thanks,
> >
>=20
>

Re: opening a fox pro database with VB by Cindy

Cindy
Tue Jul 01 15:35:11 CDT 2003

Hi Manuel,

The VFP OLE DB provider is supposed to be posted to the VFP website for free
download in the near future, but it's not posted yet. Check
http://msdn.microsoft.com/vfoxpro every couple of weeks to see when it's
posted.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org, www.cindywinegarden.com

"Manuel Toranzo" <mannyt@cargilusa.com> wrote in message
news:%23TIYZ9%23PDHA.2852@tk2msftngp13.phx.gbl...
> Will the VFP OLEDB Provider be provided separately from VFP 8.