Windows Mobile 5.0 Application &&> Xml File &&> Sql Ce 3.5

Mar 12, 2008



Hi there, i am building a mobile app using vs 2008, the app has about 8 - 12 forms that collect data.. i am thinking of

i am trying to decide how i want to save the temporary work data while the user fills the data collection forms.

when the user selects to create a new report, i will

create a new xml file...
as user moves from form to form, i will update the file
when the user has finished filling up all the data i will create a transaction and insert the data into the sql ce database and delete the file...

i will be using sql ce 3.5
i think it supports transactions
i think it also supports identity.... i am using sql management studio 2005 standalone , so i cannot visually modify the 3.5 sdf.,..,. is there a tool for 2008 that will let me visually modify the table(s)? i dont want to use the 2008 feb community edition...

is there a better way to do this? should i skip the xml and go directly into sql ce insert (for the first record creation) and updates? i think this will be a performance killer on a win mob devilce (5.0)

p.s. i cannot store data in a class, and then commit the class to the transaction because if the application crashes i will loose class data, so xml file will be needed.,

suggestions?

View 7 Replies


ADVERTISEMENT

Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application

Mar 23, 2006

Hello,

I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.

The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.

The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".

Did I miss something to install ?
Do you know how I can resolve the problem ?

By advance, thank you for any answer.

--
Gregoire

View 9 Replies View Related

My SQL Application On Windows Mobile 5

Jan 30, 2006

Hi

My application :

On PC : Access application + Access DB
On PocketPC : Embedded Visual Basic 3.0 application + PocketAccess DB

I synchronise my DBs through ActivSync.

It runs good before Windows Mobile 5.

My customers asked me for new PocketPC with this application, so I bought some new PocketPCs : but as I see, syncronisation with Access is no more supported.

So what are my solutions ?

My customer wait for there PocketPC, so I need a quick solution, I don't want to rewrite all my application now.
My application run before WM5, so now I don't want to have to pay for a Visual Studio .Net, some SQL Server, etc ....

Please, what are the solutions that won't cost me more than the time that have already lost with this new Windows Mobile 5 ?

Joël

View 6 Replies View Related

Connection From Windows Application To Mobile Device(*.sdf)

Jan 21, 2008



Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:


Dim cnn As New SqlCeConnection


cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"


cnn.Open()

But I get the following error:

The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]

Any help would be greatly appreciated!
Leila

View 5 Replies View Related

Data Application Blocks For Windows Mobile

Feb 5, 2006

I've read that microsoft.applicationblocks.data for .net v2 can't be deployed to a mobile app, and my experience bears that out. So I 'm wondering if there are application blocks for windows mobile 5 that would know how to both talk to sql server mobile and sql server 2005. I see OpenNetCF has a port but as far as I can tell, they only address sql server mobile and not talking to a sql server 2005 remote database. I can use the OpenNetCF version for my sql server mobile requirements, but I'm hoping there is an encapsulation of sqlclient calls for communication with my server db.

thanks

braden

View 3 Replies View Related

How To Open SDF File Stored On Windows Mobile Device From A Windows Desktop App?

Apr 14, 2008

Long story short -

Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.

Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)

What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?

Thanks for reading.

View 3 Replies View Related

Any One Tell Me The Code To Connect To .sdf File In C# Windows Application?

Apr 10, 2008

Hi,

Any one tell me the code to connect to .sdf file in c# windows application?And tell the requirments to conncet.My sdf file path is this

C:\Documents and Settings\koti\My Documents\Example.sdf

I write this code.It is not working

string str = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Documents and Settings\koti\My Documents\Example.sdf;SSCE:Encrypt Database=True";
SqlCeConnection cn = new SqlCeConnection(str);
cn.Open();

Ant one help me Plz...

Regards,
venkat.

View 6 Replies View Related

SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0

Aug 8, 2006



Dear ppl,

I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();

I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.

-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab

However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.

The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.

Does any one have any clue what could be the problem ?

Regards
Nabeel

View 6 Replies View Related

Cannot Build SQL Server Mobile Solution For Windows Mobile 5

May 18, 2006

Using MS VS 2005 (incl SQL Server Mobile)
MS Pocket PC 2005 SDK

I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data.

Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h.

Project builds fine in WM2003 configuration, release and debug.

When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003.

In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists.

If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist.

Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds.

Why has transact.h disappeared from WM5 SDK?
I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing?
Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?

