Hi,
I can't seem to find which SQL Server Compact Edition version is pre-installed on the Windows Mobile 6 rom.
I guess it is 3.0, but I'm not sure about it.
Another question is, if I use SQL Server Compact Edition 3.5 by deploying the .dll files as part of my application's CAB installer, will this be a problem for Windows Mobile 5 or Windows Mobile 6?
Thank you in advance,
Hi,
View 3 Replies View RelatedI am confused about the version numbers for SQL Server Compact/Mobile. It _looks_ like the versions went from CE 2.0 to Mobile 2005 to CE 3.0 (or 3.1). Is this correct? In fact, I found one location the specifically said Compact Edition is the next version of Mobile. In another location I saw Compact Edition referred to as 2005 CE.
This has got me going because I am creating a Mobile/CE app and I keep getting a "Initialize SQL Server Reconciler" and the best information I can find indicates a mismatch between the server component and the client component.
So, what are the current versions of Mobile/CE? Is there a location that lists all of the components and what version they should be?
Thanks.
Chris Mecum
I've been trying to create an installer for a little .NET CF 3.5 app I've written for Windows Mobile. It uses SQL Server Compact 3.5.
I've got the .NET CF and my program to deploy on the device using ini files and ceappmgr.exe, but when I try to do the same for SQLCE 3.5, it doesn't work (more on this in a sec).
I need my installer to install across lots of different CPU architectures, so I created an ceappmgr INI file that includes all the different cabs for the different CPU architectures.
I'm trying to test the installer by making it install on my smartphone (ARM CPU). The problem is, when I install it I get an error message on the device "The installation file is not intended for this device.". I reckon this means ceappmgr is picking the wrong cab file and trying to make my phone install it!
I did a bit of testing and found out if I remove all the cabs from my ceappmgr INI file EXCEPT for the one that is appropriate for my smartphone, then it works fine! But as soon as I include a cab file that is not appropriate for my device (eg a different cpu architecture, or the ARM PPC cab file), it stops working and I get that "not intended for this device" message.
My INI file looks like this:
[CEAppManager]
Version = 1.0
Component = SQL Server Compact 3.5
[SQL Server Compact 3.5]
Description = Microsoft SQL Server Compact 3.5
CabFiles = sqlce.phone.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,sqlce.ppc.wce5.armv4i.CAB,sqlce.wce5.mipsii.CAB,sqlce.wce5.mipsii_fp.CAB,sqlce.wce5.mipsiv.CAB,sqlce.wce5.mipsiv_fp.CAB,sqlce.wce5.sh4.CAB,sqlce.wce5.x86.CAB
Any idea why ceappmgr would be (seemingly) picking the wrong cab file and trying to make my device install it?
Btw, my smartphone uses the "sqlce.phone.wce5.armv4i.CAB" cab file.
Cheers in advance.
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
Hello,
I want to learn if it is possible to develop applications for SQL Server 2005 Compact Edition using .NET Compact version 1.0. The major doubt is the possibility for version 1.0. It is reasonable to deliver SQL Compact Edition redistributables with an application, but this is not great to require ,NET 2.0.
Many thanks.
Hello,
I have a computer thats running XP 64 bit version. I want to replicate between SQL server 2005 and SQL server 2005 compact edition. But it doesn't works. So i looked for a solution and i came to:
http://support.microsoft.com/kb/912430
This page is telling me:
You cannot replicate data from SQL Server 2005 to SQL Server Compact Edition by using the 64-bit version of IIS
Is that a problem that can be solved by not using a other Operating System?
Or can you maybe install a 32-bit IIS on XP 64 bit?
Hi to everybody,
can Sql Server Compact Edition run on Windows 2000 SP3?
Thanks,
Emanuele
Hello
I recently downloaded the sql mobile edition, and then I found out about the compact edition.
I understand that these are relational lite version of sql server that can run on mobile devices.
However, what is the difference between the CF and mobile edition? Why should I choice one over the other?
I have just heard about sql everywhere, seems there are all these edtions and how would you choice the right tool for the right job?
Many thanks if someone could explain further,
Steve
Hello
We currently use SQL Mobile and SQL Server 2005. We depend heavily on merge replication for data to the field handheld devices.
We are going to be starting some new projects and I was wondering about moving to SQL Compact Edition as the first step to migrating all of our applications.
I am concerned, however, about the server side and replication. If we simply deploy SQL Compact Edition will there need to be any changes to the server for replication?
Thanks,
- will
I have not seen much info on this so I thought I would ask the forum. I have VS2005, no SP1 and SQL Mobile installed on my computer. I started developing an app for Windows Mobile 5 using RDA and it appears to work fine. Now I want to know what happens to SQL Mobile if I install SQL CE. Is it going to affect my app? Do I have to install the SQL CE merge replications tools for IIS again? I already have them for SQL Mobile? Will this affect the operation of my app? It looks like the installation procedures call for installing SQL CE tools to VS2005 before installing VS2005 SP1 then install VS2005 SP1 and finally install SQL CE tools for VS2005 SP1. Any help, thoughts or experiences involving this would be appreciated.
View 3 Replies View RelatedI am using VB2005 , Windows CE 5.0 , SQL server 2005 compact edition
and using XML reader, but it will show the empty SQLCeException ,
why does it occur?
The source it show at the follow :
-----------------------------------------------------------------------------------------------------------------
Imports System.Data.SqlServerCe
Imports System.Xml
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBPath As String
Dim mydr As XmlTextReader = New XmlTextReader(m_sXMLFileName)
mydr.WhitespaceHandling = WhitespaceHandling.None
While mydr.Read()
' Look for the <configuration> section
' This lets us add several peices in the config file
If mydr.Name = "DBPath" Then
DBPath = mydr.Name
End If
End While
mydr.Close()
Me.MobileDataTableAdapter.Connection.ConnectionString = "Data Source =""Program FilesCEdatabaseMobileDatabase.sdf"";"
Try
If MobileDatabaseDataSetUtil.DesignerUtil.IsRunTime Then
'TODO: Delete this line of code to remove the default AutoFill for 'MobileDatabaseDataSet.MobileData'.
Me.MobileDataTableAdapter.Fill(Me.MobileDatabaseDataSet.MobileData)
End If
Catch ex As SqlCeException
MessageBox.Show(ex.Message)
End Try
End Sub
End Class
We have a plan to use Microsoft SQL Server 2005 Compact Edition RC1 as a backend. Our Front-end is VS .NET (VB.NET).
We want to know how to edit the Compact Edition database (.SDF). Is there any editor is available right now in the market? or microsoft provided any editor for this.
OR Can i use microsoft 2005 sql server standard edition for this.
Thanks
I have:
A server computer running SQL Server 2005 Enterprise Edition.
A industrial computer running SQL Server 2005 Express Edition.
And now also a Psion WorkAboutPro with CE 5 that should run SQL Server Compact Edition.
The industrial computer syncs its data with the server, basically saying "this has happened".
Now I want the Psion to sync with the industrial computer, but this sync must two-way.
I have tried to find a guide or something that can tell me "do this to sync" but the information i have found is sketchy at best.
If someone could point me in the right direction of a guide or something else it would be much appreciated.
Regards,
Björn
Thanks.
View 2 Replies View RelatedHello,
I am using Compact Edition in a fairly large C# application being developed using Visual Studio 2005.
I downloaded Compact Edition in August 2007. The file version of all of the CE dlls: sqlceca30.dll, sqlcecompact30.dll, sqlceer30EN.dll, etc. is
3.0.5300.0
The installation file that I downloaded to install Compact Edition is "SQLServerCE31-EN.msi", which to me implies that it is Version 3.1.
Now, however, if I go to the Compact Edition downloading website, everything refers to Version 3.5.
In fact, the title of the download page is
"SQL Server Compact 3.5"
The word "edition" seems to have been taken out of the name. It also appears that the version I downloaded in August 2007 is no longer available.
I cannot find any information about the differences between the August 2007 version that I am running and the current Version 3.5.
I have a couple of questions:
What happened here?
Is there any risk in moving from the August 2007 version to "SQL Server Compact 3.5?
I will appreciate any help you can provide.
Thank you,
WTW
Hello,
there are some limitations in SQL Server 2005 Mobile Edition - e.g. there is no TRUNCATE TABLE statement, the UPDATE .. FROM clause is not allowed etc. Are these limitations in Compact Edition too? Is T-SQL in these editions functionally equal or different? Is there any comparison of T-SQL features in both editions?
I'm currently looking at adding a database to my company's WinCE 4.2 -based device, running applications coded with embedded CE 4.0. We want to start tracking potentially large quantities of user data (10K-30K 500 byte records) and are looking at a database engine to support this. The database would reside on the device although we would potentially dump the data from the devices to a central workstation that would be used to pull reports about the data across multiple devices. SQL Server Compact Edition sounds like a possible solution, but I'm unclear if it's supported on CE 4.2 or how to install it if it is. It's clearly supported on CE 5.0, but it may be a while before we upgrade to CE 5.0 or 6.0. I've seen references that say that SQL Server Compact Edition is the same as SQL Server Mobile Edition, and references that Mobile Edition is supported on CE 4.2, but I'm unclear if I can install and use SQL Server Compact Edition on CE 4.2 or if I'm on a wild goose chase. If not, can I use SQL Server Mobile Edition and migrate to SQL Server Compact Edition when we upgrade CE to 5.0 or 6.0? If not Mobile Edition, what about Microsoft SQL Server CE 2.0? Is that going too far back in the archives?
Thanks for any guidance/enlightenment you can offer.
Hello,
we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.
Why is this error happening and how can we resolve this?
BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.
Thanks,
Markus
Hello
I have recently downloaded Orcas beta VS product and had no previous version of VS before. The install went clean and I have been able to generate Window apps and web apps with very little issues; however, I have one issue with running a web app using the "view in browser" option for checking an aspx page for validity. If I use the default Northwind database provided and generate an aspx form using the "DataSet" toolbox widget, the tool prompts for the datasource etc. required to generate the required code. I can select the Northwind database and select the desired columns from one of the tables. Once completed, I build the project (clean build) and then select the "view in browser" option to verify the results. The result is an error page indicating a server error ->
Failed to find or load the registered .Net Framework Data Provider.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider.
I created on odbc connection to an iSeries(as400) box and was successfull in displaying the table on the webpage! I looked into the web.config file and it appears that all the required XML data is present. Any help would be appreciated as I am fairly green when it comes the .NET world.
Thanks
Hello
installed:
VS2005 Sp1
SSCE31VSTools-ENU.exe
SQLServerCE31-EN.msi
When creating mobile project in VS2005 it automaticaly adds reference to System.Data.SqlServerCe,
version: 3.0.3600.0
path: C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll
instead of: C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400System.Data.SqlServerCe.dll
version: 3.0.5300.0
When creating desktop solution I don't have this problem.
Please help!
Thanks
Hi there,
everything is ok for first run. but i leave the program relogin
than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine.
can anybody help me?
VS2005 ver 8.0.50727
SSCE31VSTools-ENU.exe loaded
SSCE31SDK-ENU.msi loaded
machine 1
SQL 2005 loaded
machine 2
http://192.168.20.22/ssce/sqlcesa30.dll
"Microsoft SQL Server Compact Edition Server Agent" looks fine
pocket pc side
C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4
.net cf 2.0 sp2
sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB installed too.
my code
---------------------------------------------
Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"
Dim rda As SqlCeRemoteDataAccess
Try
rda = New SqlCeRemoteDataAccess "THIS LINE GIVES ME THAT ERROR
Catch ex As Exception
MsgBox(ex.ToString)
Application.Exit()
End Try
Try
rda.InternetLogin = [String].Empty
rda.InternetPassword = [String].Empty
rda.InternetUrl = "http://" + IP_no + "/ssce/sqlcesa30.dll"
rda.LocalConnectionString = ConnectString
Catch ex As Exception
MsgBox("Bağlantı hatası..")
Application.Exit()
End Try
------------------------------------------------------------------------------
i added the following code to very beginning of my code too.
that code lock my device
Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr
Dim pt As IntPtr
pt = LoadLibrary("\windowssqlceca30.dll")
pt = LoadLibrary("\windowssqlceoledb30.dll")
pt = LoadLibrary(\windowssqlcecompact30.dll)
-----------------------------------------------------------------------------
The device I'm working on has a filesystem on compact flash, but we're concerned about burning it up with excessive writes. One solution might be to keep the SQL database in the the object store, perhaps dumping a copy out to the CF as backup. Any pointers as to how to accomplish this? If we were to keep the db in a file on the CF, what's the SQL Server CE behavior for writing to the file? Does it write every time a record is created/updated, or is there any ability to control when the data is flushed to the file?
Thanks from an SQL newbie.
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
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
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?
I want to find whether SQL Server 2005 x86 is installed or SQL Server 2005 x64 is installed programatically(Any API would do.) If anyone can recommend a registry key that I can rely on find whether it is a 32 bit or 64 bit SQL Server that would suffice.
View 5 Replies View Related
Hi:
When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.
All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?
Any help would be appreciated I"m just starting to use SQL CE.
thanks
mark
We installed an Enterprise version onto a server that only needs Standard. Unfortunately an outside supplier installed software and databases on it before we realised our mistake. Is it safe to just install Standard 'over the top'and what would that do to the application's databases ?
View 1 Replies View RelatedWhen I ran @@version I get this:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
I assume this is a licensed version because the std edition does not have a trial license? Can someone confirm this?
If this were a trial version, what could I expect to see?
Hi,
I've had troubles in the past with this bug - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=158671&SiteID=1 - where 'join's with 'order by' did not work correctly. So is there a new version where I don't need a workaround and if yes, where is this version available? The latest version I know of is 3.0.5214.0, but in the meanwhile SQL Server 2005 SP1 had been released so I did remember that there is this open bug in SQL Server Mobile.
Regards,
Klaus
Hi all,
I'm in a middle of a server migration,
Old server:
SBS 2003 sp1 with SQL server 2000 and SQL server CE
New server:
SBS R2 with SQL server 2005 and SQL server mobile
I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it.
In old server i have replications set and my CE database is on SQL 2000 how this will fit on SQL 2005 / SQL mobile?
If some one can point me on good way i appreciate.
Cheers,
Hello,I am having trouble installing Evaluation copy of SQL Server on mynotebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.After I run the Setup.exe, I get the files files extracted in theSQLEVAL directory.As per the instruction, I need to run Autorun.exe file. For somereason, when I try to run this file, a new windows pops up, which isblank black screen with cursor flying around in the window. The titleof the window isC:windowssystem32wowexec.exeThis is how far I have reached while trying to install the database. Iwould really appreciate if someone could provide some suggestions.VS
View 2 Replies View Related