By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 2,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

Fetching from FoxPro tables and updating SQL server tables

P: n/a
Hi

I am using vb.net

Is it possible to fetch data from foxpro tables (vfp8) and update tables in sql server 2000? The table structures of the foxpro tables are different from those in sql server. Depending on the data fetched, I would like to update relavent table columns in sql server. How can this be done

Regards
Sarah
Nov 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi Sarah,

Download the odbc dll for .net and then use it in an imports statement like
this:
Imports Microsoft.Data.Odbc

Then set up the connection:

Dim oconn_d As New OdbcConnection("Driver={Microsoft dBase Driver
(*.dbf)};UID=admin;usercommitsync=yes;threads=3;st atistics=0;safetransaction
s=0;pagetimeout=5;maxscanrows=8;maxbuffersize=2048 ;FIL=dBase
IV;DriverID=533;deleted=0;defaultdir=f:\imcapps\db ffiles;dbq=f:\imcapps\dbff
iles;collatingsequence=ascii;")

The dbase driver should work, but you can also check out other driver
connections at http://www.able-consulting.com/ado_conn.htm

Then simply open both tables and copy data from one table to the other.

HTH,

Bernie Yaeger

"Sarah" <an*******@discussions.microsoft.com> wrote in message
news:4C**********************************@microsof t.com...
Hi,

I am using vb.net.

Is it possible to fetch data from foxpro tables (vfp8) and update tables in sql server 2000? The table structures of the foxpro tables are different
from those in sql server. Depending on the data fetched, I would like to
update relavent table columns in sql server. How can this be done?
Regards.
Sarah

Nov 20 '05 #2

P: n/a
In news: uK**************@TK2MSFTNGP11.phx.gbl,
Bernie Yaeger <be*****@cherwellinc.com> wrote:
The dbase driver should work, but you can also check out other driver
connections at http://www.able-consulting.com/ado_conn.htm


Hi Bernie,

The Dbase driver will most likely not work. New features have been added to
VFP tables, making them incompatible with old drivers.

For Sarah - Even though your tables were created with VFP8, if they do not
have any of the new data features added in VFP7 and VFP8 then your tables
can be read with the VFP ODBC driver, which will read all previous versions
too. If any of the VFP7 or VFP8 features have been used then you can access
the tables vial the Visual FoxPro OLE DB data provider, which will read all
previous table versions also.

Both the ODBC driver and OLE DB data provider can be downloaded from
http://msdn.microsoft.com/vfoxpro/do...s/default.aspx.

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

Nov 20 '05 #3

P: n/a

Thanks
Nov 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.