.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server Compact Edition with Multiple connexion - SQL Server Express without install...

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server


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?

View Complete Post

More Related Resource Links

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

Which SQL Server 2005 Express Edition Service Pack to Install?

I have Windows 2008 Small Business Server Standard Edition.  When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number.  I'm wondering which I should install, or if both, what order to install them in?  The first one is labeled: Microsoft SQL Server 2005 Express Edition Service Pack 3 The second one is labeled: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine.  The new upgrade for this software requires SP3 which is why I need to know which service pack to install.  Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition.  I know sometimes registry settings need to be changed for SQL service packs to be installed properly. Thank you for your help.  

Uable to successfully install SQL Server 2005 (Express Edition) Service Pack 3 (KB955706)

After repeated attempts, I am unable to install the MSSQL Server 2005 (Express Edition) Service Pack 3 (KB955706).  From Live Update, the installation initializes but then reports that it was unable to install.  The first couple of times I received Error Code 0x65B, but that doesn't come up any longer. I have ACT! Database version 2007 (9.0) and it is unable to access the database to open it because it uses the MSSQL??  Also, there used to be an MSSQL icon below in my system tray, but that no longer appears.  When I reboot it will be on briefly, but then goes away.. MS Customer Support has attempted to help (Case ID SRX1135612820) but now tell me that this is beyond their expertise.  They had me try to reload MMSQL 2005 but no change. Please help! Thanks!!  Terry

Can't install SQL Server 2008 R2 Express Edition x64 from Command Line


I can't get R2 Express (x64) installed from the command line... x86 using this same command line works fine, just x64 is broken.

Using this:


Everytime it fails with:

2010-09-19 15:30:48 SQLEngine: : Checking Engine checkpoint 'ConfigureServiceBroker'
2010-09-19 15:30:48 Slp: --SafeSqlCommand: ALTER DATABASE tempdb SET NEW_BROKER ALTER DATABASE msdb SET NEW_BROKER
2010-09-19 15:30:48 Slp: Sco: SqlException: Message:The operating system returned error 38(Reached the end of the file.) to SQL Server during a read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Template Data\MSDBData.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Onlin

Cannot Install SQL Server Management Studio after removing Express edition


I'm trying to upgrade my management studio to the full version, I uninstalled Express edition and started the install for the full version, but I get an error stating "you cannot install this component because it is already installed". I had a word with one of the guys in the office and he said the only way he's ever been able to get round this is by flattening the entire PC and starting again. Obviously I want to avoid that!

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) windows update install error 0xD

I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500

Can I install SQL Server 2005 Express edition on Linux system?



  I have a requirement to use free source database so i have choosen Sql server 2005 express edition which is available for free.Now can I install this on a linux platform and use it as a server.Does it require any tools or drivers to install on linux and to work as if on windows pc?

Can anyone please help me on this? Any help is much appreciated.

Thanks in advance


Problem with "Error 0xD59 when trying to install the Microsoft SQL Server Express edition Service Pa

Hi Folks,

I've been jumping from site to site trying to find a solution for this and still no luck.  I have tried this update many times but it always fails.  I have the results of the installation log here if it helps.  I am on HP hardware using XP.  Any help is most appreciated.  Thanks for reading!

Time: 11/30/2009 06:25:09.718
KB Number: KB955706
OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 3
Package Version: 4035
Command-line parameters specified:
Cluster Installation: No

Prerequisites Check & Status
SQLSupport: Passed

Products Detected                         Language  Level  Patch Level       Platform  Edition
Express Database Services (MSSMLBIZ)      ENU       SP2    2005.090.3042.00  x86       EXPRESS

Products Disqualified & Reason

Unable to Install SQL Server 2005 Express Edition on Windows 7



 i am trying to install SQL Server 2005 Express Edition on Windows 7. it requires to install Windows installer also. While installing Windows Installer it gives me error that " Do not have enough storage Space in Disk", however i have 150 GB free space in HD.

Please help.. Thanks in advance

SQL Server 2005 Express Edition sp3 won't install?


I try to install SQL Server 2005 Express Edition many times and it never seems to work for me.  Windows update is also trying to install it as well and after all of my other updates install, it says "unable to install the following updates: SQL Server 2005 Express Edition sp3. 

Anyway, I wrote down a couple things that happen when it is installing and what it says when it actually stops installing like what part is it actually installing at that time and it is or it says:

Configuring Microsoft SQL Server :                                                                                         Starting SQL Service: MSSQL$SQLEXPRESS

