Read SDF file in Desktop

Dear all,

I Need to read the Data from the SDF file in the Desktop. I have SQL Server 2005 in my System.

i know this is possible. but i dont know how it is ....

regards,

Tamil

You must install SQL Server Compact Edition 3.1 on your desktop in order to open SDF files.|||

Thank you Paulo. It is very useful..

Now i can manipulate the datas in the SDF files in VS 2005 environment.

Can i access those data using C# coding in Web Application or WS?

To connect this SDF file which provider i have to use?

Thanks & Regards,

|||

Yes i got it !!!

Now I can Read the SDF file data by importing System.Data.SqlServerCe; from the below Location

$Program Files$\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies\System.Data.SqlServerCe.dll

See the below Link

http://www.codeproject.com/cs/database/StartSqlServerEW.asp?df=100&forumid=321708&exp=0&select=1584032

Thanks And Regards

RDA vs Replication

I'm working on a mobile

application. I want to have a desktop database that is kept in sync

with a handheld database, with updates occurring on both ends. To keep

them synchronized, I am investigating the use of both RDA and

Replication. I've gotten RDA to work, but have found a major drawback:

Every time you sync, you have to basically pull down a new version of

ALL the data, not just the changes.

So I started to look into

using Replication. If I understand correctly, using Replication, you

can do synchronization where only the changes have to be exchanged

between the handheld device and the desktop computer. But as I just

found out from the above post, you cannot create a Publication using

SQLExpress.

Why do I want to use SQLExpress? Because I need a

version of SQL Server that I can distribute for free with my

application. Am I wrong, or is SQLExpress that only one that has a free

redistributable?

Taking a step back, am I missing something? Is there a better (simpler?) alternative to RDA and Replication?

Thanks for any advice!

Tom

Hi Tom,

SQL Express is the only free version of SQL Server 2005, if you want to use Replication to synchronize you mobile database you will have to puchase one of the larger versions of SQL Server.

Mike

RDA and replication

hi there,

i was about to create an device application that will retrieve data from my desktop pc that install with SQL server 2005. using RDA or replication is more suitable?

what is the difference between them?

The following links describe RDA and Replication and the differences between them.

RDA: http://msdn2.microsoft.com/en-us/library/ms172029(en-US,SQL.90).aspx

Replication:http://msdn2.microsoft.com/en-us/library/ms172407(en-US,SQL.90).aspx

RDA vs Replication: http://msdn2.microsoft.com/en-us/library/ms172916(en-US,SQL.90).aspx

Deciding between RDA and Replication depends on the nature of your device application.

If your requirement is simply to pull data from your desktop SQL Server to the SQLMobile database on your device, RDA would be a simpler option.

|||

And the comparison of both RDA & Merge Replication is @. http://msdn2.microsoft.com/en-us/library/ms172916(en-US,SQL.90).aspx

This details out and should definitely help you in finding out the right solution for your scenario.

Thanks,

Laxmi Narsimha Rao ORUGANTI, SQL Mobile, Microsoft Corporation

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0

DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip

modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=\My Documents\MyFav.sdf;</LocalDBConnect>

<LocalDBLocation>\My Documents\</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

You seem to be using a wrong combination!

On device it is SQL CE 2.0 and on IIS Server it is SQL CE/Mobile 3.0 as per the URL <SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>.

Which is NOT SUPPORTED and this is the error you would get. Try using SQL CE/Mobile 3.0 on the device side then you will be out of the problem!

Thanks,

Laxmi

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035

PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0

DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip

modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=\My Documents\MyFav.sdf;</LocalDBConnect>

<LocalDBLocation>\My Documents\</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

You seem to be using a wrong combination!

On device it is SQL CE 2.0 and on IIS Server it is SQL CE/Mobile 3.0 as per the URL <SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>.

Which is NOT SUPPORTED and this is the error you would get. Try using SQL CE/Mobile 3.0 on the device side then you will be out of the problem!

Thanks,

Laxmi