I want to know what is the query for sql server compact Edition version..Any help will be apreciated
View Complete Post
Is it possible to connect to Sql Server Compact Edition 4
and use it as Datasource? I'm able to connect to SQL CE 3.5 but not to the version 4.
Thanks in advance.
I was new to WPF and ADO.NET Entity Framework,
I was developing a WPF application in SQL Server Compact Edition 3.5 and connect with LINQ to Entities ,
I was thinking to migrate my database to SQL Server Compact Edition 4.0, can i remain the model i created in CE3.5 and directly adopt the CE 4.0 into my application?
If yes, may I know any references i should add in my project?
I have an issue on a Janam barcode scanner (wifi) with an App I have written, it appears the realtime SQL login screen intermittently puts a call onto the network when we run it on CE6. When we run the same app on a Psion scanner with CE5 it works every
time. I get the feeling its an SQL timing issue / lockout on the local client as no network traffic happens when it occurs, we restart the app and it sometimes works ??
The app is written in VS2008, the framework is v3.5, the cab on the terminal is sqlce.wce5.armv4i.CAB. there is currently no wce600 build but reading up the wce500 should be OK with ce6 ???
Anyone know of any SQL issues like this or what stops the connection to the SQL Server on the network?
I am developing a Windows desktop application which requires the SQL Server 2005 Compact Edition
(SQLServerCE31-EN.msi) to be installed. I am using InstallShield 2011 to
install this as a pre-requisite during the installation process.
In order to come up with the pre-requisite definition I used Process Monitor to see that these registry locations
are checked when SQLServerCE31-EN.msi is run manually (not via the installer):
32-bit: HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server Compact Edition\v3.1
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server Compact Edition\v3.1
64-bit: HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Microsoft SQL
I have develop a Delphi tool that allow to manage enterprise timesheet.
This application is used by multiple different user in an enterprise.
The tool can run under SQL Server 2000,2005, 2008 (express or not).
In my SQL queries within my application, there is a lot of "INNER JOIN", "OUTER JOIN" that is quite universal.
But there is also some "ISNULL(?,!)", "CASE WHEN ... .THEN ... ELSE .. .END".
I want to have a "free trial" version of my tool.
I can't ask my users to install SQL Server (it is a free trial).
I am not able to use SQL Server Compact Edition because I need a multi-computer connexion (each different employes of a company access the tool).
I dont really like ACCESS because there is some standard not respected (varchar datatype do not exist, memo field is not easy to manipulate compare to varchar(2000), CASE WHEN dont work, I have to make weird query junction with parenthesis when there is
multiple table, etc...etc...etc...).
My question : WHAT CAN I DO! I dreamed of SQL Server Compact Edition allowing multiple concurrent connexion and handling tables. Or SQL Server Express without install.
Is there a solution to this?
We're building a customÃÂ PC installation package to deploy our .NET Compact Framework 3.5 / SQL Server Compact Edition based application.ÃÂ The installationÃÂ package uses theÃÂ System.Configuration.InstallÃÂ and calls Process.Start(ceAppPath, iniPath).ÃÂ We are targeting ARM and x86 devices.ÃÂ Specifically, which SQL Server Compact Edition cab files do we need to install/deploy for our application to run onÃÂ the theseÃÂ device platforms?
any limitation with SQL Server 2008 compact edtion with Entity Framework 4?