Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP 3.0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 10th, 2003, 10:09 AM
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.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Connection Problem with ASP.NET fukai100 Classic ASP Databases 2 August 13th, 2004 12:12 PM
Database Connection Problem with ASP.NET fukai100 SQL Server ASP 1 August 12th, 2004 07:37 PM
ASP Database Connection-File permission problem goljazoran Classic ASP Databases 4 November 29th, 2003 05:09 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.