Showing posts with label sdf. Show all posts
Showing posts with label sdf. Show all posts

Monday, March 19, 2012

.sdf deployment problem VS2005

I have .sdf and .xds objects in my project for a PocketPC 2003 device. When I debug all of the CF2.0, SQL, and .SDF files are downloaded to the device. However, when I install via the application.cab file, the .sdf, .xds, and CF files do not show up on the device.

What am I missing here?

First ensure that your SDF has Build Action set to 'Content' and Copy to Output Directory = True in your project. When you then create a Smart Device Setup Project in VS2005 to create the CAB file for deployment, you need to include the project output AND the content files from your project in the setup project.

Darren

|||

After installing the CF, SQL and application cabs the .sdf file is in the correct folder. However, I am unable to open the .sdf via the application or SQLce Query Analyzer. I get the following message:

Error:0x80004005 E_FAIL

Native Error: (25039)

Description : Access to the database file is not allowe, {,,,File name,,]

Interface defining error: IID_IDBInitialize

Param. 0:0

Param. 1:0

Param. 2:0

Param. 3 \Program Files\Myapplication folder\myapplication.sdf

Param. 4:

Param.

I am still missing something. What?

|||I think I found the problem(s). A) On the device I removed SQLClient2.0. B) In VS I rebuilt .sdf and .xsd. Now it works. I think the .sdf that I replace in VS was based on CF1.0|||

cool. thanks for posting your solution.

-Darren

.sdf databasse and programming

i need to access an .sdf database using microsfot visual forpro

what drivers/connection strings do i need?

If Foxpro supports ADO you can use the oledb provider, for a sample see http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/08/691894.aspx

Thursday, February 16, 2012

*.mdf to *.sdf

Hi!
Is there any way to convert *.mdf database to *.sdf ?

Thank YouI've found special tool for that
It's called Data Port Wizard. It copies data from SQL Server / Access to / from SQL

CE 2.0 or SQL Mobile. You can get it here: www.primeworks.pt|||Hi Andrew is there any freeware to convert mdf to sdf. coz the primeworks trial period is only for 30 days.|||It would only take a couple of hours to write you own version

For each table in .mdf
Get .mdf schema
Write same schema in .sdf
For each table
read .mdf until eof
INSERT into .sdf

|||

hi Brian,

Thanks a lot for your help. I am a student in singapore, and i am now developing a soft ware in vb.net CE . Is it possible for you to give me a sample coding for this conversion if it is available with you.

Thank you

*.mdf to *.sdf

Hi!
Is there any way to convert *.mdf database to *.sdf ?

Thank YouI've found special tool for that
It's called Data Port Wizard. It copies data from SQL Server / Access to / from SQL

CE 2.0 or SQL Mobile. You can get it here: www.primeworks.pt|||Hi Andrew is there any freeware to convert mdf to sdf. coz the primeworks trial period is only for 30 days.|||It would only take a couple of hours to write you own version

For each table in .mdf
Get .mdf schema
Write same schema in .sdf
For each table
read .mdf until eof
INSERT into .sdf

|||

hi Brian,

Thanks a lot for your help. I am a student in singapore, and i am now developing a soft ware in vb.net CE . Is it possible for you to give me a sample coding for this conversion if it is available with you.

Thank you

*.mdb to *.sdf



Hi!
Is there any way to convert *.mdb database to *.sdf ?

Some of the tools from www.primeworks-mobile.com should be able to help you transfer your data. You could also code the conversion yourself in .NET, using the Jet OLEDB driver and the SQL CE client.|||

You can use Access Database Synchronizer (ADS) from Microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en

There are many things which you can do with this, for e.g. in addition to migrating data from a .mdb file to a .sdf file, you can also use ADS to keep them both in sync! You can also program against ADS using SqlCeRemoteDataAccess object of SQL Server 2005 Compact Edition. For details, please refer to the readme and the sample code which accompanies ADS.

HTH,

Deepesh