Re: data provider

Chuck,

You are not wrong - it certainly sounds doable. And you do not need SQL Express for what you plan to do. All you need is SSCE on the desktop and on the device. The only thing you need to change is the name of the data provider that your Foxpro app will use. SQLOLEDB is for SQL Express. What you need for SSCE is Microsoft.SqlServer.Mobile.OleDb.3.0 for the data provider.

--
Ginny


"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> wrote in message news:eI0QhLJUHHA.4796@xxxxxxxxxxxxxxxxxxxxxxx
Ginny

Thank you for the replys.
When I talk about a sdf file in my mind its a SQL Server Compact edition database. I have used SSCE2.0 in the past and all databases were sdf files.I think I am confusing everyone because I was told that my customer needs to have a instance of sql server installed to be able to let my foxpro app access the SSCE database and since express is free and can open sdf files I was thinking this is perfect, but it sounds that I was misinformed.

All I want to do is
1. create a SSCE database (ATMobile.sdf) that contains all of my tables that I can give to my customers
2. my current foxpro program will insert data from our foxpro database into that SSCE database using i think SQLOLEDB
3. Now my asset data is in a SSCE database send that file to a mobile device (symbol mc70,mc50)
4. Create another New SSCE database on the device on assets that they have changed.
5. Send that File back to the pc to update the foxpro database.

I am thinking that this doable, PLEASE tell me if I am wgong

Again thank you

chuck
"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message news:70ED4B66-2751-4C6D-80C8-EF31E404DFA7@xxxxxxxxxxxxxxxx
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: Text field that is a date
    ... passing the SQL thru to the datasource and specifying the return type there. ... You're foxpro app will have to match the datatype returned by the DBMS. ... As long as your code only runs against the SQL server ... database it should be ok to use the CAST or Convert. ...
    (microsoft.public.vb.database.ado)
  • Re: Text field that is a date
    ... > You're foxpro app will have to match the datatype returned by the DBMS. ... > normally use the CONVERT command for SQL server instead of cast, ... As long as your code only runs against the SQL server ... > database it should be ok to use the CAST or Convert. ...
    (microsoft.public.vb.database.ado)
  • Re: data provider
    ... Yes it gets intalled with one of the SQL Compact msi files, but I'm not sure which one, and I don't remember what the name of the DLL is since that's not it. ... When I talk about a sdf file in my mind its a SQL Server Compact edition database. ... I have used SSCE2.0 in the past and all databases were sdf files.I think I am confusing everyone because I was told that my customer needs to have a instance of sql server installed to be able to let my foxpro app access the SSCE database and since express is free and can open sdf files I was thinking this is perfect, but it sounds that I was misinformed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Optimizing remote views to SQL 2k
    ... now what I have to do is convert an existing foxpro application that I ... learn foxpro / dbf and use my SQL knowledge to optimize it! ... but it took me 2 weeks to find how to open a database in foxpro!! ... Look up "Parameterized Remote Views" in the help file. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Convert FoxPro to Access?
    ... Sophie: ... from FoxPro to SQL Server when Access is more than capable of extracting the ... you may import data from the FoxPro database into SQL ...
    (microsoft.public.access.conversion)
Loading