Question About SQL Server Express And Visual Studio 2008
Feb 12, 2008
I already have SQL Server Express 2005 installed from having Visual Studio 2005 installed. How can I tell if it is the SP2 edition? It probably isn't, so my next question is what is going to happen when I install Visual Studio 2008, which I will be doing in a day or two...will the install overwrite SQL Server Express 2005 with the latest edition to SP2, assuming that the latest edition will be on the Visual Studio 2008 installation discs? I have not yet used SQL Server Express, so my knowledge level with it is very weak. What I'm hoping to find out with this question is what I'll have (with respect to SQL Server Express) and the install of Visual Studio 2008. I can't even figure out how to tell what version of SQL Server Express that I now have.
View 9 Replies
ADVERTISEMENT
May 5, 2008
in visual studio web developer express edition 2008 i added a new item this was a sql server database which i called test2. I added a table called comments, and the fields name, email, comments, IPAddress, and Date and in my comments.aspx page i added a name textbox, a texbox for email, a textbox for comments and the submit button i double clicked on the submit button and added the following code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mydS As New SqlDataSource mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString1").ToString mydS.InsertCommandType = SqlDataSourceCommandType.Text mydS.InsertCommand = "INSERT INTO comments(Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)" mydS.InsertParameters.Add("Name", TextBox1.Text) mydS.InsertParameters.Add("Email", TextBox2.Text) mydS.InsertParameters.Add("Comments", TextBox3.Text) mydS.InsertParameters.Add("Date", Date.Now) mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR")) Dim rowsaffected As Int16 = 0 Try rowsaffected = mydS.Insert Catch ex As Exception Server.Transfer("errors.aspx") Finally mydS = Nothing End Try If rowsaffected <> 1 Then Server.Transfer("errors.aspx") Else Server.Transfer("confirm.aspx") End If End Sub Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged End Sub but when i run it it gives me a problem with this line mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString2).ToString and says something abt unidentified object and I want to know how do i set the connection string or alternatively where?????? and my table does not update with the corresponding values i enter on the webpage. i also changed the authentication mode to forms instead of windows as i was advised but i'm still having a problem
View 12 Replies
View Related
Jan 16, 2008
I installed both SQL 2005 developer and SQL Server 2005 Express Edition with Advanced Services SP2 and Microsoft SQL Server 2005 Express Edition Toolkit.
In every version "SQL Server Business Intelligence Development Studio" was missing. I uninstalled and reinstalled both version but always "SQL Server Business Intelligence Development Studio" was not available and the computer could not find devenv.exe file.
I installed visual studio 2008 as well. For some reason the start menu link for "SQL Server Business Intelligence Development Studio" is ""C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe"" and devenv.exe is not there or anywhere
Pleas advise.
View 4 Replies
View Related
Feb 22, 2008
(1) I have already installed of SQL Server 2005 Developer Edition first.
(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?
(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?
View 3 Replies
View Related
Mar 17, 2007
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
View 1 Replies
View Related
Feb 8, 2008
I am thinking about installing dvd microsoft office ultimate 2007 visio
before I install sql server 2005 sp2. I already have visual studio 2008
rtm pro professional vl on my vista computer. Will I have any issues
doing this? Thank you
View 6 Replies
View Related
Apr 16, 2007
When I downloaded/started using Visual Web Developer I was under the impression that I needed to install SQL Server Management Studio Express in order to create/manage databases, and to provide the engine to access the data.
Since then I have found tutorials and have successfully created/used databases solely from within Visual Web Developer. I'm assuming that Visual Web Developer includes a database engine, much like the webserver that is included. (This is an awesome thing).
When I tried to upload my web application with database to my production server, the database would not work, it started working after I installed SQL Server Management Studio Express on the server.
Is it my understanding that you need SQL Server Management Studio Express if you do not have Visual Web Developer Express installed in order to provide the data access engine?
Also, I am unable to "attach" my Visual Web Developer Express created database to SQL Server Management Studio Express. Are there any posts that provide more information about this topic?
The only reason I'm asking is that I have extra whitespace on the end of my text fields, and I thought ANSI_PADDING was turned on. I do not see the option in Visual Web Developer Express, but have found it in SQL Server Management Studio Express.
View 14 Replies
View Related
Mar 3, 2008
My home machine has sql 2005 and Visual Studio 2005 installed. I uninstalled VS 2005 (RTM) and installed VS 2008 (RTM) in its place. I then found that the SSIS templates were missing. Lesson: don't uninstall VS 2005 if you want to use SSIS 2005!
1. Is there any "workaround" to this issue?
2. (If the answer to 1 is "No") I will install VS 2008 side-by-side with VS 2005 on the same box. When the SSIS issue is finally resolved, can I uninstall VS 2005 without doing damage to the VS 2008 install?
TIA,
Barkingdog
View 17 Replies
View Related
Jan 27, 2006
I have an Excel add-in that connects to a SQL Server Express 2005database. I've decided to create a configuration piece for this add-inin Visual Studio 2005 Express. I added a data connection using the dataconnection wizard and all appeared to go well. Anyways when I attemptto open SQL Server Express to administer the database, it was corruptedand I had to restore it.I eventually got it to work correctly (I'm pretty sure I followedpretty much the same steps as before), but I was just wondering ifanyone had experienced problems like this? I find it a bit scary thatit may be that easy to corrupt the database by just creating a dataconnection.
View 2 Replies
View Related
Aug 26, 2007
I have a question about a problem that I cannot seem to tackle. I have installed the following programs on Windows Vista:
- SQL Server 2005
- Visual Studio 2008
- SQL Server Compact Edition 3.5
- SQL Server Compact Edition 3.5 Server Tools
I want to do the following:
1. I want to create a SQL Server Compact Edition 3.5 database in the SQL Server Management Studio
2. I want my SQL Express server in SQL Server 2005 to be a distributor and publisher
About 1. In SQL Server Management Studio I cannot choose SQL Server Compact Edition 3.5 .
ABout 2. I tried to setup my server to be a distrubutor by running a stored procedure with the following name: sp_adddistributor. I get the following error: This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Does anyone have a solution to both problems.
View 1 Replies
View Related
Dec 23, 2007
when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008
View 1 Replies
View Related
Jan 25, 2006
Can I connect visual studio express to sql server express?
I am sure there is a way, at the moment I can only connect
to tables in Microsoft Access.
Thanks
BJ
View 2 Replies
View Related
Sep 19, 2007
They say that the definition of insanity is doing the same thing again and again while expecting a different outcome.
I must be going insane.
To top it off, the first time I tried to enter this message the post failed.
I installed visual studio 2005 and SQL express in the spring and began working with them. Life was good. I got distracted for several months and when I went back in I saw the 2008 beta 2 versions of VS and VWD. I uninstalled everything and installed the new versions, but kept having problems with missing links in the help files. I am a newbie, so the help files were important to me so I decided to go back to the old versions.
I deleted everything again, used the MSI cleanup utility to make sure everything was deleted and tried to reinstall the 2005 versions. At one point I got SQL server installed, but had to use a different (besides SQLexpress) instance name and was unable to link it with VWD. I have repeatedly uninstalled and reinstalled (maybe a dozen times) while trying various means of deleting file contents and under the programs/apdata and Microsoft SQL directories and in various sequences to no avail. The latest message is below along with the end of the log file.
Does anyone know a good hosting vendor for the visual studio authoring environment? (just half kidding)
Thanks for any help ... bill
Error message ....
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlShutDownRANUInstance%40sqls%3a%3aService%3a%3aStart%40x3
Log file summary .....
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Sep 18 14:29:26 2007
HOMEWXP : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
HOMEWXP : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Machine : HOMEWXP
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Failed
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (3) The system cannot find the path specified.
Error Number : 29503
--------------------------------------------------------------------------------
Machine : HOMEWXP
Product : Microsoft SQL Server Management Studio Express
Product Version : 9.00.3042.00
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SSMSEE_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Tue Sep 18 16:11:03 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_MSXML6_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SQL.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SSMSEE_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_SCC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_HOMEWXP_WI.log
SQL Log
Property(S): SqlFullTextDefaultPath = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): FTERefPath.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): QuotedServiceGroupFTS.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = HOMEWXPSQLServer2005MSFTEUser$HOMEWXP$SQLEXPRESS
Property(S): FTEInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS
Property(S): FTERudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1
Property(S): FTERegRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1MSSearch
Property(S): FTEInstanceSubDir.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1MSSQL
Property(S): FTEStartupTypeBeforeInstall = 3
Property(S): FTEStatusBeforeInstall = 6
Property(S): FTEStartupType = 3
Property(S): FTEStatus = 6
Property(S): InstanceRegKey.7827AB3E_7041_406A_9591_4DB66042927F = Microsoft SQL ServerMSSQL.1
Property(S): InstanceName.7827AB3E_7041_406A_9591_4DB66042927F = SQLEXPRESS
Property(S): SqlVerComFT.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90COM
Property(S): Ver.BB43EC2E_1D73_400F_AE2F_F370407BC222 = c:Program FilesMicrosoft SQL Server90
Property(S): FTESqlInstanceBin.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): FTESqlInstance.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL
Property(S): FTESqlInstanceBinRef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): FTESqlInstanceDotNumber.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1
Property(S): SqlVer.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90
Property(S): FTESharedCompRoot.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server90
Property(S): Sql.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server
Property(S): SqlTarget.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL Server
Property(S): ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program Files
Property(S): CAFTERemovePerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS
Property(S): CAFTEUninstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): CAFTEUpgradeFTERefFiles.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS:c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): CAFTEUpgradeFTERefFilesRollBack.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef
Property(S): CAFTEInstallFTERef.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERef|c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLFTData
Property(S): CAFTEAddCertificate.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn
Property(S): CAFTEInstallPerfCounters.68C6D15C_77E0_11D5_8528_00C04F68155C = c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLEXPRESS
Property(S): CARemoveFTEServiceDependency.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS
Property(S): CASetLaunchPermissions.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}:NT AUTHORITYNetworkService
Property(S): FTERegInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLEXPRESS
Property(S): FTERegRudeInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = MSSQL.1
Property(S): FTEUPGRADE.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgrade30.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): FTEUpgradeMSSearchApp.68C6D15C_77E0_11D5_8528_00C04F68155C = SQLServer$SQLEXPRESS
Property(S): FTEUpgradeMSSearchStandalone.68C6D15C_77E0_11D5_8528_00C04F68155C = 0
Property(S): CostingComplete = 1
Property(S): FTEInstID.68C6D15C_77E0_11D5_8528_00C04F68155C = 1
Property(S): FTEAppID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D318-77E0-11D5-8528-00C04F68155C}
Property(S): FTEAdminCLSID.68C6D15C_77E0_11D5_8528_00C04F68155C = {68C6D37C-77E0-11D5-8528-00C04F68155C}
Property(S): FTEIFTEAdmin.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bd6f-cc0d-11d6-9a15-505054503030}
Property(S): FTEMSFTEPXY.68C6D15C_77E0_11D5_8528_00C04F68155C = {64f6bdd4-cc0d-11d6-9a15-505054503030}
Property(S): FTEDollarInstName.68C6D15C_77E0_11D5_8528_00C04F68155C = $SQLEXPRESS
Property(S): FTEServiceName.68C6D15C_77E0_11D5_8528_00C04F68155C = msftesql$SQLEXPRESS
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryServer = ReportServer$SQLEXPRESS
Property(S): SqlActionManaged = 3
Property(S): SqlNamedInstance = 1
Property(S): SqlStateManaged = 2
Property(S): RSVirtualDirectoryManager = Reports$SQLEXPRESS
Property(S): SOURCEDIR = c:ae2ebb64c8a0ed8236221093549918Setup
Property(S): SourcedirProduct = {B0F9497C-52B4-4686-8E73-74D866BBDF59}
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {278C8A54-0676-4D3F-B85A-BFF2EF53C1CF}
Property(S): ProductToBeRegistered = 1
MSI (s) (44:68) [14:51:03:640]: Note: 1: 1708
MSI (s) (44:68) [14:51:03:640]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (44:68) [14:51:03:671]: Cleaning up uninstalled install packages, if any exist
MSI (s) (44:68) [14:51:03:671]: MainEngineThread is returning 1603
MSI (s) (44:58) [14:51:03:671]: Destroying RemoteAPI object.
MSI (s) (44:A0) [14:51:03:671]: Custom Action Manager thread ending.
=== Logging stopped: 9/18/2007 14:51:03 ===
MSI (c) (2C:00) [14:51:06:593]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (2C:00) [14:51:06:609]: MainEngineThread is returning 1603
=== Verbose logging stopped: 9/18/2007 14:51:06 ===
View 2 Replies
View Related
Apr 14, 2006
I'm attempting to connect to my SQL Server Express instance through Visual Studio 2003. When I go to Data Connections, I choose the Microsoft OLE DB Provider for SQL Server, then fill in all the parameters for my server (server name, username, password, database). When I click "Test Connection" it goes through successfully. When I click "Ok" to create the Data Connection, it fails saying that the username and password should be checked. I changed the username and password to the "sa" account I created when I installed SQL Server Express, and got the same successful connection test, but failure when it tries to create the connection. Any suggestions? Thanks!
View 3 Replies
View Related
Jul 16, 2007
Hi, is it possible to use SQL server express 2005 with visual studio 2003?
i've some problems...
Thanks
View 4 Replies
View Related
Jun 29, 2007
I work for a school district and our business lab is looking at using Visual Studio.net and since MSDE is being replaced by SQL Server Express 2005, will that work with Visual Studio.net for creating applications.
Thanks ahead of time.
View 1 Replies
View Related
Feb 7, 2008
Alright I'm using Visual Studio 2005 with SP1 and SQL Server Express 2005. I've downloaded all the updates on Windows Update. I'm joining a project late and trying to get the C#/SQL web-app up and running. My project manager has it built with Visual Studio 2005 pro and a full blown corporate license for the SQL server, but I don't have access to the SQL server quite yet.
When I try to open the "LLRCWEB.sln" file I receive the following error:
"The application for project 'C:Documents and Settings......LLRCSQL.dbp' is not installed.
Make sure the application for the project type (.dbp) is installed."
Has anyone encountered this problem before? Are there any plug-ins or particular application versions you know are required to handle '.dbp' files, or will I have to Install Visual Studio 2005 Pro and get access to the SQL server?
Any input would be greatly appreciated
View 1 Replies
View Related
Aug 3, 2007
I have been experiencing troubles since I was decided to install SQL Server Expr 2005 in my PC, first I needed to remove the .NET framework 1.1 in my computer because it is suggested before installing sql server expr 2k5 that cause my vs.net 2003 to stop loading because sql express runs in .NET framework 2.0 and vs.net 2003 is in .Net Framework 1.1 then what I did is to install .Net Framework 1.1 in my PC together with .Net Framework 2.0 and my vs.net started runnning again.
My problem now is when I try to connect to a database using Data Link Properties in the Server Explorer it says "[DBNETLIB][ConnectionOpen](Connect()).]Sql server does not exist or access denied." how could this happen if I can see the sql server in the Server Explorer in my VS.net environment?
Please somebody help me I am just learning to this language and I think I cannot proceed to the next few chapters remaining because of this.
Thank you very much!
View 5 Replies
View Related
Sep 10, 2007
I successfully installed .NET framework v 3.5 and VWD 2008 on a new Vista laptop. When I want to add a Sql Server database to a website, errors tell me to install SS 2005 Express. MSDN SS 2005 Express download tells me I MUST first install .NET framework v 2.0 before SS 2005. When I try to install framework v 2.0, I'm sent to v. 3.5 and no way to download SS 2005.
How does one install a express sql server to run with Visual Web Developer 2008?
View 4 Replies
View Related
Sep 17, 2006
Can Visual Studio.net Academic (2002) be used with Sql Server Express 2005?
View 4 Replies
View Related
May 5, 2006
I'm very confused. I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express. Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express?
View 1 Replies
View Related
Mar 3, 2006
We are new to SQL Server 2005 Express Edition. We are going to develope a solution for one of our client and we have to decide on which database to use for the solution. Client wanted to have a low cost solution. Thus we were not in a position to push them for SQL Sever 2000.
In the process, we also thought of having MySQL as one of the option. Another option we have is to use SQL Server 2005 Express Edition.
We wanted to know if SQL Server 2005 Express Edition can be used with Visual Studion 2003 (Ver 1.1) or it can only be used with Visual Studio 2005 (Ver 2.0)?
Hope to get feedback soon.
Regards
Sanjeev
View 1 Replies
View Related
Jan 11, 2006
I was wondering if it is possible to connect the SQL Server 2005 Express Version to Visual Studio 2003.If its possible , how can it be done?Cos i seem to have an error if i do so.
View 4 Replies
View Related
Sep 13, 2006
I have installed Visual Studio 2005 which includes SQL Server Express but not the Management Studio.
Can I install SQL Server Management Studio Express?
View 1 Replies
View Related
May 28, 2008
I would occasionally get the error below when trying to access a database in my project/App_Data folder using Visual Web Developer Express 2008.
I would re-boot and the problem would go away.
I now have the problem all the time and am unable to access my database file in the App_Data folder nor ASPNETDB.mdf.
I am not trying to access a remote database. I have not knowingly changed any settings.
Has anyone seen this problem?
Can anyone help?
Thanks,
Charles Smith
ERROR MESSAGE:
€¦ under the default settings SQL Server doesn't allow remote connections. (provider: SQL Network Interfaces, error 26 €“ Error locating Server/Instance specified)
View 1 Replies
View Related
Jun 15, 2008
This should be simple - using the server explorer I select the server and then the database that's running on that server. It lets me test the database connection at that point - which does work.
Then when I try to add the database it says -
Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0 ... The system cannot find the file specified.
So far as I can see the specified file is Microsoft.SqlServer.Smo.dll which has a current version of 9.0.242.0 and sits within the SQL Server files. That is also the version number held in the registry.
The version of SQL is 2005. The database was created using Create Database through VS 2008, .net 3.5.
Also, I installed VS 2008 first, which puts in SQL Compact. And then tried installing SQL 2005 Development which still gave the same error message. So I uninstalled SQL Compact and SQL 2005. And then did a clean install of SQL 2005 Developer. Does VS 2008 cope with this?
Is there a version 10 of SMO? Or is there somewhere within SQL or Visual Studio where it could be holding a version number of 10 for the dll? Or any other ideas?
Thanks Mike
View 2 Replies
View Related
Sep 1, 2007
I have recently installed Visual Studio 2008 Beta 2 on a development machine that was running SQL Server 2005 SP2a without any issues. Not I find that I can no longer run any of my SSIS packages and I keep getting the following error:
Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154
Per other posts, I have reinstalled MSXML 3.0 to no avail and I have looked for every SQL Server patch I can find - I appear to have all of the latest patches for SQL Server.
Can somebody please help?
View 6 Replies
View Related
Sep 14, 2007
Hi,
I have a desktop application that uses an Access DB.
Now i have converted it to Visual Studio 2008 and tried the SQL CE Edition.
I wrote all the methods, create the database and the tables on the fly and seems to work really fine.
The database is 20MB big, but the performance is vey bad.
I mean with Access it's very fast, you actually don't see how slow it is, and with the SQL CE now,
it takes 7 seconds !!!! for a few access instead of under 1 second with Access.
I can't imagine that this is normal, there must be something i am really missing in my code.
Looks something like this:
Code Snippet
SqlCeEngine engine = new SqlCeEngine("Data Source = URANO.sdf");
engine.CreateDatabase();
engine.Dispose();
// Verbindung öffnen
sqlConnection = new SqlCeConnection("Data Source = URANO.sdf");
sqlConnection.Open();
// creating the tables here with data
sqlCommand = new SqlCeCommand("SELECT ID FROM Laender WHERE Name=@Name", sqlConnection);
sqlCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 30);
sqlCommand.Parameters[0].Value = land;
sqlDataAdapter = new SqlCeDataAdapter(sqlCommand);
sqlDataSet = new DataSet();
sqlDataAdapter.Fill(sqlDataSet, "Laender");
landID = "" + (((int)sqlDataSet.Tables["Laender"].Rows[0][0]) + 1);
this takes 1 - 2 seconds
btw: the whole class is static and the variables also are static.
Would it be better to load all the database tables into datasets, and only work with the datasets in memory ?
Well i thought that the SQL CE Engine, would load the database into memory and be just fast.
I mean we have 2 GB of memory or 1 the most of us, 20MB isn't that much.
Thanks !
Nick
View 9 Replies
View Related
Jan 24, 2008
Can I author report projects in VS Studio 2008 that I deploy to a RS2005 Report Server?
Our development staff has upgraded to VS2008 for our DLLs, Web sites, and console apps... no problem there whatsoever. But we have SQL2005... obviously, since SQL2008 appears to be along way off.
So, it seems like an obvious question... although I'm dreading the response. My experience with getting RS2005 installed and configured correctly was simply horific. In fact, so bad, I'm considering dumping RS altogether and going with a more reliable 3rd party tool... MS has truly done everything in the power to botch this one or so it would seem.
View 1 Replies
View Related
Sep 1, 2007
I installed Visual Studio 2008 Beta 2 Professional yesterday and now none of my SSIS packages will function. Each time I attempt to run the transform, I obtain the folloiwing error:
Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.
I have tried to apply every patch I can find for SQL Server 2005 - inclduing both the SP2 and SP2a patches. I have tried reinstalling MSXML 3.0 - nothing seems to work.
Can somebody please help?
Thank you!
View 5 Replies
View Related
Mar 20, 2008
Dear all,
I am trying to integrate Sql Clr with Visual studio 2005, but i am getting the following error when i try to deploy the solution:
CREATE ASSEMBLY for assembly 'SQLCLRIntegrationDemo' failed because assembly
'SQLCLRIntegrationDemo' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.
The assembly is authorized when either of the following is true: the database owner (DBO)
has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database
property on; or the assembly is signed with a certificate or an asymmetric key that has
a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or
attached this database, make sure the database owner is mapped to the correct login on
this server. If not, use sp_changedbowner to fix the problem. SQLCLRIntegrationDemo
I have even set the Permission to External in the Project --> Properties --> Database tab.
But still i am getting the above solution while deploying the solution.
One of the blogs suggested that the checkbox beside 'Trustworthy Database' should be checked. But i dont see any checkbase in the database tab of the Project properties.
Any help would be appreciated.
Thanks in advance.
Regards,
Sunny.
View 1 Replies
View Related
Dec 5, 2007
I can't open solutions created in Visual Studio 2005 in Visual Studio 2008
---------------------------
Microsoft Visual Studio
---------------------------
'TransformFoxData.dtproj' cannot be opened because its project type (.dtproj) is not supported by this version of Visual Studio.
To open it, please use a version that supports this type of project.
---------------------------
OK Help
---------------------------
Does that mean it is a requirement to have SQL Server 2008 installed ( which I don't want ) to make it work in Visual Studion 2008.
I just uninstalled VS 2005.
View 7 Replies
View Related
Nov 21, 2007
How do I install the report designer in Visual Studio 2008?
Edit: I mean, how do I install the SQLRS 2005 Report Designer in Visual Studio 2008?
View 24 Replies
View Related
