Sql Exception after Deploye application

Question

I make an app with local database after delpoye when i attempt to run i got above Error. my connection string is as.... ------- Please Help Asap

Subodh Natoo · Answer

As per the exception, give Read and Write permission to the .mdf file and install the application on C:\ instead of default location of Program Files because bydefault Program Files folder doesn't have permission to read and write without Administrator.

Abhilash J A · Answer

AttachDBFileName is evil, see this question: https://www.codeproject.com/Answers/1192085/How-do-I-connect-to-old-version-database-in-visual#answer2

Amit Gupta · Answer

Hey Exception seems that it was sqlite and mdf file is used in Sql Server. I think you might be using sqlite class for opening sql files. Do check to resolve your issue.

aman deep · Answer

i cant understand it. after deploye it is running on my pc. But when i try to run on somebody else`s PC it give me exception above is directry after instalation on my Pc

Rajkiran Swain · Answer

If you install your app to another pc, I´m quit sure there is NOT the same directory structure as on your development pc. If you 'install' your app with an installer your binaries will possibly be located somewhere in 'Program Files', not in YOUR Visual Studio Projects Directory. And further, don´t try to locate your db in the directory where your bin´s are. I had the same issue. To solve it I change the connection string datasource to the c: folder. So I had to put my database on the target computer. Please accept this an if it helpful .

Sql Exception after Deploye application

Answers (5)