Error in accessing database in C#

Question

I am accessing a service based database by using the following connection string

static string appath = Library_Records.Program.app_path;

string connectionstring = @"Data Source=.\SQLEXPRESS;AttachDbFilename=appath;Integrated Security = true;User Instance = True";
connection = new SqlConnection(connectionstring);

 static string dbfiles = null;
 internal static string app_path
 {
     get { return dbfiles = "|Datadirectory|\\5700.mdf"; }
 }

Library_Records:namespace, Program is the class name containing Main()

When I call connection.Open(), it gives the following error

An attempt to attach an auto-named database for file appath failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

5700 is my database with .mdf extension. How to rectify this problem?

Sergii Kudriavtsev · Accepted Answer · 2012-06-01 09:11:56Z

3

Variables are never automatically replaced with values in strings, so AttachDbFilename=appath; will not work.

You should do something like:

string connectionstring = 
    string.Format(@"Data Source=.\SQLEXPRESS;AttachDbFilename={0};Integrated Security=True;User Instance=True", appath);

connection = new SqlConnection(connectionstring);

edited Jun 1, 2012 at 9:11

answered Jun 1, 2012 at 9:04

Sergii Kudriavtsev

10.5k5 gold badges48 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

jaggi Over a year ago

It worked thankyou sir Now if i create a setup file(.exe) then will the database be accessible on any other computer because i first created a setup in which AttachDbFilename=C:\Users\Sarao\Documents\prjs\Library_Records\Library_Records\5700.mdf and when i run it on the other computer it said that database is not accessible followed by path

Sergii Kudriavtsev Over a year ago

As long as you copy your database file to another computer together with your program - it should work.

Collectives™ on Stack Overflow

Error in accessing database in C#

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related