Re: data provider

Chuck,

You are confusing me. You talk about SQL Express but on the SQL Ceompact Edition newgroup, and you talk about SDF files. Do you mean SQL Server Express Edition or SQL Server Compact Edition? Both have OleDb providers. For SQL Express the users must install it. For SQL Compact you could just provide them with a few DLLs - much simpler and no real installation involved.

--
Ginny


"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> wrote in message news:%237SA2OIUHHA.5016@xxxxxxxxxxxxxxxxxxxxxxx
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: OLE DB Provider not found for SQL Compact edition even after installing
    ... it raises exception saying that particular OLE DB Provider is not found. ... MSSQL CE registry entry) with value "Microsoft SQL Server Compact OLE DB ...
    (borland.public.delphi.database.ado)
  • Re: OLE DB Provider not found for SQL Compact edition even after installing
    ... it raises exception saying that particular OLE DB Provider is not found. ... MSSQL CE registry entry) with value "Microsoft SQL Server Compact OLE DB ...
    (borland.public.delphi.database.ado)
  • Re: data provider
    ... using the foxpro OLEDB route does the end user have to have Sql Express ... There are two ways to procede to get VFP data into SQL Server Compact ... these are the OleDb data providers: ...
    (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 ...
    (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)