View Single Post
  #1 (permalink)  
Old November 10th, 2003, 10:09 AM
goljazoran goljazoran is offline
Registered User
Join Date: Nov 2003
Location: Royal Oak, MI, .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP Database Connection-File permission problem

Hi everyone!

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.