SQL Server :: Using Sql Server 2008 Web Edition With Visual Studio 2010?
Jan 11, 2011
I want to use SQL Server 2008 Web Edition with Visual Studio 2010 Professional. (Both are installed fine on Windows 7).I know I can change the entry in Data Connection (in VS Options) to the named instance of my Web Edition but, when I do this then try to add a database to an App_Data folder (via Add New Item...) I get an error saying I need the Express version of SqlServer 2005 or 2008 (I opted NOT to install this during installation as I knew I'd be using the full Web Edition instead).
I CAN add a data connection to a database created in the Web Edition instance by Sql Server Management Studio so VS can use the Web Edition instance.So, if I've changed the Data Connection to the Web Edition instance, why can't I add a database using that instance to my App_Data folder? Can I ONLY add Express instance databases to this folder?
I am considering an upgrade to Visual Studio 2010 Pro from my Visual Studio 2008 Standard Edition while the price is still $299. I have successfully used Visual Studio 2008 Standard Edition along with SQL Server 2008 R2 Express Edition to produce websites with database backends. I am assuming that I will still be able to do this with Visual Studio 2010 Pro without any heart-stopping transitional problems. Anyone have any experiences/advice about this? And just for the record, I cannot afford Visual Studio 2010 Premium which I believe would make this a moot point.
I installed SQL server along with Visual Studio 2008 Express edition Developer edition.
1. I want to access this server via Management Studio Express( I installed later) how can do it? Windows authentication or Sql server authentication - give me step by step procedure.
2. How to use the server in asp.net programs - how to give connectionstring
Would something be missing, not working, or confusing if I do this? First, install SQL Server 2008 Standard, and SP1. Then, install Visual Studio 2010 Professional, unchecking SQL Server 2008 Express option. Or would I need to fix any configurations afterwards?
I am looking at developing using Visual Studio 2010/2008 and SQL Server 2008 on Windows 7. Should I be able to do this on Windows 7 Professional, or do you need Windows 7 Ultimate?
Both visual studio 2008 express edition and visual studio professional setup's are install in my system, i like to uninstall visual studio 2008 express edition, and use professional edition. is there any problem arises in visual studio professional edition, if i uninstall visual studio 2008 exp edition
I recently set up a new development machine for myself back in November, and naively downloaded the then-current versions of VWD Express (2010) and SQL Server Express (2008 R2). Bummer to find out that they are not compatible. VWDE 2010 won't deal with a database version beyond 655, while SQL Server 2008 R2 is 661. It's puzzling that Microsoft shows the following in its Express website [URL]Powerful Set of Free ToolsMicrosoft® Visual Web Developer® 2010 Express provides you with everything you need to start building standards-friendly Web applications.SQL Server® 2008 R2 Express Edition is a lightweight, feature-rich, powerful database for your Web data-enabled needs.
Has the issue already been fixed (i.e. if I reinstall VWD 2010 Express today, will it now handle version 661 databases? Or will the issue be fixed at some point in the future? Or is it necessary (and even possible) to remove R2 and install plain SQL Server 2008 to get databases that VWDE 2010 will work with?
I had archived all of my files prior to the change. Since I am now having a great deal of trouble working with 2010, I want to revert. My question is: If I restore all of the archived files and start 2008, will I need to make any changes to the registry or to any other files?
The problems that I am having are illusive. Some of the relative paths nolonger work. Some f the projects that had been working for 24 months no longer functions. I am having a great deal of trouble calling my older "[WebMethod]" "ASMX" services and many other issues.
Is there anything special to do with Windows 2008 R2 Server and Visual Studio 2010 to get Oracle quereis to work? I have the same DB Connnection.string I have used before and it works. I am at a loss here.
I have VS 2008 Professional Edition.....I want to test a function like this:
public int getIdByName(string name) { var item=from x in DATAB where x.name=name select x.id; . . return idValue; }
now I test end I have:
[TestMethod()] public getIdByNameTest() { string name="Bob" int expected = 1; int actual; actual = ClassGET.getIdByName(name); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }
The error in "test run" is:
Failed ......[Class]....... Test method threw exception: System.ArgumentException: The specified named connection is either not found in the configuration that is not for use with the EntityClient provider or thought is invalid
I have installed VS Team System 2008 from a dvd on my computer,the setup has installed every thing but failled the installation of SQL Server 2005 Express Edition.The setup terminates my this error"An error has occured during the installation,Could not install SQL Server 2005 Express Edition". Then I have tried to install sql server 2005 through SQLEXPR.exe. But this .exe file has failed the installation of SQL Server Database Services and MSXML6. Do anybody have any idea why sql server 2005 is not installing on my machine? P.S I haven't installed any other version of VS except this VS 2008.
I have visual studio 2005 and sql server standard edition installed on my desktop. Im trying to get my head around the authentication and role administration part of visual studio controls.
At the moment Im using the browser version to configure the settings.
While im attempting to access the security tab to develope, users and roles i keep getting a message saying im unable to connect to the database. However, when i use my collogues PC with SQL server express installed it connects with no problems.
Does anyone have an idea how i configure this tool to use SQL server standard edition so i dont have to go back to express?
I have been developing my web application using ASP.Net with Visual Web Developer 2008 Express Edition. I would like to be able to create some fairly simple reports. I understand that in some of the higher versions of Express their is a report creation program called "Crystal Reports" but it is not available in the "Express" edition.
Is there some way that I can create reports in the Express Edition?
i create a asp.net web aplication project, and when i debug it i can see the result on localhost that is ok. but how can i publish this site on the web? there is no publish button ont the build menu and solution explorer menu?
My current Web Based Application is developed in .NET 2.0 framework using Visual Studio 2005 Standard edition tool and SQL Server 2005 Standard edition, Is it possible to convert to .NET 4.0 Framework using Visual Studio 2010 Professional Upgrade edition tool.I would like to purchase Visual Studio 2010 Professional Upgrade edition.
I have been ising TFS 2010 with VS 2010 Ultimately for a couple of months now. I have a client who is using Visual Web 2010, does anyone know if this integrated with TFS easily?
I have several css style sheets I want to work with. I have copied them into the appropriate directory structure in my project. The styles are applied correctly.But the manage CSS styles tool bar on the left margin doesn't seem to work correctly. At one point I had generated a style sheet and worked with it there, but now it not only can't find the one it generated, but the attach style sheet link doesn't respond at all, nor does anything in this bar. Same deadness with the CSS Properties bar. With or without a style sheet loaded in the editor -- a style sheet that is active in the project such that when I run it, the styles are applied.VB version of studio, running on Vista home basic.PS, the design mode works a lot better than the professional version I use in my day job on XP and server 2003.
I have downloaded, installed, registered and re-installed the above product. When I run the program, I do not have the option to create or open a website. Can anyone tell me why this option is missing?
I am a student of HLC, I am learning Visual Basic, they sended me lots of books and a CD with Microsoft Visual Studio 2008 Professional Edition. I have problem with installing it. There is the error;: "Setup Failed. Use the following links to research the source of the failure: There were errors during setup. Although the components were installed successfully, some setup errors were detected. View error log
For information on known setup issues, see the Microsoft Visual Studio readme file, readme.htm, located at the root of the installation source. For Knowledge Base articles on Visual Studio setup issues and solutions, see KB article 319714, HOW TO: Troubleshoot Visual Studio .NET Installation, at [URL]. To find help from other Visual Studio users, try the following newsgroups:
Visual Studio Setup Microsoft Product Support For details about this setup failure, see the setup log files."
and
"The following component failed to installl: Microsoft Document Explorer 2008. The following components were not attempted: Microsoft Visual Studio Web Framework 3.0 Framework 3.5" and many other componetns. I have got Windows Vista Home Basic SP2 with 1.00 gb RAM and 2.00GHz. I all ready asked my tutor but he don't know how to make it work. There is no information on the web about this problem.
I've installed visual studio 2010 full version and worked on couple of assignments. Right now, I'd want to connect to SQL server database to move ahead and store and retrieve data into the database. Can someone please point me in theright direction or walk me through the configuration. I see sql server 2008 has come with Visual Studio 2010. Not really sure if i need to install anything else. Also, post a sample application code to connect and fetch data using a select statement ??
