Sqlite connection string in web.config

Question

I have published my web project to local iis but framework can't find the "db" file. In debugging there is no problem, i can connect but in localhost i can't. Here is my connection string:

<connectionStrings>
    <add name="PROD" connectionString="data source=app.db;" providerName="System.Data.SQLite"/>
  </connectionStrings>

I tried everything "../app.db" "direct_path" "~/app.db"

What might the problem?

It can find the database in D:\ drive or other than inetpub drive. I didn't understand if it's a permission problem or not. How can i find the exact solution for that?

mehmetserif · Accepted Answer · 2012-01-02 08:39:47Z

3

Well i got the physical path with System.AppDomain.CurrentDomain.BaseDirectory and then find the path of sqlite file. It worked!

answered Jan 2, 2012 at 8:39

mehmetserif

1,2158 gold badges27 silver badges50 bronze badges

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

Comments

Jason Meckley · Accepted Answer · 2011-12-22 14:55:44Z

0

this is most likely a permissions issue. this works while debugging because the website is running under your credentials and you have full control. when deployed it's running under IIS_USRS which is highly restrictive and, most likely, doesn't have write permissions to the file by default.

provide the IIS_USRS account with read/write permissions to the directory/file and this should work.

answered Dec 22, 2011 at 14:55

Jason Meckley

7,6011 gold badge26 silver badges46 bronze badges

2 Comments

mehmetserif Over a year ago

i gave all the permissions to file / folder but no hope.

mehmetserif Over a year ago

data source = |DataDirectory|app.db is my connection string App_Data directory is under bin dir when i publish the project

Collectives™ on Stack Overflow

Sqlite connection string in web.config

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related