Re: data provider

Ginny,
I am not very experienced with SQL Server, if I choose the later method of
using the foxpro OLEDB route does the end user have to have Sql Express
install on their pc. I have been told that the sdf can not be accessed if it
not referenced to an instance of sql server(or now express).
chuck
"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message
news:1A8BD14A-F7C3-4362-BE44-4E085F174664@xxxxxxxxxxxxxxxx
Chuck,

There are two ways to procede to get VFP data into SQL Server Compact
Edition. One is to write a .NET app that uses the SqlServerCe namespace
for the sdf file and Foxpro OleDb provider for the fox data. The other is
to write a Fox app that uses OleDb to reference the SSCE data. In any case
these are the OleDb data providers:

Foxpro: VfpOleDb.1
SQL Server Compact Edition: Microsoft.SqlServer.Mobile.OleDb.3.0

--
Ginny


"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> wrote in message
news:uhCNsYHUHHA.3316@xxxxxxxxxxxxxxxxxxxxxxx
Bill,
Thanks for the reply,
I have a asset traking program that was created in Visual Foxpro, my
customers ave 25000-45000 assets (3 have over 90000) I have duplicated
the structure of the foxpro database in a Sql Server Compact Ed
database,ATMobile.sdf. I need to add the functionality that would take
the foxpro data either in total or a filtered version and it would
populated all of my tables in ATMobile.sdf. I would then be able to send
it to a scanning pda(symbol mc50 or Hp ipaq).
Currently we are exporting our foxpro data into xml files and sending
them to the device via active sync. The issue is the time it is taking my
scanner app to process all of the dataset.readxml to create the data
store on the pda. Any ideas or recommendations would be great.
Thank you

chuck





William (Bill) Vaughn" <billvaRemoveThis@xxxxxxxxxx> wrote in message
news:%23XlvbwGUHHA.1200@xxxxxxxxxxxxxxxxxxxxxxx
Huh? Are you planning to use SqlBulkCopy? If so, you can use any ODBC or
OLE DB provider that can access the FoxPro data to create a DataReader
and pass that to SqlBulkCopy.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no
rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest
book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> wrote in message
news:%23duwNQGUHHA.5108@xxxxxxxxxxxxxxxxxxxxxxx
Good morning,
What data provider would I use to get data into Sql Server Express from
a Visual Foxpro9 data store?
Thank you

chuck









.

Relevant Pages

  • Re: data provider
    ... provider that your Foxpro app will use. ... When I talk about a sdf file in my mind its a SQL Server Compact edition ...
    (microsoft.public.sqlserver.ce)
  • Re: data provider
    ... provider that your Foxpro app will use. ... When I talk about a sdf file in my mind its a SQL Server Compact edition ... create a SSCE database that contains all of my tables ...
    (microsoft.public.sqlserver.ce)
  • Re: help with conection between SQL server & DBF file with cdx index. thanks
    ... To move the data into sql server, you likely don't want, or need to use ... consider at least linking to the Foxpro tables, ... Originally posted by Cindy Winegarden Microsoft Visual FoxPro MVP: ... Start with the latest ODBC driver for FoxPro and Visual FoxPro, ...
    (microsoft.public.access.externaldata)
  • Re: SQL Server vs. Foxpro
    ... I used to use Foxpro for small apps, ... There are many more tools available which can use data in SQL Server ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... > My company has recently "merged" with another company who uses Foxpro as the> backend for their ASP front end. ...
    (microsoft.public.sqlserver.server)
Loading