Re: data provider

Ginny,
is Microsoft.SqlServer.Mobile.Oledb.3.0 a dll that is installed when you
install Compact edition?
I can not find it on my pc any where and I have not found a download either.

chuck

"Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx> wrote in message
news:F52767D0-B740-4178-B7D4-AC15AE6D159E@xxxxxxxxxxxxxxxx
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: 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: What are OleDbParameter names with Original_ prefix?
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Since the table has a primary key column, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO.NET Transaction
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... Client transactions put too much schema-dependent, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Very slow
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.sqlserver.ce)
  • Re: How To Add/Update Record In ADO.NET
    ... If the row is already there (there is already someone with the same name in the database), ... Hitchhiker's Guide to Visual Studio and SQL Server ... "Jeff Gaines" wrote in message ... SQL Server Compact Edition or Express Edition come to mind. ...
    (microsoft.public.dotnet.framework.adonet)