View 1 Replies View Related

Creating A Mobile Application With SQL Server Mobile - FIX

Jul 21, 2006

This is a great tutorial and it's a shame one of the more important steps was missed.
In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section  €œCreate a new subscription".
 
To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent.
 
Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
 

 

View 4 Replies View Related

Creating A Mobile Application With SQL Server Mobile

Nov 3, 2007

I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below:

New Subscription Wizard

- Beginning Synchronization (Success)

- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

* 無法完�作業。


- Finalizing Synchronization (Stopped)

- Saving Subscription Properties (Stopped)

Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS.

Does anyone can solve it?? Thank you very much~~~

View 3 Replies View Related

Package Execution Fails In Windows Service But Runs Fine As A Windows Application.

Jun 23, 2006

I am attempting to write a Windows service that watches a database for uploaded files to import. When a new file is found, the corresponding SSIS package is run from the file system with variables passed through. I started development as a Windows app and copied the functionality to a service.

The app runs fine. The service does not. I get a "Failure" each time a package is executed. Everything is identical behind the scenes with the obvious exceptions that OnStart and OnStop handlers are buttons in the app. I added a script task at the beginning of one of the SSIS packages to notify me that it is even running at all. It doesn't even hit that initial task.

Again, the app will run all packages just fine. The data is imported and the results return as "Success."

The following is the code executing the package. Any help is appreciated. I've been banging my head on this one for a few days now. (Is there a tag to format a code sample?)

Dim pkgLocation As String
Dim pkg As New Package
Dim app As New Application
Dim pkgResults As DTSExecResult

pkgLocation = sPackageFolder & PackageName & ".dtsx"

pkg = app.LoadPackage(pkgLocation, Nothing)

Dim vars As Variables = pkg.Variables

vars("ImportId").Value = ImportId
vars("ProductionServer").Value = ProductionServer
vars("ProductionDatabase").Value = ProductionDatabase
vars("SourceFileName").Value = FileName
vars("SourceFilePath").Value = FilePath

pkgResults = pkg.Execute()

View 3 Replies View Related

I Want To Get The Root Appliation Path For Loading A File Which Is In My Root Folder Of Windows Application

Dec 4, 2007



hi
my application is applocation1 i kept a file in this folder i want to read it from application how can i get the path of that file in my application.

i want to read the file in my root folder excluding the bin path

Please any one know the answer let me know ..

thanks and regards
Ravishanker Maduri

View 1 Replies View Related

Asp.Net Mobile Web Application

Jan 22, 2008

I am geeting following error while trying to acquire db connection. I use sql server ce2.0 with vs2005
Failed to find or load the registered .Net Framework Data Provider

View 3 Replies View Related

Mobile Application Enquiry

Feb 14, 2006

Hi,

I've found guides on creating a mobile application but everything is on 1 computer.

What i'd like to do is to seperate into 3 parts for added security.

One is used to store the Database.

One is used as an IIS Server (Web Server).

One is used as a Deployment Server.

Is there a step-by-step guide to this setup?

View 4 Replies View Related

Interoperability Bw SQL Mobile And J2me Application

May 9, 2007

Hi

guys.



Is it possible to interoperate between SQL mobile and applications developed in j2me?

I need my application in j2me to perorm the basic database operations in sql mobile db.



Please advise



Thanks

View 4 Replies View Related

Data Synchronization In Mobile Application

Apr 3, 2008



I am creating a mobile application in which i am implementing data synchronization through merge replication method as per the step by step procedure given in the following link:-
http://msdn2.microsoft.com/en-us/library/ms171908.aspx
I am using SQL server Mobile Edition which is included in SQL server 2005 in this application, but the application suggests to use SQL server Compact Edition. I was able to successfully create the publication, but not able to run the sqlcesa30.dll file of the created virtual directory in the internet explorer. Is this problem because of i'm not using SQL server Compact Edition? and also let me know if i use SQL server Mobile Edition, do i need to install its Server Tools? If yes, please give me the link to download the tools needed.
Reply Soon.

View 3 Replies View Related

Default Mobile Database Application

Feb 11, 2006

Dear All,

I am trying to build a simple mobile application. I am very new to this. Thus I am trying to access the build in database in the folder C:Program FilesMicrosoft SQL Server 2005 Mobile EditionDeviceMobilev3.0Northwind.sdf. I am following the steps in the wizard to help me. When I press test connection is say Test Connection Succeeded. But when I press the ok button I get this error as "Unable to find the requested .Net Framework Data Provider. It may not be installed". I am running VS 2005. Can anyone pls help ?

