From Insider: Sql Server 2005 Compact
-
Chris Buckett wrote:
Either way, the DLL's run in-process with your application.
The second article I linked to gave a list of DLL's that are included in the runtime but didn't indicate if that's all there was. This article[^] says that "[SQLce] includes a small process that runs only when applications access its data files."
0 bottles of beer on the wall, 0 bottles of beer, you take 1 down, pass it around, 4294967295 bottles of beer on the wall. Awasu 2.2.4 [^]: A free RSS/Atom feed reader with support for Code Project.
You're right, the second article does seem to indicate that it needs installing. The documentation from this[^] page indicates that this isn't required (specifically page 9 of "Comparing SQL Server Express and Compact" document). So, I've done a test just to see. I've copied the dll's into a test app folder, and deployed them onto a clean machine with just the .exe and the .sdf (database file) in the same file. Running the exe with the dll's in the same folder works fine (I get data access), move the dll's out of the exe's folder, and as expected, it generates an exception. I expect the small process you mention is there to handle the connections (apparently it supports max 256), rather than letting the app access the file directly.
ChrisB ChrisDoesDev[^]
-
Chris Buckett wrote:
Either way, the DLL's run in-process with your application.
The second article I linked to gave a list of DLL's that are included in the runtime but didn't indicate if that's all there was. This article[^] says that "[SQLce] includes a small process that runs only when applications access its data files."
0 bottles of beer on the wall, 0 bottles of beer, you take 1 down, pass it around, 4294967295 bottles of beer on the wall. Awasu 2.2.4 [^]: A free RSS/Atom feed reader with support for Code Project.
Taka Muraoka wrote:
"[SQLce] includes a small process that runs only when applications access its data files."
So it cannot be used in ASP.NET mid-trust environments. :|
________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
-
Where did this come from? Why did no-one tell me? This is just what I've been looking for (ok, obviously not too hard). I've been trying to pin down the achitecture for a single user desktop app, and I've been torn between using Access or Sql Express as the data store, the problem being that Access is, well, Access, and Sql Express really is overkill. It looks like this new release is perfect. It's embeddable, it scales up easily, it's secure, it's lightweight. I guess I'd better have a play with it.
ChrisB ChrisDoesDev[^]
I created an ASP.NET application just to test it. I successfully create the data file, and when I try to create the tables (from code) I get this nice error:
SQL Server Compact Edition is not intended for ASP.NET development.Very annoying. :suss:________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
-
I created an ASP.NET application just to test it. I successfully create the data file, and when I try to create the tables (from code) I get this nice error:
SQL Server Compact Edition is not intended for ASP.NET development.Very annoying. :suss:________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
:laugh::laugh::doh: At least the error message is succinct! Oh well. Reading more, it seems that it's a development of (and renamed) SQL Mobile that now targets desktop os's as well as mobile.
ChrisB ChrisDoesDev[^]
-
Chris Buckett wrote:
Either way, the DLL's run in-process with your application.
The second article I linked to gave a list of DLL's that are included in the runtime but didn't indicate if that's all there was. This article[^] says that "[SQLce] includes a small process that runs only when applications access its data files."
0 bottles of beer on the wall, 0 bottles of beer, you take 1 down, pass it around, 4294967295 bottles of beer on the wall. Awasu 2.2.4 [^]: A free RSS/Atom feed reader with support for Code Project.
Then they're wrong. SQLce is entirely in-process. Perhaps there's a helper process that gets loaded if you invoke it in a particular way (would COM+ end up creating a dllhost.exe process if you insisted, in your
CoCreateInstancecall, that you wanted it out-of-process?) SQLce is in fact basically just SQL Server 2005 Mobile Edition, previous versions known as SQL Server CE because they were a SQL Server-like implementation for Windows CE. Windows CE has no processes to waste, being limited to 32 process slots, of which some are already lost to nk.exe (the user-mode part of the 'kernel'), gwes.exe (Graphics Windowing and Events Subsystem - GDI+User), device.exe (device drivers), filesys.exe (filesystem drivers) and typically a shell process.Stability. What an interesting concept. -- Chris Maunder
-
I created an ASP.NET application just to test it. I successfully create the data file, and when I try to create the tables (from code) I get this nice error:
SQL Server Compact Edition is not intended for ASP.NET development.Very annoying. :suss:________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
Dario Solera wrote:
I created an ASP.NET application just to test it. I successfully create the data file, and when I try to create the tables (from code) I get this nice error: SQL Server Compact Edition is not intended for ASP.NET development. Very annoying.
As most ASP.NET apps run on a server, I can understand why the Compact edition doesn't work. A server would indicate serving more than one user whilst Compact isn't multi-user.
Michael CP Blog [^] Development Blog [^]
-
:laugh::laugh::doh: At least the error message is succinct! Oh well. Reading more, it seems that it's a development of (and renamed) SQL Mobile that now targets desktop os's as well as mobile.
ChrisB ChrisDoesDev[^]
I found a workaround (I'm a genius!). Since I used .NET Reflector, I'm not sure it's legal. Should I post it? It actually works like a charm. Oh, wait. It's a documented feature. But, anyway, I found it myself using .NET Reflector, and I'm proud of it.
________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
-
Dario Solera wrote:
I created an ASP.NET application just to test it. I successfully create the data file, and when I try to create the tables (from code) I get this nice error: SQL Server Compact Edition is not intended for ASP.NET development. Very annoying.
As most ASP.NET apps run on a server, I can understand why the Compact edition doesn't work. A server would indicate serving more than one user whilst Compact isn't multi-user.
Michael CP Blog [^] Development Blog [^]
Michael P Butler wrote:
I can understand why the Compact edition doesn't work
I either do, but still I'd like to use it. BTW, check my post above...
________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
-
I found a workaround (I'm a genius!). Since I used .NET Reflector, I'm not sure it's legal. Should I post it? It actually works like a charm. Oh, wait. It's a documented feature. But, anyway, I found it myself using .NET Reflector, and I'm proud of it.
________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
Dario Solera wrote:
I'm not sure it's legal
Does it really matter since you're not a .NET programmer until you start browsing other people's code with it :rolleyes: It can provide some very useful *cough* tips.
I have no idea what I just said. But my intentions were sincere.
-
I created an ASP.NET application just to test it. I successfully create the data file, and when I try to create the tables (from code) I get this nice error:
SQL Server Compact Edition is not intended for ASP.NET development.Very annoying. :suss:________________________________________________ Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 2.0 (2.0 Beta is out)
The big question I have is why would you want to, since SQL Server Express works fine? Is it just to make deploying an ASP.NET to a remote location easier?
Rocky <>< Latest Code Blog Post: SQL Server Express Warnings & Tips Latest Tech Blog Post: Microsoft doing it again!