I am trying to write a short application within which I would like to embed a SQL Server Express database, all of which would be deployed via ClickOnce through a web site. The installation process seems to be working without trouble, including installation of the .NET Framework 2.0 and SQL Server Express 2005.
When the application launches on the new machine, however, I get a big Microsoft .NET Framework "Unhandled exception" error dialog box that indicates the database already exists and that the database file could not be attached. I am working with a clean virtual machine that I know has never had the database installed on it.
I fear I am overlooking something quite straightforward, but since this is the first time I have ever attempted to build a data-bound application, I am not sure where I am going wrong.
Perhaps the source of the problem, or a related problem, might be revealed even when I run the application in debug mode from within Visual Studio. I can run the application once, but if I try to run it again, I get an error when I try to open the database connection that is similar in content (database already exists...could not attach). I can run the SSEUtil and detach the database and then run the application again in debug mode and it works no problem (the first time!).
Lastly, if I install the application on the machine on which it was developed and make sure the database is detached, it will run without any trouble (even repeatedly). But, on a new blank machine, there is no database listed that matches my database name, so I cannot try to detach anything!?
I can not completely understand how to deploy sse with my application
To some degree I understand the explaning in Mikes Documentation
Things I don't get:
1)Do I not check the prerequisite server express because when I did and run the setup.exe that I build the thing that happens is that the sql package gets unpacked over and over along with a little message that it's taking a little longer then expected. I gues this is the fallpit where the actual setup.exe for sse is nothing being done with hence the wrapper.
A quote from Mikes document "If the VS Bootstrapper isn't flexible enough for you then". Well, I don't know what I'am doing wrong but it doesn't work at all. I had no problem with the other prerequisites (Framework, installer)
Back to the first question: if so do I manually add the SQLEXP.EXE (downloaded from the internet) or is it the sqlexpr32.exe in the same folder as the setup.exe for the application?
2) How is the wrapper invoked? I don't see that mentioned. I thought when you start the application itself, but that hardly seems logical.
Please anyone, give me some clear directions or additional expanatory
While making a connection to a SQL server Enterprise Database using ASP.Net(C#), during execution of .aspx file i got the following error :-
Kindly help me if anybody knows the solution .
Thanks in advance
Login failed for user 'IT-CELLIWAM_IT-SERVER'. 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.Data.SqlClient.SqlException: Login failed for user 'IT-CELLIWAM_IT-SERVER'.
Source Error:
Line 52: //mycommand.SelectCommand.CommandType=CommandType.StoredProcedure; Line 53: DataSet ds=new DataSet(); Line 54: mycommand.Fill(ds); Line 55: DataTable dt; Line 56: dt=new DataTable();
Hi all,Since yesterday I'm unable to lauch the enterprise manager, it givesthe following error :Unhandled exception at 0x0101f07e in mmc.exe: 0xC0000005: Accessviolation reading location 0x00000064.The weird thing is that except installing the office xp PIA's I can'timage what else could be changed on my system.I tried reinstalling, but still the same error.I tried SP3a, still nothing changed.Searched in some groups and it seems that not much can be found aboutit, so my inspiration is running dry.Anyone had this problem ? Anyone any suggestions how to solve it ?Regards,Koen
Hi,I have installed SQL 2005 RTM on a new server and I keep getting thiserror (described below) quite frequently. Was wondering if anyone has aclue on what's happening here. I tried googling but no success!This generally happens when I am browsing the tree in Object explorerin SQL 2005 Management Studio. I can be doing anything - like viewingdatabases, or viewing table list or viewing stored procedure list, etc.I get the following error (screenshot in URL link)http://img5.imageshack.us/img5/6274/sql2005error3vt.jpgWhen this happens and I click Continue, I can work in Management Studiolike queries, etc. - the summary window appears blank though. It doeshowever refresh the count of items in the list but the main windowdisplays no table list or view list or sp list (whatever the case maybe). Screen shot link:http://img5.imageshack.us/img5/6076...05error21yu.jpgAny ideas???Thanks in advance for all your help!VishalText if message when I click on the Details Button:See the end of this message for details on invokingjust-in-time (JIT) debugging instead of this dialog box.************** Exception Text **************System.ArgumentOutOfRangeException: InvalidArgument=Value of '5' is notvalid for 'index'.Parameter name: indexatSystem.Windows.Forms.ListView.ListViewItemCollecti on.get_Item(Int32index)at System.Windows.Forms.ListView.set_VirtualListSize( Int32 value)atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.set_VirtualListSize (Int32value)atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.PopulateView()atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneListViewer.Microsoft.SqlServer .Management.UI.VSIntegration.AppIDPackage.IReportV iew.SetReportSource(ReportSourcereportSource)atMicrosoft.SqlServer.Management.UI.VSIntegration.Ap pIDPackage.RightPaneControl.InternalSetReportSourc e(ReportSourcereportSource, IReportView newView)************** Loaded Assemblies **************mscorlibAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll----------------------------------------AppIDPackageAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL----------------------------------------SystemAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll----------------------------------------Microsoft.SqlServer.SqlTools.VSIntegrationAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL----------------------------------------Microsoft.VisualStudio.Shell.InteropAssembly Version: 7.1.40304.0Win32 Version: 7.0.4054CodeBase:file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll----------------------------------------Microsoft.VisualStudio.OLE.InteropAssembly Version: 7.1.40304.0Win32 Version: 7.0.4054CodeBase:file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll----------------------------------------System.Windows.FormsAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll----------------------------------------System.DrawingAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll----------------------------------------Microsoft.SqlServer.SqlTDiagMAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll----------------------------------------Microsoft.DataWarehouse.SQMAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL----------------------------------------Microsoft.SqlServer.InstapiAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll----------------------------------------ObjectExplorerAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL----------------------------------------ConnectionDlgAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL----------------------------------------SqlWorkbench.InterfacesAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL----------------------------------------Microsoft.SqlServer.CustomControlsAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll----------------------------------------AccessibilityAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll----------------------------------------SqlMgmtAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL----------------------------------------Microsoft.SqlServer.RegSvrEnumAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll----------------------------------------EnvDTEAssembly Version: 8.0.0.0Win32 Version: 8.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll----------------------------------------Microsoft.NetEnterpriseServers.ExceptionMessageBox Assembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox /9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox .dll----------------------------------------System.DataAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll----------------------------------------Microsoft.SqlServer.ConnectionInfoAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll----------------------------------------System.XmlAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll----------------------------------------Microsoft.SqlServer.SmoEnumAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SmoEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SmoEnum.dll----------------------------------------System.ConfigurationAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll----------------------------------------System.TransactionsAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll----------------------------------------System.EnterpriseServicesAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll----------------------------------------Microsoft.SqlServer.SmoAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Smo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Smo.dll----------------------------------------Microsoft.SqlServer.SqlEnumAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlEnum.dll----------------------------------------Microsoft.SqlServer.BatchParserAssembly Version: 9.0.242.0Win32 Version: 2005.090.1399.00CodeBase:file:///C:/WINDOWS/assembly/GAC_32/Microsoft.SqlServer.BatchParser/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.BatchParser.dll----------------------------------------msvcm80Assembly Version: 8.0.50608.0Win32 Version: 8.00.50727.42CodeBase:file:///C:/WINDOWS/WinSxS/x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727. 42_x-ww_0de06acd/msvcm80.dll----------------------------------------ObjectExplorerReplicationAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorerReplication.DLL----------------------------------------Microsoft.ReportViewer.WinFormsAssembly Version: 8.0.0.0Win32 Version: 8.0.50727.42CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.ReportViewer.WinForms/8.0.0.0__b03f5f7f11d50a3a/Microsoft.ReportViewer.WinForms.dll----------------------------------------System.ManagementAssembly Version: 2.0.0.0Win32 Version: 2.0.50727.42 (RTM.050727-4200)CodeBase:file:///C:/WINDOWS/assembly/GAC_MSIL/System.Management/2.0.0.0__b03f5f7f11d50a3a/System.Management.dll----------------------------------------SQLEditorsAssembly Version: 9.0.242.0Win32 Version: 9.00.1399.00CodeBase:file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SQLEditors.DLL----------------------------------------Microsoft.VisualStudio.TextManager.InteropAssembly Version: 7.1.40304.0Win32 Version: 7.0.4054CodeBase:file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.TextManager.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.TextManager.Interop.dll----------------------------------------************** JIT Debugging **************To enable just-in-time (JIT) debugging, the .config file for thisapplication or computer (machine.config) must have thejitDebugging value set in the system.windows.forms section.The application must also be compiled with debuggingenabled.For example:<configuration><system.windows.forms jitDebugging="true" /></configuration>When JIT debugging is enabled, any unhandled exceptionwill be sent to the JIT debugger registered on the computerrather than be handled by this dialog box.
After patching SQL2005 SP2, an unhandled exception occurred in RSConfigTool.exe.
The error message:
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.
Not found.
Is this a known issue? Thanks.
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text ************** System.Management.ManagementException: Not found at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.PropertyData.RefreshPropertyInfo() at System.Management.PropertyDataCollection.get_Item(String propertyName) at System.Management.ManagementBaseObject.GetPropertyValue(String propertyName) at System.Management.ManagementBaseObject.get_Item(String propertyName) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.get_IsSharePointIntegrated() at ReportServicesConfigUI.ConfigurationManager.ResetStepStatus() at ReportServicesConfigUI.ConfigurationManager.ChangeMachine() at ReportServicesConfigUI.ConfigurationManager.LaunchDialog() at ReportServicesConfigUI.ConfigurationManager.tsbConnect_Click(Object sender, EventArgs e) at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled.
When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
Process information: Process ID: 2096 Process name: w3wp.exe Account name: NT AUTHORITYNETWORK SERVICE
Exception information: Exception type: ReportServerException Exception message: Execution 'aogqmz45z4at1q3oui2elc55' cannot be found (rsExecutionNotFound)
Request information: Request URL: http://ViewReports/Reports/Reserved.ReportViewerWebControl.axd?ReportSession=aogqmz45z4at1q3oui2elc55&ControlID=1ff944bddbce45f9860fdf44300bf3bf&Culture=1033&UICulture=9&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodctl141TouchSession0&CacheSeed=Fri Mar 28 01:39:34 2008 Request path: /Reports/Reserved.ReportViewerWebControl.axd User host address: 172.19.97.233 User: Valid User Is authenticated: True Authentication Type: Negotiate Thread account name: NT AUTHORITYNETWORK SERVICE
Thread information: Thread ID: 15 Thread account name: NT AUTHORITYNETWORK SERVICE Is impersonating: True Stack trace: at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) at Microsoft.Reporting.WebForms.ReportDataOperation..ctor() at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType) at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
This could be a simple C++ issue as I am not that familiar with the language. I am trying to prototype a small program to test the performance of inserting data using the BCP interface. I want to BCP data that my program generates and passes via program variables.
I have narrowed the issue down to a sprintf call. Following are two variations of the code - one that works and one that does not. The error happens when I try to execute the bcp_sendrow() call.
What is the appropriate way to create / send string data to the BCP interface. Any good examples available? I have created the following from the BulkCopyFromVariables example on the Microsoft SQL Server downloads site.
I have a Select statement that was working just fine: string sSqlCmd = "INSERT INTO SiloKeywords (Silo_ID, Keyword, UserName) SELECT Silo_ID,'" + Keyword + "', '" + strUsername + "' FROM SiloNames WHERE Silo_Name = '" + Uri + "'"; the PM now wants to capture the internal User, which I have done but I am having real problems with the syntax if the internal User exists:
string sSqlCmd = "INSERT INTO SiloKeywords (Silo_ID, Keyword, UserName, IsInternal) SELECT Silo_ID,'" + Keyword + "', '" + strUserName + "', if EXISTS(SELECT * FROM InternalUsersList WHERE Alias = '" + arrResult[1] + "') 1 ELSE 0 FROM SiloNames WHERE Silo_Name = '" + Uri + "'"; I am completely lost here.
I was wondering if anyone had tried to embed sql server express in a .net application. Specifically, I want to use it from within the app only, similar to embedded mysql (libmysqld) or firebird. I've seen some articles on sql server express saying this can be done, however there is no info on how do to this. Anyone know how it might be done?
I have an application being developed in VS 2005 using SQL Express. I've built up some new roles and have several users pre-populated that I'd like to deploy to a shared hosting evironment. The problem is that I seem to keep getting: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists. Choose a different database name.Cannot attach the file 'd:hostingmember 2agilitysite1App_DataASPNETDB.MDF' as database 'ASPNETDB'. I saw another post with a similar issue, but that resolution has not seemed to help. Can anybody give me insights as to where the "asanga" is coming from? That might help me diagnose the issue. Thanks in advance
I have developed a database in Visual Studio 2005 (c#) ,using SQL Express as my database, on my local machine and deployed it to a different machine where it is being used in a live environment. No problems.
However, I have continued developing the application on my local machine and have made numerous additions to the structure of the database (on the development machine).
My question...How do I go about deploying the new database structure to the live machine without losing the live data?
(String.Format("{0} Rows have been copied.", e.RowsCopied.ToString()));
}
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////// I executed the above project in my local PC (with Adiministrator previlidge/use) that is in our LAN/Network system and I got an error: SecurityException was unhandled - Request for permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'failed. First, I have a question: is this problem related to the remote connection to SQLEXPRESS? Second, I do not know how to solve this problem. Please help and answer my first question and tell me how to solve this problem.
I want to create deployment for MS SQL 2005 Express database, that creates database, tables and inserts data. I have made a similar with VisualStudio 2003 and MSDN
I starting getting the error above today when attempting to deploy updated DSV's and Report models. I can't seem to locate any info about this error - seems like a generic one. We're on 2005 SP1 (think we're on build 2221). Any help is appreciated!
Hello,I am currently creating a web app that I am creating using the Visual Web Developer Express IDE to create. I was planning on using a SQL Server Express database for the database backend. My problem is this...The web server i will deploying the app too does not have SQL Server, or Server Exress installed...can I still use the Server Express Database? Excuse my ignorance on this subject as I have is the passed used MS Access databases (my employer has never wanted to shell out the $$$ for SQL Server on our web server). Thanks in Advance for your help.-Dan
I am currently deploying my website. I cannot establish a link with the SQL sever express database. I followed the instructions of my web host (covered in this thread): http://forums.asp.net/thread/1698700.aspx and finally I received the currently unresolved error: "An attempt to attach an auto-named database for file d:hostingmembersharpeeuksite1App_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." I told my webhost I have followed their instructions and they came back with the answer: "I would suggest you to upgrade the db's to use mssql 2005. This is because, sql express is built for development environment. When you are in development environment, you are accessing everything with administrator permission. However, in live hosting environment (when there are differnet kind of permission restrictions), sql express often failed on attaching database. Any kind of change to the database would require re-attaching database. Personally, I do not feel sql express is ready for the live hosting environment. We can try to fix the attaching problem for you, however, even if we do it for free for you, you might encounter attaching db problem the next time you make any kind of update to the database schema. " Is this correct? Is SQL server Express really unsuitable for deployment? I am using webhost4life.com - Does someone know a webhost that can host SQL server Express reliably? (that would seem a lot cheaper than upgrading to mssql 2005) Thanks for any advice
This is probably a dumb question. But if I embed a SQL Server Express database into my project and then attempt to deploy it via ClickOnce, will I be able to access that database using the SQL Server Management Studio Express CTP if it is installed on the same machine as the client that my app would be installed?
Hi- I am trying to use the same SQL Server 2005 express DB with two different project. I am using the Data Source=.SQLEXPRESS;AttachDbFilename syntax in the connection string. The first project can attach and connect just fine. The second project is a windows service that uses the same connection string. The windows service cannot connect to the DB though. It looks like it is trying to attach the DB again even though it is already attached. Shouldn't it only try to attach it if it isn't already attached? Here is the error: System.Data.SqlClient.SqlException: CREATE DATABASE permission denied in database 'master'.Cannot attach the file 'C:path' as database 'dbname'.
C:Program FilesMicrosoft BizTalk Server 2006Tracking>bm.exe deploy-all -Defin itionFile:testtype.bam.xml Microsoft (R) Business Activity Monitoring Utility Version 3.5.1602.0 Copyright (C) 2006 Microsoft Corporation. All rights reserved.
Using 'BAMPrimaryImport' BAM Primary Import database on server 'MOHSASLPT13719S QLEXPRESS'...
Deploying Activity... ERROR: The BAM deployment failed. The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Clien t unable to establish connection). The SQL statement issued has failed.
The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Clien t unable to establish connection). The SQL statement issued has failed.
I've developed a desktop application for a company. It uses click once deployment and has a few prereqs: .NET Framework 2.0, j# .NET redistributable, windows installer 3.1 and SQL Server 2005 express edition.
Most of the time the application downloads and installs fine. However, one user has a problem. I'm fairly certain it's machine / OS related and I wonder if there is a way to get around it.
The user has a Windows 2000 machine, Pentium III, with 512 MB of RAM.
On their first try, they received an error while installing SQL Server 2005 Express. The error code the user found in the install log was 70095. Apparently the user found some information directing them to install the current MDAC 2.8 SP 1. After rebooting and trying the install again, it errored out. The new error code is 1706. Below is the install log.
As I said, I'm faily certain it's an OS issue, but I do hope there is a way around the issue other than trying to get the user to upgrade. If you need any other information, please let me know and I'll try to get it from the user.
Thanks,
AaronThe following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.0.4 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpDotNetFXdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLMSoftwareMicrosoftInternet Explorer' Read string value '6.0.2800.1106' Setting value '6.0.2800.1106 {string}' for property 'IEVersion' The following properties have been set for package '.NET Framework 2.0': Property: [DotNetInstalled] = 1 {int} Property: [IEVersion] = 6.0.2800.1106 {string} Running checks for command 'DotNetFXinstmsia.exe' Result of running operator 'ValueExists' on property 'VersionNT': true Result of checks for command 'DotNetFXinstmsia.exe' is 'Bypass' Running checks for command 'DotNetFXWindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true Result of checks for command 'DotNetFXWindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' Running checks for command 'DotNetFXdotnetfx.exe' Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true Result of checks for command 'DotNetFXdotnetfx.exe' is 'Bypass' '.NET Framework 2.0' RunCheck result: No Install Needed Running checks for package 'Microsoft Visual J# .NET Redistributable Package 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPvjsrdpchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'VJSRDPInstalled' Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' The following properties have been set for package 'Microsoft Visual J# .NET Redistributable Package 2.0': Property: [DotNetInstalled] = 1 {int} Property: [VJSRDPInstalled] = 1 {int} Running checks for command 'VJSharpRDPvjredist.exe' Result of running operator 'ValueNotEqualTo' on property 'VJSRDPInstalled' and value '0': true Result of checks for command 'VJSharpRDPvjredist.exe' is 'Bypass' 'Microsoft Visual J# .NET Redistributable Package 2.0' RunCheck result: No Install Needed Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Running checks for package 'SQL Server 2005 Express Edition', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpressSqlExpressChk.exe" Process exited with code 1 Setting value '1 {int}' for property 'SQLExpressInstalled' The following properties have been set for package 'SQL Server 2005 Express Edition': Property: [SQLExpressInstalled] = 1 {int} Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install' Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': true Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass' 'SQL Server 2005 Express Edition' RunCheck result: Install Needed EULA for components 'SQL Server 2005 Express Edition' was accepted. Copying files to temporary directory "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" Downloading files to "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" (12/14/2006 11:16:32 PM) Downloading 'SqlExpresssqlexpr32.exe' from 'http://go.microsoft.com/fwlink/?LinkId=37280&clcid=0x409' to 'C:DOCUME~1craigpLOCALS~1TempVSD8.tmp' Download completed at 12/14/2006 11:17:02 PM Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpressSqlExpressChk.exe" Process exited with code 1 Setting value '1 {int}' for property 'SQLExpressInstalled' The following properties have been set for package 'SQL Server 2005 Express Edition': Property: [SQLExpressInstalled] = 1 {int} Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install' 'SQL Server 2005 Express Edition' RunCheck result: Install Needed Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Installing using command line '"C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1' Process exited with code 1706 Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
i have restored site using stsadm, site get successfully restored. all user of the site able to access the site but the unable to access from same machine on which it is restored. i got the error The file exists. (Exception from HRESULT: 0x80070050)
I have problem after deployig the setup project. when I install it on other computer it show error that an error has occur whil establishing connection to server. plz tell me how can I deploye a project and how can I handle this problem..
hi... i am new to ASP2.0 and i was trying to use the properties associated with the profile class. here what i was trying to do... in "Web.config" <anonymousIdentification enabled="true"/> <profile enabled ="true"> <properties> <add name="p1" allowAnonymous ="true"/> </properties> </profile> in "Default.aspx.cs" protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { Profile.p1 = "Welcome"; LabelResult.Text = Profile.p1; } else{ Profile.p1 = "you'v been here"; LabelResult.Text = Profile.p1; } } but i had the exception ( Unable to connect to SQL Server database) at "App_Code.qzomymsu.0.cs" public virtual string p1 { get { return ((string)(this.GetPropertyValue("p1"))); } set { this.SetPropertyValue("p1", value); } } i know the problem has something to do with providers, and i want to store the values to an XML file.... thank you for helping.
I need to do some processing but only if a specific table 'table1' exists in the SQL Server database. How can I check if this 'table1' exists using either ADO.Net code or SQL Server query?
ISSUE: While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception: Error During Synchronization: A native exception occurred. ExceptionCode:0xc0000005 ExceptionAddress:0x01627b28 Reading: 0x1e000000 OK to terminate CANCEL to debug Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful. Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.
I want to know through applicaiton how to check whether the Server named"Myserver" is Exists with Database named "MyDatabase" with Tables named ('Table1','Table2','Table3').
For any Database like (MS Access, Oracle, MS SQL-Server,MySQL)..
Hello, Im doing research for my company for a project we are about to start, but the more I find, the more Im confusing myself. Maybe someone would be so nice to help me a little.
We need a database solution, either licensing (ISV) or i think maybe an embedded database. if its licensing, its not a problem, but after research, im thinking licensing would be a waste of time or too much and theire not enough information to go by just that.
Problem: Need to develop software for a client where there will be around 300 users using the system (not all at once neccisarrily). We are creating this software for them and they want to re-sell it after completion, but they do not want to make their customers purchase a database for the purchase of their software. (because of all types of licensing). We need the database RUNTIME to run on the customers machine to make the software work.
Is there a RUNTIME license for Independant-Software-Vendor(IVS) for redistribution? or would it make sense to embed a database ( for example, the free edition of sql server;embeeded feature :), or maybe firebird embedded database?) We are developing in Visual Studio 2005.
This might sound confusing, thats where im at. For those of you with more experience, hopefully you understand what im talking about.
Thank you. I have 2 days to find a solution. Ill continue looking and post in thread if i find anything new or clearify my problem.
I inherited an existing database application about 6 months ago. I'vefinished converting it to use SQL Server 2000 as the backend (MS Access2002 frontend w/ Userforms+VBA code pointing to the backend).In its current state the application makes use of a ton of embedded SQLstatements and I'm thinking about the best way to clean this up. Itseems like the best way would probably to encapsulate each of the SQLstatements into its own stored proc and then have the MS Accessapplication call the sp. However, this would result in a very largenumber of stored procedures.Anyone have any links or suggestions regarding best practices onremoving embedded SQL scattered throughout a DB app? Thanks.
Is it possible to deploy SQL Server CE "baked into" a DLL? For example, instead of setting the build option to "Content", can I set it to "Embedded Resource"?
