Re: data provider

Ginny
The provider is

sqlceoledb30.dll correct???

chuck
"Chuck Hecht" <checht@xxxxxxxxxxxxxxxxx> wrote in message
news:O79dstSUHHA.3980@xxxxxxxxxxxxxxxxxxxxxxx
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 ... create a SSCE database that contains all of my tables ...
    (microsoft.public.sqlserver.ce)
  • Re: How to find the databases on a server
    ... I just re-ran the example and it the dbDataSourceEnumerator GetDataSources returns the system name and instance name of each provider. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: data provider
    ... Do you mean SQL Server Express Edition or SQL Server Compact Edition? ... 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. ... 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. ...
    (microsoft.public.sqlserver.ce)
  • Re: SP Parameters - default values and parameter order
    ... The order of Parameters is determined by the provider. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error while opening SQL Server CE database
    ... This provider is for SQL Server editions--but not SQL Server Compact Edition. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.data.ado)