p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Beginning ASP 3.0 (http://p2p.wrox.com/forumdisplay.php?f=27)
-   -   ASP Database Connection-File permission problem (http://p2p.wrox.com/showthread.php?t=5967)

goljazoran November 10th, 2003 10:09 AM

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.

                                                        Zoran.


All times are GMT -4. The time now is 09:52 AM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.