Tony
Mon Aug 01 03:19:36 CDT 2005
I tried the OleDb provider you suggested and it worked fine. Thanks for the
info.
BUT, I would rather be able to access the table via Jet if at all possible,
since installing the OleDb driver requires admin privileges on the client
machine and you know those corporate IT Nazi's when it comes to installing
anything on a client machine...!
Is there another option?
Tony
"Cindy Winegarden" <cindy_winegarden@msn.com> wrote in message
news:%2393Hd0MlFHA.3288@TK2MSFTNGP09.phx.gbl...
> Hi Tony,
>
> Download the latest FoxPro and Visual FoxPro OLE DB data provider from
> msdn.microsoft.com/vfoxpro/downloads/updates.
>
> The minimum connection string is
>
> ' For Visual FoxPro "free" tables
> strConn = "Provider=VFPOLEDB.1;Data Source=C:\;"
>
> ' For a Visual FoxPro Database Container
> ' (a DBC file is present)
> strConn = "Provider=VFPOLEDB.1;Data Source=C:\MyDBC.dbc;"
>
> Post back if you can't figure it out from there.
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@msn.com www.cindywinegarden.com
> Blog:
http://spaces.msn.com/members/cindywinegarden
>
>
> "Tony" <tonyng2@spacecommand.net> wrote in message
> news:eh%23bLXIlFHA.3288@TK2MSFTNGP09.phx.gbl...
>> Does anyone know how to simply connect to a FoxPro 6 .dbf file using
>> ADO.NET's OleDb provider so I can query the data?
>> Mainly I need to know what the connection string is so I can execute a
>> query.
>>
>> Thanks,
>> Tony
>>
>
>