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.

                                                        Zoran.

Hi

I would rather try using:
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../datastores/Movie2000.mdb")

The datastores directory should be located under the root of the site.

Hope this helps in any way.

Rgrds
M




Such is Life!

No, definitely not, unless you want anyone to be able to download your entire database.

Zoran, I don't know why it errors on Set objConn = Server.CreateObject("ADODB.Connection"). Is this in global.asa or in a regular asp page?

rgds
Phil

Hi everyone,
I'm desperate and I need your help.
I Have registered a domain name, they forwarded the dns to my static ip and I want to form my personal web server on my pc. I use win xp prof. I installed IIS, I modified security settings not to ask a username and password (because one of my friends told me to do so :-)) and placed my web pages in a spesific folder inetpub/wwwroot
and I tried to connect to site from 127.0.0.1 (because my friend told me to do so :-)) and my browser keeps asking a username and pass to me. as you can understand I'm very new with these things. please help me if you can
thanks in advance

Hi there,

What settings did you change so IIS does not ask for a password? Did you make sure that IUSR_MachineName has sufficient access to the Inetpub\wwwroot on disk (through NTFS permissions)? It needs these to be able to read the files.

Can you start a new topic for a new question, instead of continuing a non-related previous post in the future? Makes things easier for everyone.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.