View 12 Replies View Related

Which .cab For Windows Mobile 6 ?

Feb 6, 2008

Hello,

I've got an HTC Dual Touch with Windows Mobile Pro 6.

I'd like to install SQL Server Compact 3.5 on it but I'm not sure which cab to use ....

In WCE500 directory there's plenty of ones.

Is anyone could help me with this ?

Thanks a lot !

Cheers,

Bertrand

View 3 Replies View Related

Ole DB Example For Windows Mobile 5.0

Jun 29, 2006

Dear All:

Is there a tutorial for WM5.0 to connect to SQL CE 3.0 using Ole DB using the headers:

#include "ca_merge30.h"

#include "ssceoledb30.h"

#include "ssceerr30.h"



The example Northwind at "Sql Mobile 5.0" doesn't works with WM5.0 SDK, due to imcompatibility issues. It works with the WM2003 sdk, but i'm programming in native c++ for WM5 devices.

I'm using the header from SQL Everywhere.

Thanks.

Alfredo Mendiola Loyola

Lima Perú

View 1 Replies View Related

What Is The Limit Number Of SQL Mobile Databases Per Application?

Feb 28, 2008

Hi There,

I would like to know what the recommended Number of Sql Mobile Databases Per Application?

I appreciate any response!
Thanks!

View 12 Replies View Related

Windows Mobile 6 Problem

May 29, 2008

Can an application developed in VS 2005 with the .NET Compact Framework 2, and the windows mobile 5 sdk run on a windows mobile 6 device?

I am having a problem with creating a merge subscription on the windows mobile 6 device. After all parameters are entered, i click on the routine to build the db and then subscribe to the server database publication and the device keeps throwing invalid cast exception, then drops out of the program. I have a try catch in the routine for the invalidcastexception but it still seems to be fatal. The catch block notification code does not show any exception details.

The program runs fine when connected to a populated test database.

I have triple checked all the parameters that are entered to create the subscription, and tested connectivity to sqlcesa30.dll.


Thanks for your consideration.

Ryan

View 3 Replies View Related

Windows Mobile Location

Mar 29, 2008



Hello, I am having a bear of a time trying to read from my windows mobile 5.0 device.

I am storing information in the executable directory and need to interact with it.

In Windows XP/Vista you can use Application.StartupPath to obtain current location and then add your folder/file name on the end of the string to interact with the file. How in the world do you do it in Mobile?

Thanks

View 1 Replies View Related

Creating A Mobile Application With SQL Server Compact Edition

Jun 28, 2007

Hello!!



I completed that example that I pasted in the subject part and when I try to synchronize my mobile database, the data from the server appear in my pocket pc; but when i refresh the data on my pocket pc they do not show on the server.



Can anyone give me a hand?



thanks

View 3 Replies View Related

.Net Framework 1.0, SQL Ce 2.0 And Windows Mobile 5.0 Work Together?

May 4, 2006

Hi,

Does anyone know if I have created a replication using SQL Server 2000 (sp3a), .Netframework 1.0 with Pocket pc Sql Server CE 2.0 will work or not in pocket pc windows mobile 5.0 environment (with the .netframework for pocket pc(netcf.core.ppc3.arm.cab) and sql ce file (sqlce.ppc3.arm.CAB) installed in pocket pc)?

I have it working in pocket pc Windows mobile 2003 version. But, after I tried to install the exact same cab files and system into Windows mobile 5.0, the replication fail.

Anyone has any idea?







View 4 Replies View Related

RS 2005 Windows Mobile Interface

Sep 29, 2006

I am interested in serving a few simple stats to a PDA running Windows Mobile 2003 for Pocket PC, Phone Edition. The device I'm considering is the HP iPaq 6515. I'm open to suggestions, does anyone have any experience with this?

Thanks

View 4 Replies View Related

Is It Bad Practice To Leave A SqlCeConnection Open Through The Duration Of A Mobile Application?

Jan 24, 2008

I know that with traditional SQL systems, it is important to only open connections to a sql server when they are needed. However, since there is no "server" in mobile apps, is it bad practice to leave one open throughout the duration of an application?

The application is going to be constantly reading and writing to the data tables and it seems like it might be a good idea to leave it open.

Thanks!

