I want to create an application for home users which runs on their mobile device (smartphone) and their desktop PC and keeps the data synchronized between them. On their desktop I want to run either SSCE or SSExpress. There are so many options in the SSCE literature, which options should I use? How do I synchronize the data?
The literature has so many options I don't know where to start.
Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.
I got a problem of how to sync / read the sql CE data from a windows application.
so, i wanna ask,
1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?
2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?
last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?
please help me out
I have been able to use MS Sync Services to sync an MDF file & an SDF file (Works great! Very easy!).
What I would like to know is if I could sync an SDF file with another SDF file (making an SDF file a desktop DB and the other a Mobile DB)?
Thanks,
V
VS 2008
SQL 2005 Express
Hi,
I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.
Imports System.IO
Imports System.Data
Imports System.Data.SqlClient
Imports System.Math
Imports System.Drawing
Imports System
Public Class Form1
Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"
Dim strQuery As String
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = "Hello, Clicking after."
ReadOrderData()
End Sub
Private Sub ReadOrderData()
Dim queryString As String = "select * from Person.Address where AddressID < '10'"
Using connection As New SqlConnection(strConnection)
Dim command As New SqlCommand(queryString, connection)
connection.Open()
Dim reader As SqlDataReader = command.ExecuteReader()
While reader.Read()
MsgBox(String.Format("{0}, {1}", _
reader(0), reader(1)))
End While
reader.Close()
End Using
End Sub
End Class
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.
Hi All,
I am interested in synchronising 2 sdf files which are sitting on 2 different PDAs and I want to synchronise both of them with or without desktop application. C# applications are used to talk to the applications.
Is it possible or not and if possible how can i do that. Any code snippets or any links to similar forum posts or anything will be of great help. I am a C# programmer but not SQL Developer.
Regards
Trushar
Hi, I need to synchronize a sql mobile database & sql 2000 database.
Someone knows how can I export a SQL 2000 db to SQL mobile 2005 (.sdf)?
Cesar!
I want to synchronize my database on Pocket PC / The Emulator that use WM5 and SQLCE3, but the synchronize is doesn't use IIS as the bridge, but i want to use ActiveSync as the synchronizer bridge. The rule like this.
1. Have database on Pocket PC.
2. Have application on Desktop PC.
3. When device or emulater placed on cradle, then the database automaticaly synchronized with database server on desktop pc.
Why I want to use ActiveSync as synchronizer.
1. I have the Pocket PC cradle. So my device can synchronized using ActiveSync.
2. I have internet connection on Desktop PC. So why i must pay more for GPRS if i only need to synchronize my device with my desktop pc.
Thanks.
I want to create an application that will have support two platforms, Window's desktop and Windows Mobile 5/6. The application will need to have the data synchronized when the device is put in the cradle via ActiveSync on WinXP or Sync Center on Vista.
I want to use the new SQL Compact Edition to do this. The problem I'm having is how do I sync the data? I know about RDA and Merge Replication, but for a generally distributed application to customers via the internet, how do I make this work seamlessly without a complicated setup? This application will be sold to thousands of users without technical knowhow of how to use advanced synchronization configurations.
I have to assume other developers must be interested in a scenario like this, but I have yet to see a good solution in my searches on the web or Microsoft's site.
I don't want to use Access on the desktop. I also don't want to use RAPI to transfer files as there are security issues with newer devices.
I'm coming close to scoping out a 3rd party database or home-grown solution, but this would not be optimal.
This code...
string Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
// Create the connection fConnection = new SqlCeConnection("Data Source ="" + Path + "\TreeNotes.sdf" ;Password ="abcd1234";");
fConnection.Open();
...works on my device, but on my computer it gives SqlCeException with message:
The database file cannot be found. Check the path to the database. [ File name = Program FilesTreeNotesTreeNotes.sdf ]
I've tried all sorts of things, but the computer just can't find the database. I've even tried putting a copy of the database into...
C:Program FilesTreeNotesTreeNotes.sdf...hoping that the computer will find it there.
What am I missing?
How do i set up a connection between sql mobile and sql server 2000?
I think all the packages are installed but how can i synchronize data from sql mobile to server 2000 and the other way???
Hello!
I don't know if this question belong to sql forum or smart device forum.
So far i was able to sync data between pda and the sql server pc, over a wi-fi LAN using Remote Data Access.
Now i want to do the same but without using the wifi LAN, i mean, i want to be able to over a gprs connection, do the same data synchronization.
My main question is how to get access to the sql server database ? My connection string (obviously) only works in LAN.
My doubt is how can i access my sql server database data ?
I need some help over here, i really don't know how can i overcome my current problem.
Thank you
HI all,
Que 1.
M doing PDA Project in Vb.net Compact framework [ CF ]. In tht I need to do synchronization My PDA's database with Desktop Computer's database manually.
So Plz Suggest me some options .....
One of them I know & Its RAPI..
--> "RAPI allows desktop based applications to talk with CE devices while they're connected to the desktop via ActiveSync".
but M confused regarding ActiveSync Bcoz i want to do it Manually.
Thnx & Regards
Amit B. Master
Can I synch between a Mobile device using SqlServer Compact and desktop PC running Sql Server Express using Microsoft Synchronization Services?
View 1 Replies View RelatedI have searched through this forum and the news group
microsoft.public.sqlserver.ce
for this topic. I only find a post from Darren Shaffer and I requested a document.
Unfortunately, there is not a clear example of how to create a mobile database (sdf) on a desktop machine which contains VS 2005 and SQL server 2005 by using Visual Basic 2005.
I am sure a clear example in VB for this problem would help a lot of people. Hence anybody who knows how to perform this task, Please help these people.
Thanks in advance
Talat
We have a product which uses a SQL Mobile Database under Windows CE 5.0. I would like to be able to change the database structure, i.e. add tables, change table structure , etc. On a copy of the database on my PC and them move the restructured database back to a device. I can access the database from Visual Studio 2005. I can edit tables, add tables, but I can't change the name of a column. Does anyone have a solution?
View 4 Replies View RelatedI want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible.
Here are my VS 2005 VB.NET statements....
Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:Documents and SettingsG014436My DocumentsSQL
MobileActMgr6CE.sdf")
Dim mySqlDataAdapter2 As New SqlDataAdapter("select * from T0002_AE_Activity_Entry", ConnPPC)
mySqlDataAdapter2.Fill(myDataSet2)
On executing the last statement(fill)...I get the following error.
function failed: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Does anyone have any suggestions?
Hi
I'm developing a pocketpc 2003 application with visual studio 2005. It has a sql server mobile sdf file call datos.sdf.
I need to create a Windows Desktop application and i need to connect it when pocketpc is connected to desktop with activesync.
Any ideas or links with some code samples?
I have installed sql sever everywhere but i don't understand how i can do that connection.
Thanks
Hi all, I'm new to mobile devices.
I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device? I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice.
Is something like this possible?
Thanks!
Hello,
I try to connect the SQL Server from the mobile device.
my connection string is:
string conn_str = "Server= 10.0.0.11;Database=theDB005;uid=bahadir;pwd=abcd;Trusted_Connection=false;";
when i try to open the connection I get SqlException,altough the 10.0.0.11 machine is reachable.. is not allowed to access a remote sql server with ip?
Thanks in advance.
I have been unable to properly install SQL Mobile 2005 on my armv4i windows CE 5 device. Below is a summary of what I have found and done. Any help in resolving my issue will be appreaciated. Thanks in advance for your help.
Symptoms:
No errors occur during installation of SQL Mobile on the device via cab files (either deployed through VS2005 or manually copied and installed on the device)
SQL Mobile 2005 appears to be installed, can see it in the device remove programs list. All 7 SQL Mobile dll files are present in the windows folder. (sqlceca30.dll, sqlcecompact30.dll, sqlceer30en.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll - version for all files is 3.0.5206).
The following error occurs when attempting to create a new or open an existing database using SQL Mobile query analyzer on the device - "Failed to initialize the provider. Please make sure that SQL Server Mobile Edition is properly installed".
Problem is not isolated to SQL Mobile query analyzer, a similar problem occurs when attempting to instantiate SQL objects from within a C#.Net smart device test program - "Can't find PInvoke DLL 'sqlceme30.dll'.
Problem is not solved by copying SQL Mobile dll files to program folders.
No registry entries exist for any of the 7 SQL Mobile dll files under the HKEY_CLASSES_ROOT.
None of the dll files for SQL Mobile can be registered manually via the regsrvce.exe program. The error code c1 is returned - invalid win32 application (Note SQL CE 2.0 dll files can be successfully registered via this program).
Background:
The desktop used for development is running Windows 2000 sp4. The develpment enviroment is Visual Studio 2005 Professional Edition (version 8.0.50727.42 (RTM.050727-4200). The version of the Microsoft .NET Framework installed is 2.0.50727. The programming language is C#.NET. The device is a 64 MEG Armv4i device running a custom image of windows CE5. The CE5 image was created by Platform Builder with all QFE's through 2005 applied. .NET Compact Framework version 1.0.4292 and SQL CE version 2.0 are included as part of the image (both are in ROM). .NET Compact Framework version 2.0.5238 and SQL CE Mobile are installed via CAB files in the order defined below:
netcfv2.wce5.armv4i.cab
sqlce30.wce5.armv4i.cab
sqlce30.rep.wce5.armv4i.cab
sqlce30.dev.ENU.wce5.armv4i.cab
system_SR_ENU.cab
Hello,
I am using the SQL Reporting services with SQL Server 2005. I am able to view my reports in the report manager however, when the report generates on my device it shows blank of 0 pages. I created a simple test report with just a header, company's logo and contact info and still no luck. I am using anoynomous user access and have given IUSR datareader access in SQL Server. Not sure where I am going wrong. I feel like I am so close...If someone out there had any success viewing reports on mobile device (WM5.0) and would be so kind to share their experience or knowledge, I would greatly appreciate it!
Thanks.
How can I connect to sql server from a mobile device?
View 14 Replies View Related Hello,
VS 2005 & SQL server 2005
I developed a mobile application PDA using the Compact Framework 2.0. And using typed datasets
I have also developed a web service. When the PDA is connected to the Internet it can access the web service and get all the data that is in the sql database. The user can add new records, update existing records, and delete them. So the web service acts like a middle man.
In the PDA the data is filled using typed datasets.
However, the customer now wants to be able to interact with there data on the PDA, currently they have to be connected to the Internet. But if there is no internet connection, then they will still like to add, update, and delete the records. Then once they have a connection, all these would be updates with the sql database.
What is the most efficient method to do this.
Many thanks for any suggestions,
Steve
Hello Everybody
I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.
Anybody having this solution for this prob.
Regards
Chikuu
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
I just upgraded our application from SSCE 2.0 to SQL Mobile. Our app is written in C++, and we use OLE DB for most of our queries, including the routine the downloads and inserts our lookup table data. This application is running on a Dell Axim X51.
Using SSCE 2.0, this routine takes 236 seconds, with most time spent inserting data into various tables (using OLE DB). The resultant database size is 15.1 MB.
Using SQL Mobile, this routine now takes 675 seconds, with a resultant database size of 27.9 MB!! There is a noticable increase in time when the downloaded data is being inserted into the database.
What would be the reason(s) for the slower performance and the increased size of the database? This appears to be a monumental step backwards in performance. Any suggestions regarding improving the perfomance and size?
I've written a query to pull data from a SQL Mobile database which seems to completely hang the device when I run it (I waited several minutes before warm-starting). Yes, it's a bit complex, but it works fine on the desktop version--completes pretty much instantly.
Are there any limits to SQL Mobile that might prevent me from writing such a query? There are not very many records in any of the tables (all are <20, except one which is ~2500).
Here is the query:
------------------------------------code---------------------------
SELECT oi.ProductID, g.GenusName, Species.SpeciesName, f.FormName, f.Abbr, sz.Sizes, su.SizeUnits, su.Abbr, pa.PackageName, pa.Abbr, oi.NumRequested, oi.NumProvided
FROM OrderItems oi
JOIN Products p ON p.ProductID=oi.ProductID
JOIN Varieties v ON p.VarietyID = v.VarietyID
JOIN Genus g ON v.GenusID=g.GenusID
JOIN Species ON v.SpeciesID=Species.SpeciesID
JOIN Grades gr ON gr.GradeID=p.GradeID
JOIN Form f ON gr.FormID=f.FormID
JOIN SizeUnits su ON gr.SizeUnitsID=su.SizeUnitsID
JOIN Sizes sz ON gr.SizeID = sz.SizeID
JOIN Packages pa ON p.PackageID=pa.PackageID
WHERE oi.OrderID=3
------------------------------------------code---------------------------------------
Any ideas? Thanks in advance.
-Kevin
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,
Hey guys,
So I started an SQL CE database for use inside a mobile application. I used SSMS to create a .sdf file (because if I let Visual Studio do it, SSMS can't open it because it will be version 3.5).
The reason I wanted to use SSMS is because I wanted to be able to design the database in design view, and populate it with initial information for the application to use. That means adding tables and rows.
The problem is, SSMS doesn't seem to have a design view available when working with CE databases. It also doesn't seem to have a feature for adding rows into tables. It's essentially as useless as VS2008 for designing my mobile database. It only lets me add tables, and I can't even do that visually in design view. I have to use those cumbersome forms.
Is there any way to design a CE database in design view? And add rows of data into tables? It feels like I'm overlooking something.
Note: I dont need to subscribe or publish the database. The mobile application just needs to use the database as a repository.
Hi, Guys
I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.
The following is my development enviroment
Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2
First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.
Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.
I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.
I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.
Can someone help me out?
Thanks.
Howdy,
Am trying to find a way to insert/update/delete data in a SQL mobile database on a Windows CE 5.0 device FROM a desktop PC.
This situation is completely stand alone, no network (apart form device/desktop), no GPRS etc etc etc.
I've looked at RDA but i dont believe it fits my app. (pulling data from a 2005 server that doesnt exist doesnt really help me much, push can't be used without a pull which kills the idea.)
The goal is a UI on the desktop that can manipulate data in the SQL mobile Database.
I've tried all i can find/think off in relation to this but to no avail.
My latest attempt has been using the simplest method possible (using a VS wizard datasource to the devices DB and tryign to whack that on a form) but this just creates a "Path not found. Check the directory for the database [Path = Mobile Device/ce_swipe/TestDB.sdf".
I have a Fujitsu-Siemens LOOX 520 running WM 5 version 5.1.70 on which I am trying to create a Server 2005 Mobile database.
I have installed the following files on the Pocket PC after a hard reset to make sure the unit was in its vanilla state:
NETCFv2.wm.armv4i.cab
sqlce30.dev.ENU.ppc.wce5.armv4i.CAB
sqlce30.ppc.wce5.armv4i.CAB
sqlce30.repl.ppc.wce5.armv4i.CAB
All the files appeared to succesfully install. Connecting to the device in VS2005 works with no problems. Creating a small test app in VB.NET and running it on the device works no problems, so the device is satisfactorily connected to VS2005.
My problem is this:
When I try to create an SQL Server 2005 Mobile database on the device using Add Connection under the Data Sources window in Visual Studio 2005 Professional (RTM version), I get the following error:
"Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding."
Trying the same thing in Microsoft SQL Server Management Studio gives the same error, but a little bit of extra information:
"Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding. (SQL Server Mobile Edition ADO.NET Data Provider)"
As far as I can see, everything IS installed OK, so why is VS2005 not working?
Thanks for any help.
JB