Pocket PC And SQL Server CE.


How to replicate data from SQL Server CE (Pocket PC) to MSDE using C#
(data size = from 2 to 10 MB)?
*Best regards,*
Klaudiusz Bryja

View Replies


Pocket PC Remote Sql Server App


I am interested in developing a remote Pocket PC database application with wireless connection to the database via the internet. Does anyone have experience in this? What is involved and what technologies are the best approach and why?

I think that SQL Server 2000 has some kind of stub program available for the Pocket PC for this purpose. This is my dream platform for remote sales applications with live data access to the company database at a remote location wirelessly.

I would appreciate any and all helpful input.


Vincent DeLuca

View Replies View Related

SQL Server 2005 Express Works With Pocket PCs?

I am trying to find out if SQL Server 2005 Express Edition databases will work on a Pocket PC with Pocket PC 2003 SE OS. Does anybody know the answer or can direct me where I can find the answer?

View Replies View Related

Synching SQL Server Data On A Pocket PC And Windows?

I asked this question on another forum, and it was suggested that using SQL Server might be the way to go.

What I would like to do is create a database that can store detailed employee payroll information for workshop production. Included in this db would be employee info, job details, hours worked, pay rate, and so on and so forth. That will probably be the relatively easy part.

I would like to allow supervisors (job coaches) to enter this data on a Pocket PC (windows mobile) device, and then be able to synchronize the pocket pc to a workstation, allowing their data to be uploaded to the main database at the end of the day.

Can that be done using SQL Server as both the main networked database as well as having it (or a lite version of some sort) installed on a Pocket PC for synchronization purposes as described above?

Thanks for any input.

View Replies View Related

Sql Server 2005 && Pocket Pc2003Se Connection

how do i connect to sql server with pocket pc2003 se emulator.it gives me the sql exception all the time.i tried to install virtual machine network adapter but result is same.Am i missing something?

Thanks in advance

View Replies View Related

Beginner Q: Pocket PC Access To SQL Server 2005


I am a total beginner to Pocket PC, and a 2-month beginner to SQL Server 2005 and Visual Studio 2005. I made a database Pillbox.mdf, and wrote a Windows Forms program to access it. It's really easy. I just added a Data Source, chose tables and Stored Procedures, and dragged them onto my forms. It automatically created adapter classes and a DataGrid for me.

Next, I wanted to do the same thing for Pocket PC. I did the same drag and drop thing, and was happy to see the empty DataGrid in the emulator (design-time) form. From here on, trouble. When I ran it, it said it could not connect.

So some questions:

1) Does my connection string have to change? It has 3 parts: machine name, database name, and security spec. It specifies my machine name. Is that ok? Is it known by the Pocket PC, or do I have to specify http something? Does my machine have to change any settings to become a "server"? It's just a standalone PC with no network. I understand the emulator chooses to pretend that it's not "on" my computer. Is the database name known by the Pocket PC? (Same type of question.) And is Windows authentication ok on a Pocket PC? Or must I create a name/password pair on SQL server?

2) When I went to modify my connection string, I noticed a setting to specify the Data source. For SQL Server 2005, it asks me for a dbo, but for SQL Server Mobile, it asks me for a *.sdf file. What type of file is this? Is there a way to generate this from my other database? Is it not possible to have the the Pocket PC app point to the same database as the Windows app? Oh... does the sdf represent the Pocket PC's local database? If so, then my question is just how to populate it. But I will also have to update the main database at some point. I guess I'm confused about how Pocket PC's are supposed to work.

3) Do I have to deploy SQL CE or something? I think I read that Visual Studio does it automatically. It's a bit hard reading blogs because many comments talk about things that are now contained in VS. One blog was talking about 7 dlls that need to be downloaded to the Pocket PC.

4) My application just has to get a table, store it on the Pocket PC, and allow the user to modify and update records. The bandwidth should be low, as the table is small and updates should not be frequent. Is this a reasonable design? What I am asking is if it's ok to have direct database access, or if I should package up the data in some custom format, and use a Web service to pass the data back and forth. I have read and understood articles why you should not pass a Dataset in a web service, but the point was just that web services can be interoperable, so why spoil that with MS-only Datasets. In my case, I just want to get this simple app up and running quickly.

Thanks in advance.

View Replies View Related

Connecting To Sql Server 2005 From Pocket Pc 2003 Emulator

Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button:

Code Block private void menuItem1_Click(object sender, EventArgs e)

SqlConnection sqlCon;
sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
@"", "MojDom", "kuba", "abuk"));

string insertString = @"insert into {0} values ('{1}', {2})";
SqlCommand cmd;

cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon);

if (sqlCon.State == ConnectionState.Open)


and on line sqlCon.Open() i get exception:

Code Block

