Cannot attach the file as database

Question

I've already seen all other post and seems cant help me.

String constr = (@"Data Source=(localdb)\MSSQLLocalDB;
        AttachDbFilename= E:\Downloads Mainframe\Compressed\Main Menu\HRDAssets.mdf;
        initial catalog=HRDAssets; 
        Integrated Security=True;");

https://cdn.discordapp.com/attachments/268002637905920001/506753130848059394/unknown.png

When I removed

AttachDbFilename= E:\Downloads Mainframe\Compressed\Main Menu\HRDAssets.mdf;

new problem pops

https://cdn.discordapp.com/attachments/506763196225421312/506763211492556800/unknown.png

What's your question? Why can't I open a database when the connection string doesn't reference a database? — Neil, Oct 30 '18 at 09:44
If you open the folder: `E:\Downloads Mainframe\Compressed\Main Menu\` is there a file there called HRDAssets.mdf? — Neil, Oct 30 '18 at 09:45
Possible duplicate of [Cannot attach the file \*.mdf as database](https://stackoverflow.com/questions/17012839/cannot-attach-the-file-mdf-as-database) — Anas Alweish, Oct 30 '18 at 09:54

Anas Alweish · Answer 1 · 2018-10-30T09:53:54.727

0

Remove this line from the connection string

AttachDbFilename= E:\Downloads Mainframe\Compressed\Main Menu\HRDAssets.mdf;

and Initial Catalog property I suggest to use:

Data Source=(LocalDb)\MSSQLLocalDB;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\HRDAssets.mdf

edited Oct 30 '18 at 09:53

answered Oct 30 '18 at 09:45

Anas Alweish

2,818
4
30
44

new problem is on this screenshot https://cdn.discordapp.com/attachments/506763196225421312/506763211492556800/unknown.png – Nanoticon Oct 30 '18 at 09:50
@Necrodor21Sa I have modified my answer – Anas Alweish Oct 30 '18 at 09:53

Cannot attach the file as database

1 Answers1