Re: data provider

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: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
Loading