View 1 Replies View Related

SQL_SSMEE Failed And Trying To Repair While Lauching Our Mobile Client Application.

Jul 24, 2006



Event ID - 1001 and Event ID - 1004.

Source - MsiInstaller

Error Description for Event ID - 1001:

Detection of product '{8670F53C-8AD7-4F34-BDBA-17B38A18CB65}', feature 'SQL_SSMSEE' failed during request for component '{6EC5DFBD-F6B5-4F02-8432-BFB8B03562B8}'

Error Description for Event ID - 1004:

Detection of product '{8670F53C-8AD7-4F34-BDBA-17B38A18CB65}', feature 'SQL_SSMSEE', component '{180F515D-F56C-40DD-9D71-CC532EA8E286}' failed. The resource '' does not exist.

While opening our SAP Mobile Client Application, in the task manager MSIEXEC.EXE is running and trying to repair the application and this will cause our application to take time to lauch. In the Event viewer, whenever we try to lauch our application we are getting this event id's. Can you please kindly provide a solution for this msg.

Regards,

Thiyagarajan.R

View 1 Replies View Related

SQL Server 2000 CE 2.0 On Windows Mobile 2003

Jan 28, 2008

Does SQL Server 2000 CE 2.0 work on Windows Mobile 2003?

Thank you,

Ken Carlino
ServiceMaster

View 6 Replies View Related

Merge Replication Problem On Windows Mobile 5

Sep 9, 2006

Hi,

I developed a mobile application (CF 2.0) that uses merge replication to synchronize data between SQL Server Mobile and SQL Server 2000 SP4. The application uses asynchronous synchronization (BeginSynchronize method) to initiate the replication and update the user about the progress. The application worked perfectly on PPC2003 and Windows CE .Net 4.2 platformes.

The problem started when I moved it to WM5 platform. We're using Symbol MC70 devices.

When I start the replication for the first time it synchronizes without a problem. If I perform additional synchronizations(updates) it synchronizes without a problem. If I exit the application and start it again the sync process hangs when I try to synchronize it(to deliver updates).

Any ideas?

Thank you

View 3 Replies View Related

Merge Replication Using SSL On A Windows Mobile 5.0 Device

Feb 5, 2007



Dear ppl,

I have a windows mobile 5.0 application that syncronises with SQL Sever 2005 (Merge Replication). The replication works fine without SSL. But when using SSL it doesn't work .On the device i get an error





28037, A request to send data to the computer running IIS has failed.

I have created a a Wild Card Certificate (*.domain-name.net) using Microsoft Certificate Services (Stand Alone) and setup the replication website with replication virtual directory under it , in IIS, to use this certificate. The host header for the replication site is set to "sql.domain-name.net". I have binded the host headers to the port as well.

I can access the https://sql.domain-name.net/replication/sqlcesa30.dll from remote computer and device and it says Microsoft SQL Server Compact Edition Server Agent, that means it is setup correctly.

I have installed the certificate authority and its wild card certificate on the device Root Certificates. Now when I call repl.syncrhonise() from device .. it throws exception with error 28037, A request to send data to the computer running IIS has failed.

which i think means, it can't find the service url.

I am not sure what is the problem..something to do with Trust - SSL certificates... Is there any thing i am missing ?

Awaiting,



View 9 Replies View Related

Windows Mobile 5 Connecting To SQL Server 2005

Jan 30, 2006

Can't get winmobile 5 to connect to my sql server 2005 (using vs2005). Here's the connect string:

"Data Source=tcp:XXXXXXdefault,1433;Database=YYYYYY;" _
& "Integrated Security=SSPI;"

This very same string, and variations of it, work in a vs2005 winforms app, but not a windows mobile 5. I'm (obviously) using system.data.sqlclient. MS documentation says it's supported on both platforms with no syntax changes. Any suggestions?

View 11 Replies View Related

VS 2005 With SQL Server CE 2.0 For Windows Mobile 5 Devices ?

Nov 28, 2006

I Have a smart device application developed in VS 2003 (VB.Net) and Sql server ce 2.0. Now I have upgraded the application to VS 2005 (VB.Net). My question is, Can the Application developed in VS 2005 can communicate with Sql server ce 2.0 and Sql server 2000 sp4 or Do I need to change the Sql server ce 2.0 to sql server 3.0 to work with windows Mobile 5 and Pocket PC 2003 SE devices ?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved