Recent update: 2008-3-21
Hello All, I have a server with SQL Server 2000installed on it. I have created a tool that runs on a Pocket PC withSQL CE backend. Multiple clients would be using the tool on diferentPocket PCs. I would have to use Merge Replication for synchronizationand since the Pocket PCs would not have ...
hi allin the wireless application, if i use RDA to pull data from SQL server 2005 database.do i need to code a exernal class for the PDA to connect to the sql server.RDA pull data trough what medium, wireless or active sync, if i wanna pull data through wireless what should i do.By the way, how ...
Hello All, I have a server with SQL Server 2000installed on it. I have created a tool that runs on a Pocket PC withSQL CE backend. Multiple clients would be using the tool on diferentPocket PCs. I would have to use Merge Replication for synchronizationand since the Pocket PCs would not have ...
299 byte By
Fille at 2008-3-3
<FONT size=2> strSQL = </FONT><FONT color=#800000 size=2>"SELECT Naam FROM tblKlanten WHERE code LIKE '%"</FONT><FONT size=2> & str & </FONT><FONT color=#800000 size=2>"%'"</FONT></P> <FONT color=#800000 size=2>it works in sql but doens't in sql mobile how do i solve this?</P></FONT>
My PC app uses RAPI to install files to a CEDB database on Windows Mobile devices.Works for PPC 2002, 2003 devices, ActiveSync v3.8 and 4.1On Windows Mobile 5.0 devices with AS 4.1, RAPI fails on CeMountDBVol with an ERROR_INVALID_PARAMETER. What needs to be done to correct this? I have read ...
I tried to install sqlserver express on a tablet pc compaq T1000 with windows xp sp2, 512 ram. </P> A warning appears: hardware incompatible and the installation crashed trying to start sqlserver.</P> Any similar experience ?</P> Thanks</P> </P> </P>
274 byte By
Fille at 2008-2-27
<FONT> strSQL = </FONT><FONT color=#800000>"SELECT Naam FROM tblKlanten WHERE code LIKE '%"</FONT><FONT> & str & </FONT><FONT color=#800000>"%'"</FONT></P> <FONT color=#800000>it works in sql but doens't in sql mobile how do i solve this?</P></FONT> </span>
I tried to subscribe to the database that is published on my laptop running on windows XP professional SP2 and using SQL Server 2005. However, in the second step (synchronizing data) the following error message occured: Synchronizing Data (Error) Messages A request to send data to the ...
I've recently noticed the availability of SQL Server Mobile, and would like to take advantage of some of the new features, however, I'm currently using Visual Studio 2003. The requirements state that Visual Studio 2005 is required, but I was wondering if anyone has had any success getting it ...
Hello,I'm porting my C++ (EVC3) application from Sql CE 2.0 to Sql Mobile 3.0 (with OLE DB). To compact a 2.0 database, i used ISSCECompact interface. But it doesn't exists with the new version. I've only found C# and VB.Net samples in MSDN ... Thanks in advance. ...
Hi, I was wondering if anyone knows how to convert an array of bytes to an SQL CE 3 image type and vice versa. I am using the SDF Signature control and I would like to store the signature as an Image. It needs to be an image so it can be synced with a desktop access 2003 database. Cheers Simon ...
Hi,I have written application for Pocket PC it stores data on SQL CE database with extension .sdf. I have added data to the table and synchronised to the SQl server. I got the data, then unfortunately i deleted the data in SQL Server, I want to extract the data again from .SDF file of Pocket ...
As many of you know I've been hunting down a SQL CE alternative / embedded DB that is easily portable among handhelds. It turns out, that without paying for some other DB, there really aren't any good ones... Unless you go GPL, and the interpretation of GPL that most are using is that your ...
66 byte By
Fille at 2008-2-21
How can i synchronise (wireless) data from desktop to ppc? </span>
210 byte By
Fille at 2008-2-20
How do i set up a connection between sql mobile and sql server 2000?</P> I think all the packages are installed but how can i synchronize data from sql mobile to server 2000 and the other way?</P> </span>
Hi, I am new to SQL Mobile programming. I am using SQL Server 2005 Mobile and SQL Express. I have a mobile windows application + .sdf file in the PDA. When i try to pull the table the first time, the table is successfully retrieved to PDA. When i try to pull the table again, i get the following ...
On the paper: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=trueWhile trying to complete the exercise, I encountered the following unexpected behaviour:While configuring the subscription for the SQL Mobile (from the tutorial – ...
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 ...
286 byte By
C03N at 2008-2-18
Hi everyone, i'm currently programming an application for service engineers. In this application I use replication. The problem is that when I add a view to the publication, I still receive all the data. Does anyone know what I'm doing wrong? Thanks in advance. </span>
803 byte By
Touraj at 2008-2-17
Hi Everyone I am at the stage of architecting my solution My goal is to develop the system on a windows application and pda There is a central server which will create a publication called inventory The laptops which host the windows application will be subscribers to the central server using ...
803 byte By
Touraj at 2008-2-16
Hi Everyone I am at the stage of architecting my solution My goal is to develop the system on a windows application and pda There is a central server which will create a publication called inventory The laptops which host the windows application will be subscribers to the central server using ...
Hi, I am new to SQL Mobile programming. I am using SQL Server 2005 Mobile and SQL Express. I have a mobile windows application + .sdf file in the PDA. When i try to pull the table the first time, the table is successfully retrieved to PDA. When i try to pull the table again, i get the following ...
Hello,Was wondering if its possible with VS 2005 to create and populate a SQL Server Ce database on the desktop? Reason why I'm asking is it takes a very long time (~40 minutes) to process xml and insert the values into the sdf database on the Pocket PC. I would assume it is much quicker to ...
Using shared folder in windows mobile 5 emulator, it is not possible to create a database (sqlserver mobile 2005) in the emulated storage card. The error "sql mobile made an unsupported request to the host operating system. Minor Err 25133 is raised. Reading or writing file from/to the ...
382 byte By
Chikuu at 2008-2-15
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. ...
I want to SYNC the data on the server to the client, but never the client data to the server.</P> Is such a configuration possible with Merge Replication under SQL CE?</P> Thanks again!</P>
In VS2005 RTM using Server Explorer --> Right Click DATA CONNECTIONS --> Add Connection --> Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->ActiveSync Connected Devicewhen I hit Test Connection I hear ...
1098 byte By
BS24x7 at 2008-2-14
I had an application that I had written in C# under the .NET Compact Framework that imported CSV files and wrote them to a newly created SDF. I usually ran the application under Emulation. The resulting SDF was usually about 1.6 Megabytes.Now, under VS 2005 and SQL Mobile (AKA 3.0), the same ...
Hi,we're using SQL Server CE 2.0 on our CE 4.2 device (mobile scanning device).In some cases, the application freezes and the user must perfom a cold boot.After the cold boot, the database is some kind of corrupt - the application can't build up a new connection and a "Fatal Applicatio Error ...
Hi,Using VS2005, Framework 2 and SQL 2005 Mobile all from the recent launch in Australia, I have created a new Smartdevice project in c# and have created an SQL mobile database with 1 table in it.I added a datasource/dataset referencing the mobile database and it displayed the table/columns etc ...
Hi Can I have my query output returned as XML (FOR XML AUTO) in SQL Mobile ? thanks Bruce </span>
169 byte By
aquino at 2008-2-11
does anybody know how to install sql server mobile and the query analyzer in an hp ipaq rx1955? don't see the samsung processor in the processors list. thanks </span>
I have both used the Data Connection Wizard and tried programatically to connect to a Mobile SQL Database from within a Windows Application and keep on getting the same Error at the connection point"Unspecified error [ sqlcese30.sys.dll ]"The Debug message is" A first chance exception of type ...
246 byte By
som at 2008-2-10
i am using vb.net 2005 and sql server ce 2.0 for my pocket pc application. i need to import data from csv file to a sdf table. but bulk insert in not working on sql server ce 2.0. if any of you can kindly help me with the code. it is very urgent.
Hi,I have written application for Pocket PC it stores data on SQL CE database with extension .sdf. I have added data to the table and synchronised to the SQl server. I got the data, then unfortunately i deleted the data in SQL Server, I want to extract the data again from .SDF file of Pocket ...
We've migrated a .NET CF 1.0 App with SQL CE 2.0 to .NET CF 2.0 and SQL Server Mobile and we were wondering about the new behavior. A sample to reproduce:create table persons ( id int identity primary key, firstname nvarchar(100), lastname nvarchar(100)); create table logins ( id int ...
849 byte By
Abhi_7 at 2008-2-8
Is ISNULL ( check_expression , replacement_value ) supported in SQL Server 2005 Mobile edition. If not, then why the following statement executes without any error: - " select ISNULL(a,12) as test from tableA "Where 'a' is int column.However, even though i do not get an error, it doesn't ...
841 byte By
Abhi_7 at 2008-2-7
Is ISNULL ( check_expression , replacement_value ) supported in SQL Server 2005 Mobile edition. If not, then why the following statement executes without any error: - " select ISNULL(a,12) as test from tableA "Where 'a' is int column.However, even though i do not get an error, it doesn't ...
We've migrated a .NET CF 1.0 App with SQL CE 2.0 to .NET CF 2.0 and SQL Server Mobile and we were wondering about the new behavior. A sample to reproduce:create table persons ( id int identity primary key, firstname nvarchar(100), lastname nvarchar(100)); create table logins ( id int ...
1869 byte By
Drudkh at 2008-2-7
Hi, I would like to know if there's any method to get the total number of records in a table without using query. I have the following codes.Dim conn As SqlServerCe.SqlCeConnectionDim cmd As SqlServerCe.SqlCeCommandDim rdr As SqlServerCe.SqlCeDataReaderconn = New ...
3223 byte By
Drudkh at 2008-2-7
Hi everyone,I just started in developing applications for PocketPC. I found an example from this webpage link and I tried it out. I have a listbox to display the results.Dim mySelectQuery As String = "SELECT ID, Name FROM StaffData WHERE Name = 'John'"Dim myConnection As New ...
862 byte By
Alex_M at 2008-2-6
Hi friends,sorry for interposting but my question was left unanswered in another group.here's the question:The execution of follwing query against sql mobile DB goes fine in SQL Server Management StudioSELECT c.contactIDFROM contacts c LEFT OUTER JOIN contactNotes cn ON cn.contactID = ...
1422 byte By
mikean at 2008-2-6
I am trying to use SQL Mobile 2005 with Visual Studio 2005. I have a simple sql mobile db i created and am trying to test connectivity to the DB in a simple app. I added the reference to the SqlServerCE and the verison # that is shown in properties is 3.0.3600.0, but when i look at the physical ...
300 byte By
VDeevi at 2008-2-5
<span>What is the best way to synch with a very large database (e.g. 40,000 products in Inventory Master) in connection oriented way and also offline mode for remote synchronizing the Data from PDA to SQL Server 2005. Kindly provide us some of the best practices on this concept. Thanks </span>...
Hello, we are going to develop Pocket PC application in C#, targeting Windows Mobile 5.0. The application will use SQL Server Mobile database in the device to synchronize with publication created in SQL Server 2005 database. What security measures we have to take? Is the synchronization ...
In VS2005 RTM using Server Explorer --> Right Click DATA CONNECTIONS --> Add Connection --> Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition-->ActiveSync Connected Devicewhen I hit Test Connection I hear ...
162 byte By
Abhi_7 at 2008-2-4
How can one find the version number for sql server 2005 mobile edition programmatically or by some other means? Is it possible at all to find it programmatically?
581 byte By
Abhi_7 at 2008-2-4
What is the version number for the SQL Server mobile edition that is shipped with the RTM release of VS 2005? Where exactly can i find the installation for it? (either within the VS 2005 installation folder or independently on any site) The VS 2005 RTM that i download only consist of ...
2151 byte By
pdns at 2008-2-4
Hi,I am trying perform merge replication programatically between SQL Server 2005 and SQL Server Mobile. Using the following code (note i have changed some of the names for the purpose of the post <*> etc: private void Synchronise() { SqlCeReplication repl = new SqlCeReplication(); //repl. ...
Hi,we're using SQL Server CE 2.0 on our CE 4.2 device (mobile scanning device).In some cases, the application freezes and the user must perfom a cold boot.After the cold boot, the database is some kind of corrupt - the application can't build up a new connection and a "Fatal Applicatio Error ...