System.Data.SqlClient.SqlException was unhandled
Procedure="ConnectionOpen (Connect())."
Source=".Net SqlClient Data Provider"
at System.Data.SqlClient.SqlConnection.OnError()
at System.Data.SqlClient.SqlInternalConnection.OnError()
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Connect()
at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
at System.Data.SqlClient.SqlInternalConnection..ctor()
at System.Data.SqlClient.SqlConnection.Open()
at AIHouse.FormMain.menuItemSettings_Click()
at System.Windows.Forms.MenuItem.OnClick()
at System.Windows.Forms.Menu.ProcessMnuProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at AIHouse.Program.Main()
And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off.

I really dont have any idea why it's not working.

sorry for my english, but its not my foreign language.

thx for sugestions and reply.

regards Kuba

View Replies View Related

How To Migrate Data From Sql Server 2005 To Local Pocket PC?


I have a database on a sql server 2005, and I would like to migrate data from sql server 2005 to local Pocket PC. How can I create a database on local Pocket PC and how to migrate the data from sql server 2005 to local Pocket PC? The operating system on Pocket PC is Microsoft® Windows Mobile„¢ 2003 Second Edition. Thanks in advance.

View Replies View Related

Microsoft SQL Server 2005 Compact Edition 3.5 And Pocket PC 2002

Is there any way to install SQL Server 2005 Compact Edition 3.5 on a Pocket PC 2002 mobile device.



View Replies View Related

Pocket Pc 2002 Sqlce Data Synchronization With Sql Server 2000 (SP4)

i am using C#..net

I am synchronizing the sql server data with sqlce.but i get an
error when i call synchronize function. i am using sqlcereplication

the error is

"a call to sql server reconciler failed"

native error 29006

and sometimes

native error


View Replies View Related

Sdf File Edited In SQL Server Managment Studio Crashes My Pocket Pc Application.

I have a sql server ce db file that I use in my pocket pc application. It seems to be working until I try to edit my .sdf file in SQL Server (2005) Managment Studio. After this I cannot open modified file in my application.

I receive native exception error when I call Open method for Connection object:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x03f8aaac
Reading: 0x00000010

When I edit .sdf file in another pc it's all working.

My config is:
windows vista business
.net compact framework 2.0 sp2
sql server 2005
sql server 2005 compact edition
sql server 2005 compact edition server tools
sql server 2005 compact edition tools for visual studio 2005

Best regards

View Replies View Related

SQL Server Mobile 2005 Merge Replication Failing Over SSL, But Can Browse Through Pocket IE.

Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL. Any help would be greatly appreciated.

Device Env:
Windows Mobile 5.0 + Messaging and Security Feature Pack
SQL Server Mobile 2005.

Merge replication works fine without SSL. After running the Configure Web Sync wizzard to setup SSL merge replication no longer works. Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine. There was no prompt saying the cert was bad etc.

The certificate is a:
Equifax secure global ebusiness CA-1 cert.
Signature algorithm md5RSA
public key RSA(1024 bits)
thumbprint algorithm sha1

Stacktrace given is:
- ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException
- Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
Count 1 Integer
Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Data.SqlServerCe.SqlCeError
HResult -2147012858 Integer
InnerException Nothing System.Exception
Message "A request to send data to the computer running IIS has failed. For more information, see HRESULT." String
NativeError 28037 Integer
Source "Microsoft SQL Server 2005 Mobile Edition" String
StackTrace "at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeReplication.Synchronize()
at MyApp.Helper.Replication.SynchronizeInit()
at MyApp.CallSynchronize()
at System.Windows.Forms.Control.OnGotFocus()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.ContainerControl.WnProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at MyApp.Program.Main()

View Replies View Related

Need Help On A Visual Basic.net Pocket Pc App. With SQL Server CE 2005 And SQL Server 2005 Synchronization Problem

I am developing an application for pocket pc 2003 smart device which utilizes synchronization between SQL CE 2005 and SQL server 2005 by means of REMOTE DATA ACCESS method call PULL( ) and PUSH( ) but currently these are the details of the error Im encountering when PULL( ) method is called:

Error code: -2147467259
Descripion: An error occured on the computer running IIS.Restart the IIS server.

Minor error: 28022
Source: SQL server CE
Currently Im developing this application as a final project and due to some limitations I have setup my pc to act as the SQL server and the IIS server both on the same machine.

Any help will be appreciated, thanks.

View Replies View Related

Printing From Pocket PC


I am developing an applicaiton through which, i want to print from pocket pc emulator 2003. I am using PrinterCE.NETCF SDK to do this task. I am able to print from my applicaiton like we do in ASP (Printing one line at a time). In PrinterCE, there is an option of printing the output to a file. But, I am not able to find how we do it.

So, I want to know how we can print the output through PrinterCe into a file. Can anybody help me??

