ASP Database Connection-File permission problem
I am running my personal web server on Win XP pro with IIS 5.0.
I can’t connect with my access database. Error I am getting is HTTP 500 or internal server error. After I changed error message display, it refers me to lane:
Set objConn = Server.CreateObject("ADODB.Connection")
My connection string is fine( I guess) :
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\datastores\Movie2000.mdb;" & _
"Persist Security Info=False"
I have tested with MS data link file and it gives me the same string.
What I assume, after the research, is file permission problem. Through server, after the test, I am logged like IUSR_computer’s name. I gave read and write permission to this user and even to guests and everyone, but problem is still here. I downloaded the latest version of the drivers (2.7 for xp).
I can’t figure out what else I have to change to make this connection work. Maybe I omitted to change permission rights some place else ?
I hope somebody does have an answer for me. Thanks in advance.