Visual Studio :: SQL Server 2008 + (2010 - SQL Server 2008 Express) = OK?
Apr 15, 2010
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 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.
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.
After I installed Visual Studio 2008 Standard edition, then I upgrade "SQL Server Express 2005" to "SQL Server Express 2008 SP2". Process upgrading SQL Server Express 2008 was going succesfully (none of the process was fail).
But when I create a New Website I could not add a new item "SQL Server Database" into my website file. Because Visual Studio always rejected any new "SQL Server Database" by giving message below (underline):
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.
We are trying to install VWD 2010 on a windows 2008 server. We already have installed the 2008 version as well as SQL 2005, 2008 and 2008 R2. The Web Platform installer is not installing VWD 2010 however.At first it notified us that the OS does not allow it, after running tons of updates on the OS (some of which failed) it is still not doing it, not even donwloading it. The latest message simply asked us to post the error on the forum
I jsut installed SQL server and management studio on my PC. For management studio, I created a database with tables. However, When I have data connection for SQL server in visual studio express, I couldn' t see the database I created.
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'm trying to access an SQL Server Express database out of an ASP.NET HTTP request handler. The handler is run under ASPNET account and uses "integrated security" in the SQL connection string and so I get an error message saying that login for ASPNET account failed and so I can't access the database. This seems to be a very common problem and most answers say "grant access to you database to user ASPNET".
I only have Visual Studio 2008 and I can't find how to change access permisssions for a database. Specifically I use Tools->Server Explorer and I can see all the tables in the database but can't find how to change access permissions. How do I change access permissions to my database using tools shipped within Visual Studio 2008?
Is there a spell checker add in that can be used with VS2010 express? I have downloaded a add-in for 2008 that "claims" to work with 2010 but when I installed it on my machine it does not show up in the tools menu and I cannot find the exe to add it via the external tools interface. Is there a add-in for VS2010 paid or free?
My existing system has Visual Studio 2008 and Visual Web Developer 2010 Express. But Microsoft web installer for Webmatrix has made Wematrix Launch ribbon menu pointing to Visual Studio 2008. How could I make Webmatrix point to Visual Web Express 2010. To make use of IntelliSense and the debugger, I have to manually launch Visual Web Developer 2010 Express.
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 started working on a website using 2010 Express. However, the hosting company that I am using hasn't fully implemented .NET 4.0. I'm wondering if there is a way that I can save my website for compatability with 2008 express. Then I can finish and publis using 2008 Express.
I been trying to attach a database in sql 2008 express created in VS 2008 Professional. I have been getting error message and codes which there is no support for once you click the link in the message whats up with that? to my most recent memory it had something to do with permissions... but I was logged in as adminstrator so that confuses me.
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 looked at all the posts I can find on this problem and tried everything I can think of, but still the problem persists. I am getting really sick of it.was working fine for the last year until an update to MS Office 2007 caused a lot of problems (automatic update). After checking posts here, I removed it completely. No change. I then tried all the things I could find on other posts, also no change. Today, I removed VS and the Web Authoring Component and re-installed. Still no go.
Does anyone have a fix for this problem. It seems that it has been around a long time, but is still giving problems. I even saw one suggestion to reformat the drive! You've got to be joking!
I'm creating a website and I'm testing resgistering and Log-in.
I followed a simple tutorial to create a Log-in in Visual Studio C# template which generated a SQL Server database.Locally the Log-in and registration page works perfectly. The problem is that when I upload my site to the hosting site the navigation works but the Log-in and Registration forms send an error when clicked "Register" or "Log-in". I contacted the site and they upload my database the way it should be because I was doing it wrong. I can see all my files including the data base.
They commented me that I had to do a connection string to the data base so the login and registration forms can work. I don't understand how to do that, I know the connection string has to be declared in the Web Config File, the thing is that I don't know how to write that code and link it to my data base in the hosting site, in fact I have sample code but I don't know just what do I need to put in it.