thanx and regards
ramesh chandra

View Replies View Related

MSSQServer 2000 For Pocket Pc

Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");


Which are the driver that i needed?



View Replies View Related

Can't Open .sdf DB On Emulator (Pocket PC)


I'm a developer of VB.NET mobile applications at work. We have used Access in the past, and manually pushed flat files to and from the scanner. We are now exploring SQL CE.

Trouble is, I am having a difficult time figuring out how to open SQL CE databases on the Pocket PC emulator. I've worked more on the middleware programs in the past - and have just dealt with ADO.NET connection strings - not the actual development on the scanner itself.

I am try to figure out how to actually connect to SQL Server CE on the Pocket PC 2003 SE emulator.

When I deploy the application on the emulator, it installs SQL Server CE onto the emulator. However, I'm not sure how to install the sample database (starting off with Northwind.sdf for testing purposes) onto the emulator. I'm also not positive the connection string is correct - as it seems to be different than typical ADO.NET.

Here's my code (for connecting to the database) so far.

Code Snippet

Public Class SampleInventorySystem

Private _conn As SqlCeConnection
Public Sub New()

' This call is required by the Windows Form Designer.

_conn = New SqlCeConnection("Data Source = .Northwind.sdf") 'This is one of 'many connection strings I've tried

End Sub
Private Sub SampleInventorySystem_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim cmd As New SqlCeCommand()

cmd.Connection = _conn
cmd.CommandText = "SELECT [Employee ID], [Last Name], [First Name], Photo FROM Employees"


Catch ex As Exception
MessageBox.Show("Error opening database", "Error")
End Try

End Sub

End Class
When I deploy the application, the Try Catch block catches the error "Error Opening Database". I've also tried putting the full path for the connection string. Is there a folder which I should directly put the .sdf file into the emulator - similar to the folder directory of the scanner? (i.e. Storage Card/...)

Thanks for your help!

View Replies View Related

Syncronize Pocket Pc, VB.net And Ms Access

I have developed an application using visual studio 2005 and I am trying to figure out how to store the data on the pda and sync it with a dadabase on the pc. we have a database server but it is only have sql server 2000. i have only been able to find instruction for sqlserver 2005. can anyone help.

thank you

View Replies View Related

Creating Mobile Database On Pocket Pc

Does anyone know a site that shows me how to develop a mobile databasesystem on the pocket pc? im a newbie to mobile databases. Thank you.regards,eugene

View Replies View Related

Urgent: Drop Database On Pocket PC


Any body please give me any reference to the C# code, how to drop a database on SQL SERVER CE.

thanx and regards
ramesh chandra

View Replies View Related

Pocket PC Application Cannot Push Data

I have a Pocket PC application (VS2005, SQLCE 2005, Windows Moblile 5.0, SQL Server 2000) that can pull data with no problem but produces an error when an RDA push is attempted. The error message is: Error Code: 80072EE4 Minor Err: 28037. The information in TechNet has description of : A request to send data to the computer running IIS has failed. For more information, see HRESULT. It does produce a log in the folder for SQLCE 3.0 and has the following message: Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId = -1. Not sure if this means anything because I can't find much information on it. Anyone have any ideas on what this could be? Do I display the HRESULT the message mentions in Visual Studio debug? We have this working on our development server so I am not sure what is different here.

View Replies View Related

Problem Regarding Windows Mobile And Pocket Pc

we are using windows ce5.0 smartphone ,it is working fine but here the problems is the values which we are entering in front end are not inserting into database.i will clearly explain what we have done.

we have taken a dataadapter from dataset.xsd.we configured select and insert statements through wizard,now we are creating instance for that particular adapter and calling inser method by passing values.
mobiledbDataSetTableAdapters.labinformation1TableAdapter ins = new testing.mobiledbDataSetTableAdapters.labinformation1TableAdapter();
ins.InsertQuery("B", Convert.ToInt32(txt_nb.Text), Convert.ToInt32(txt_pb.Text));
alternatively we have taken the dirrect metheod i.e
SqlCeConnection con1 = new SqlCeConnection("Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\mobiledb.sdf;Persist Security Info=False"));
con1.Open(); string stra;
stra = "INSERT INTO labinformation VALUES(getdate(),'A'," + Convert.ToInt32(txt_na.Text) + "," + Convert.ToInt32(txt_pa.Text) + ")";
SqlCeCommand cmd = new SqlCeCommand(stra, con1);SqlCeTransaction Trans = null;
Trans = con1.BeginTransaction();
now we are taking a data grid with data source from dataset.xsd,another dataadapter(select stament).the problem is

the values are not inserting into database but showing in datagrid

if we close and open the application datagrid is not displaying what we it has displayed previously


View Replies View Related

Unable To Call SQL View From Pocket Pc

When I try to do a pull using a view I'm getting the following error message:

€œThe query cannot be tracked. There might not be a primary key, or the query might involve multiple tables. [ Query string = SELECT * FROM DATABASE_NAME.viewname ]€?

but when I do a select col1 from view I get my data. The view has some inner joins included in it, could that be the issue?

NOTE: this is from my handheld device, its not SQL Server related. I posted this earlier in this forum but it was moved to SQL Server.

I get the error on my handheld device and handheld device only

View Replies View Related

[Ask]Getting Files From Pocket Pc Emulator To Desktop Pc

I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ??

thanx b4

View Replies View Related

¿Data Transfer Pocket PC &&<--&&> Desktop PC?


I'm new to this forum and also new to Visual Studio 2005 .NET.

I'm going to develop a pocket pc(windows mobile 2005) application which needs to save some data introduced by the user.Later that data should be syncronized with MS SQL Server database.

The application is going to be developed using Visual Studio 2005 with c#.

So I'm doubting wich is the best way of syncronising the data between Pocket Pc and a Desktop PC.Should i use MS SQL Server Mobile(RDA,Merge Replication) or XML(Xml Web Services) would help me better?Or is there any other better way of data syncronization/storage?

Could anyone help me,or post some links + code samples,please?


View Replies View Related

Problem On Running Replication On Pocket Pc

hi i tried to view a replication on a pocket pc app that i created. and i used the following code

private void Sync()
public string AppPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
SqlCeReplication repl = new SqlCeReplication();

repl.InternetUrl = @"http://naomi/sqlmobile/sqlcesa30.dll";
repl.Publisher = @"Naomi";
repl.PublisherDatabase = @"SQLMobile";
repl.PublisherSecurityMode = SecurityType.DBAuthentication;
repl.PublisherLogin = @"sa";
repl.PublisherPassword = @"<...>";
repl.Publication = @"SQLMobile";
repl.Subscriber = @"SQLMobile";
repl.SubscriberConnectionString = @"Data Source=""" + AppPath + @"SqlMobile.sdf"";Max Database Size=128;Default Lock Escalation =100;";
catch (SqlCeException e)

when i run it i keep on getting the error:
The SQL Mobile Subscription already exists. Publisher, PublisherDatabase, and Publication for this subscription should be different from any existing subscription.

However, i can still view the contents of the datagrid that refers to the database subscription.

1. What should i do in order to stop getting the error above?
2. If i edit the contents of the datagrid in the pocket pc app how will i update the replication in the sql server? thanks

View Replies View Related

Pocket Pc Mssql Remote Database Admin

Hi,I am working on an Open Source pocket pc remote databaseadministration utility using C# (i.e. the native .Net CompactFramework, not the opennetc).Anyway, i wanted to ask that does this application has some potentialor i am putting my free time to waste ;)BTW the application has started to take shape and you can have a lookat http://www.pocketsqlman.com for a brief outline of what the wholeidea is.Regards,Dheeraj Juneja

View Replies View Related

Porting Database Functions From WM 5 Pocket PC To WIN32

Hi all,

I'm working on porting a solution running under WM 5 Pocket PC to Win32 but I got some problems with type definitions like CEOID, CEGUID... I saw that these types are defined in windbase.h (EDB definition added to preprocessors) ) which includes types and definitions usefull for database managment. Anyway this header file is not present in C:Program FilesMicrosoft Platform SDK for Windows Server 2003 R2Include, so I was wondering which is the header file I can use instead of it. Thanks

View Replies View Related

Performing Insert / Update Queries Using Pocket PC / SQL CE

I'm writing an application for Windows Mobile 5 / Pocket PC using VB.NET 2005. The database is connected using an instance of SqlCeConnection and updated by an SqlCeCommand.

The application can perform select queries on data originally entered into the database through Visual Studio, or perform update / insert queries at run time. Anything inserted or updated can be returned by a select query whilst the application is running, however, anything I have inserted or updated doesn't appear to be written to the SDF file and hence is not in the database after restarting the application.

Am I missing something that's different between performing queries on an SQL CE database on Pocket PC and an ODBC source in a normal Windows application?

View Replies View Related

How To Develop Today Screen Plug In For WM5 Pocket PC

Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.

View Replies View Related

How To Start Develop Database Applicaton On Pocket Pc ?

i have install vs2005 and wm5 sdk on my pc. i want to develop database application on my pocket pc (database = sqlserver 2005 express)

- i need to install another software on my pc or pocket pc ?
- how to start develop database application on my pocket pc?

thank you

View Replies View Related

Can Not Connect To Desktop Sql Database From Mobile Device (Pocket PC)


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."


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)


Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While


End Using

End Sub

End Class

View Replies View Related

How To Connect With SqlServer 2000 In Pocket PC 2003 Application.

How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?

View Replies View Related

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