Last post Sep 30, 2013 02:41 AM by Angie xu - MSFT
Sep 26, 2013 05:15 PM|HELPLIFE888|LINK
How I can get my Visual Web Developer 2012(with ASP.NET 4.5) to work with
Sql Server 2008 R2 Express?
I have been running Visual Web Developer 2010 Express
with SQL SERVER 2008 R2 Express.
I recently UPGRADED to
Visual Web Developer 2012 Express and
Sql Server 2012 Express.
I used the option of UPGRADING from SQL SERVER 2008 R2 to
SQL SERVER 2012. I finally got the above to work!
ASP.NET 4.5 works and SQL SERVER 2012 works
and they both work together!
YAY! It was not easy!
Then I called up my
internet hosting company and asked them
if they could host SQL SERVER 2012. They said NO---not yet.
What they CAN do is host ASP.NET 4.5 with
SQL SERVER 2008 R2. So I would now like to
find out how I (on my own personal computer)
get my Visual Web Developer 2012
(with ASP.NET 4.5) to work with
Sql Server 2008 R2 Express.
Right now, my ASP.NET 2010 EXPRESS seems
to be still working and it also seems to be working with SQL SERVER 2008 R2
(it can successful show databases using the LISTVIEW control.) I can still bring up SQL SERVER 2008 R2
Management Studio. It shows me the list of databases.
But then when I try to actually look at the data in one of the
tables it gives me this error message:
"INVALID PREFIX OR SUFFIX CHARACTERS" "(MS VISUAL DATABASE TOOLS)"
So, I would like to:
1. Get my SQL SERVER 2008 R2 working again.
2. Get ASP.NET 4.5 to work with ****SQL SERVER 2008 R2****
Thanks for your help!
Sep 30, 2013 02:41 AM|Angie xu - MSFT|LINK
"INVALID PREFIX OR SUFFIX CHARACTERS"
According to your description above, you got the error massage above when you access SQL Server 2012 express from SQL Server 2008 r2 management studio, it seems that you opened old version application with SQL Server 2012 express. Because your hosting
provider doesn't support SQL server 2012 express, you can uninstall SQL server 2012 express, and use SQL server 2008 r2 express with your VWD 2012. Or you could also consider use other hosting providers, such as Microsoft Windows Azure hosting-
hope it helps,