After it says that, it stops with some error.  Nothing specific just trying to tell me to look at the online books and /or learn how to install it manually which I have looked for in many places and can't seem to find it.  I know there is a log that I c

Unable to install Microsoft SQL Server 2005 Express Edition SP4 (KB2463332)


I've viewed similar post but was unable to install successfully. Am I doing something wrong? Need guidance - Here's my Hot Fix Log:

04/07/2011 10:27:02.984 ================================================================================
04/07/2011 10:27:03.015 Hotfix package launched
04/07/2011 10:27:03.218 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/07/2011 10:27:03.250 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
04/07/2011 10:27:03.265 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/07/2011 10:27:03.265 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
04/07/2011 10:27:03.281 Local Computer:
04/07/2011 10:27:03.296 Target Details: HP30514185767
04/07/2011 10:27:03.296   commonfilesdir = C:\Program Files\Common Files
04/07/2011 10:27:03.296   lcidsupportdir = c:\2dcc7f6a5dd7eca91424323c456c\1033
04/07/2011 10:27:03.296   programfilesdir = C:\Program Files
04/07/2011 10:27:03.296   programfilesdir_wow = C:\Program Files
04/07/2011 10:27:03.296   supportdir = c:\2dcc7f6a5dd7eca91424323c456c
04/07/2011 10:27:03.312   supportdirlocal = c:\2dcc7f6a5dd

Unable to install Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332)


I am not a techie but have been unable to install the update above.  I don't know how to look at registry keys, etc.  Is there an easy fix to this problem?  Does it really matter if this update is installed?

Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332) wont install


I know this problem has been encountred by many others, but I have not seen a solution yet.  There must be a simple way to fix it. If not I will stick with Apple.

Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332) wont install

1. I have tried the installation mutiple times with the same result.

2. I have tried a manual installation that also failed.

3. I have a windows XP with all the latest updates except this one.

4. If you have a solution please give detailed infomation on the fix so I can follow a known procedure to fix the problem.


Unable to install SQL Server 2005 Express Edition with Advanced Services Service Pack 4 (KB2463332)



Rookie here. Using SQL for an eBay software program we have been running for two years. There were simple step by step instructions to install -- point being, I really dont understand this stuff.

Running Windows XP SP3.

Automatic Updates is trying to install the version shown in the Title of this message. It fails to install and gives me the error: SQL BPA command line has encountered a problem and needs to close.

I do not know where to access the error log. I will post if someone can tell me the correct one to find. In the following directory, C:\Program Files\Microsoft SQL Server\, there are directories for MSSQL.1, MSSQL.2 and MSSQL.3. Two of them show log directories with today's date.

Any and all help is very much appreciated.

Thank you!

Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332) will not install no matter what


This is what I've been trying to install: Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332) for three days now. I have followed directions from the Microsoft web site and from the few who responded - nothing has worked. The last question I received yesterday was a response from asked if this is what I had: http://www.microsoft.com/sqlserver/2005/en/us/express.aspx

However, I'm not sure; therefore, I am listing what I do have. I don't know if anything listed below connects to that web address or not or even where to go to find it.

What I have on the computer is: Microsoft SQL Server 2005, Microsoft SQL Server 2005 Compact Edition (ENU) ,Microsoft SQL Server Native Client, Microsoft SQL Server Set Up Support Files (English),Microsoft SQL Server VSS Writer. Therefore, I am wondering that since I don't downloaded any other Service Pack is why this one refuses to install. Thanks for your help and please put responses in plain English - not a computer wiz.

Microsoft SQL Server 2005 Express Edition Service Pack 4 (KB2463332) will not install for me either



I've tried to update sever times and it keeps telling me it cant be installed. I'm running

OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 3 Build 2600


my latest hotfix log reads thus...

03/31/2011 14:11:33.531 ================================================================================
03/31/2011 14:11:33.562 Hotfix package launched
03/31/2011 14:11:33.593 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/31/2011 14:11:33.609 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
03/31/2011 14:11:33.624 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
03/31/2011 14:11:33.640 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
03/31/2011 14:11:33.656 Local Computer:
03/31/2011 14:11:33.671 Target Details: FD-01
03/31/2011 14:11:33.687   commonfilesdir = C:\Program Files\Common Files
03/31/2011 14:11:33.702   lcidsupportdir = c:\e62dcfdf07a6903cc47b2c16404718\1033
03/31/2011 14:11:33.734   programfilesdir = C:\Program Files
03/31/2011 14:11:33.749   programfilesdir_wow = C:\Program Files
03/31/2011 14:11:33.765  

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend