Not valid connection string

Question

I am trying to publish a web application through my local IIS. The database is local access database. I got this error that it is not a valid connection string as below. However, I can't see anything wrong with it.

The value

'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\eAdvanceData.mdb;User Id=admin;Password=;'

is not a valid connection string or an absolute path.

Does the database file eAdvanceData.mdb reside at c:\Temp\ on both your local machine and the web server you are publishing to? — TrevorBrooks, Jun 25 '14 at 13:56
Where do you generate that connection string from? Because it really does seem to be lacking some things. — durbnpoisn, Jun 25 '14 at 13:57
How do you get and set the connection string ? Be sure the backslash is not acting as an escape character — NicoD, Jun 25 '14 at 14:00
The connection string is in the web.config file and it is double quoted there. I thought the backslash was fine there: — Jane wang, Jun 25 '14 at 14:07

score 0 · Answer 1 · edited May 23 '17 at 12:10

0

It sounds like IIS doesn't have access to the file. You have to give read/write access to that file to the Application Pool that your site is running as.

This might help... IIS AppPoolIdentity and file system write access permissions

edited May 23 '17 at 12:10

Community

1
1

answered Jun 25 '14 at 14:10

Jason Geiger

1,912
18
32

When I was running Process Explorer, I can't find any process run by Application Pool. Wonder why? – Jane wang Jun 25 '14 at 15:35

Not valid connection string

1 Answers1