That's because you detached it incorrectly. If you copy/paste the .mdf out of the directory without first detaching it, the sys tables are not updated correctly so when you try to reattach the database, the sys tables think it's still there.
No mate it doesnt allow you to copy also if the databse is attach
I am using Win 7 atleast it doesnt allow me in this dunno about win xp.
Also I didnt directly copy it I first detach and then copied it.
Also the error states that "cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported" I tried looking for solution for the same and some where it was mention in such situation once the db
is detach you can't attach it back as the server doesnt support it but nothing like this happens I can attach and detach the database without any problem. Also after attaching I can query the db and it work perfectly fine
nikhil_shirg...
None
0 Points
7 Posts
Re: SQL connection Error 26 while using LINQ
Apr 20, 2012 06:44 PM|LINK
No mate it doesnt allow you to copy also if the databse is attach
I am using Win 7 atleast it doesnt allow me in this dunno about win xp.
Also I didnt directly copy it I first detach and then copied it.
Also the error states that "cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported" I tried looking for solution for the same and some where it was mention in such situation once the db is detach you can't attach it back as the server doesnt support it but nothing like this happens I can attach and detach the database without any problem. Also after attaching I can query the db and it work perfectly fine