error in vs2010 plz solve it

Question

1.00/5 (1 vote)

See more:

VS2010

i have a problem in doing my database connectivity,
in windows form when i add a new service based database by clicking new item it gives me error. i will state that is
"connection to sql server database files .mdf, require sql server 2005 express or sql server 2008 express tobe installed and running on the local computer"
plz guyz i want to made my project but because of this error i cant proceed.
i have installed a database named sql server 2012 express local db
but its not working.i have just installed that and nothing done with that new db 2012 express
can anyone helpme out of it
thanks in advance

Posted 6-Aug-12 8:15am

shaikh-adil

Add a Solution

Comments

[no name] 6-Aug-12 14:22pm

So the message tells you that you have to install SQL Server 2005 or 2008 and you go and install SQL Server 2012?

Sandeep Mewara 6-Aug-12 14:33pm

Comment from OP:
yes its tells me that by going on that link i have installed the newest database sql server 2010 but after that the error is not going. I cant create a new database connection because of that error

shaikh-adil 6-Aug-12 14:27pm

yes
its tells me that by going on that link i have installed the newest database sql server 2010 but after that the error is not going.
I cant create a new database connection because of that error

Sergey Alexandrovich Kryukov 6-Aug-12 14:31pm

And what prevents you from installing it?
--SA

ZurdoDev 6-Aug-12 14:31pm

Are you trying to connect to a database file (mdf) or to a SQL instance?

shaikh-adil 6-Aug-12 14:37pm

noting prevents. i have installed the sql server 2012 as the error given but at last the error is not going @ sergey
i dont know about instance and all thing i am new to programming world.
i want to connect to a database by windows form so i want to use datagridview in tool. But before that i have to solve this error then only my sqlconection will proceed
@ ryan31

Philip Stuyck 6-Aug-12 14:46pm

Have you actually created a database in sqlserver 2012.
If you are new to the programming world, do you have any idea about what you are doing. Read some books.

shaikh-adil 6-Aug-12 15:39pm

yup i know little bit. In other computer in my lab i have used that windows form type. But in my pc its not working, no one knows this message? All are new to this? I thought many have faced such kinda situation

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kenneth Haugland · Answer 1 · 2012-08-06T08:45:00

Solution 1

Did you follw these steps:
http://msdn.microsoft.com/en-us/library/hh500335%28v=vs.103%29.aspx[^]

Looks like you might be missing a service pack on you Visual Studio package...

I currnely have VS 2010 and SQL 2012 without any problems, so...

Posted 6-Aug-12 8:45am

Kenneth Haugland

Comments

shaikh-adil 6-Aug-12 20:13pm

yup after installation my package fails to isntall sql management package.
So how to install this package seperately?

**Zoltán Zörgő** · Answer 2 · 2012-08-06T10:45:00

You can not simply attach and run a database file (.mdf) to a different engine than the one that created it. There might be several differences between them. You can use the backup-restore method[^], or you will probably need to upgrade the database: http://msdn.microsoft.com/en-us/library/ms189625.aspx[^]. Read also this: http://www.mssqltips.com/sqlservertip/1436/upgrading-sql-server-databases-and-changing-compatibility-levels/[^]