Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 11th, 2003, 09: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.

                                                        Zoran.
Reply With Quote
  #2 (permalink)  
Old November 17th, 2003, 05:30 AM
Friend of Wrox
 
Join Date: Nov 2003
Location: Johannesburg, , South Africa.
Posts: 141
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to acdsky
Default

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!
Reply With Quote
  #3 (permalink)  
Old November 17th, 2003, 08:50 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , United Kingdom.
Posts: 1,212
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:Originally posted by acdsky
 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
Reply With Quote
  #4 (permalink)  
Old November 29th, 2003, 02:21 PM
Registered User
 
Join Date: Nov 2003
Location: ankara, , Turkey.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to kurnaz Send a message via MSN to kurnaz
Default

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

Reply With Quote
  #5 (permalink)  
Old November 29th, 2003, 05:09 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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 BOOK: Beginning ASP 3.0 0 November 10th, 2003 10:09 AM



All times are GMT -4. The time now is 05:35 PM.


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