problem with opening database

Question

3.40/5 (3 votes)

See more:

hi friends.

i have developed a software with C# and sql server 2008.
my connection string is--

C#

@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ReminderDatabase.mdf;Integrated Security=true;User Instance=True;

and my database files are in the program execution path and i installed sqlexpress in that computer. i turned off the firewall and users have full access to the db files. now when i want to user log into the software(with pressing login button) an error occurs that say database can not be opened because it is version 661. this server supports version 655 and earlier. a downgrade path is not supported.could not open new database C:\program files\...\comp\...\mydatabase.mdf. create database is aborted. an attempt to attach an auto named database for C:\mypath\mydatabase.mdf failed. a database with the same name exists, or specified file can not be opened, or it is located on UNC share.

how can i solve this problem.

thanks friends.

Posted 21-Aug-14 0:09am

_Starbug_

Updated 21-Aug-14 0:11am

Snehasish_Nandy

v2

Add a Solution

2 solutions

Solution 1

You are mixing up the use of LocalDB ans SqlServer2008.

First: .\SQLExpress refers to a local instance and not a server instance. Replacing the . with the IP address of the SQL server is a starter.
Second: Use Catalog in stead of AttachDBFileName. With AttachDBFileName you can register your db. With Catalog you use the db.

Error with Located on a Share seems to look like you are using LocalDB and not SQLExpress. So find out which db you use, where it is in the network (LocalDB does not work over a network) -> IPADDRESS and which Catalog (= DB Name) your are using.
Is remote connection to the Db setup in the Sql Server Settings?

Enough to look after first.

Posted 21-Aug-14 0:22am

Herman<T>.Instance

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)

_Starbug_ · Accepted Answer · 2014-08-21T00:43:00

Solution 2

thanks for answer.my database and my program both are in one computer.i do not use network

Posted 21-Aug-14 0:43am

_Starbug_

Comments

Herman<T>.Instance 21-Aug-14 6:49am

You can reach our db via the SQL Server Management Studio?

_Starbug_ 21-Aug-14 6:51am

i can not understand what you are saying.reach?

Herman<T>.Instance 21-Aug-14 6:58am

you can open your database in SQL Server Management Studio?

_Starbug_ 21-Aug-14 7:01am

yes i can.

Herman<T>.Instance 21-Aug-14 7:02am

what is the name of the database?

_Starbug_ 21-Aug-14 7:06am

it is ReminderDatabase

Herman<T>.Instance 21-Aug-14 7:07am

your connectionstring would be:
@"Data Source=.\SQLEXPRESS;Catalog=ReminderDatabase;Integrated Security=true;User Instance=True;

for only on your machine. But you write:
"i turned off the firewall and users have full access to the db files". It is wise to change the .\SqlExpress to <TheIPOfYourMachine>\SqlExpress

_Starbug_ 21-Aug-14 7:10am

thank you. can database version affect the connection. i created this database with sql 2008 r2(661). but i think probably my express sql is 2008(655). please explain about this.
thanks.

Herman<T>.Instance 21-Aug-14 7:13am

Upgrade to r2! The newer version was made with reasons. There where so many problems in 2008 version that they made R2 to fix that. Since you are using SqlExpress you might consider installing the 2012 version.

_Starbug_ 21-Aug-14 7:16am

thanks again.do you have download link of sqlexpress 2008 R2?

Herman<T>.Instance 21-Aug-14 7:18am

just google for it. It shows you the path to the download center of Microsoft directly

You might test with the provided connectionstring if you can connect to your DB.