Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP 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
  #11 (permalink)  
Old May 5th, 2004, 10:52 PM
Registered User
 
Join Date: Sep 2003
Location: Morgantown, WV, USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

I'm having the same problem. Unable to write to a database with all the reqd permissions set. I'm running IIS 5.1 on a Win XP machine. I dont see any security tab when I select properties of my virtual directory. My database is getting updated on the server :)

Please help

Thanks

Senthil

Reply With Quote
  #12 (permalink)  
Old May 6th, 2004, 01:53 AM
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,

Please check out this article: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263

Half way down the article there is a section called Changing the Security Settings. It will explain you how to enable the security tab and set the required permissions.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Suck it Up by Hed Planet Earth (Track 1 from the album: Blackout ) What's This?
Reply With Quote
  #13 (permalink)  
Old May 9th, 2005, 05:12 PM
Registered User
 
Join Date: Apr 2005
Location: , , United Kingdom.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar, old question but I can't find the answer - probably because I'm a complete novice and most of the stuff you've said already is way beyond me.

Im getting the error message

"Cannot update. Database or object is read only."

My code works OK on my local PC but when I load it onto my ISP server, I get this error. I understand that it is to do with permissions and I've read what you've said before (and looked at your FAQ on your website) but what I don't understand is how to set the permissions on the remote Database.

Please could you explain (in VERY basic terms) how I should solve my problem and what things like IUSR_MachineName means?


Quote:
quote:Originally posted by Imar
 Hmmm, odd.

Here are a few things to check:

1. Find out under which account IIS is running. You'll find this name on the Directory Security of the Properties dialog for your Web site. Check whether Anonymous access has been enabled or not.

2. Check that you're actually setting the permissions for the correct database. This may sound obvious, but it's important that you set the settings for the .mdb file in the scope of your Web folder (usually somewhere under Inetpub\wwwroot) and not the one you use for development.

3. Make sure you have a valid connection string to your database. Check here for info: http://www.able-consulting.com/MDAC/...orMicrosoftJet

4. Make sure your database is not password protected and that you're not trying to connect to it using a username / password combination that doesn't exist.

5. Check the ReadOnly property of the /mdb file on disk. Maybe the physical file or folder is read-only.

If all this doesn't help, I suggest you provide some info about your setup (Web server, folder, etc) and post the code for the page you're trying to run.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #14 (permalink)  
Old May 10th, 2005, 02:40 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

You probably can't. If your ISP is in control of the machine (that is, you don't have a dedicated server that you control), there is probably no way for you to change those settings.

Usually, you need to contact your ISP (or maybe they have a FAQ on their web site that explain the steps you need to perform) and explain you need to access a database. When that's included in your hosting package, they either set the right permissions on your database folder, or they give you a DSN that points to some database. How this works, is fully up to your ISP.

So, the best thing to do is contact them and explain your situation.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Light My Way by Audioslave (Track 12 from the album: Audioslave) What's This?
Reply With Quote
  #15 (permalink)  
Old December 11th, 2007, 06:15 AM
Registered User
 
Join Date: Dec 2007
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Imar,
I am getting this error while running a DTS from the SQL environment. I dont c any IIS settings getting involved in this. It is working fine with the local database but when i use the database where my LIVE code is pointing, it shows me this error. Please let me know if any more information is required from my side.

Thanks in advance.

Dhaval

Quote:
quote:Originally posted by Imar
 You probably can't. If your ISP is in control of the machine (that is, you don't have a dedicated server that you control), there is probably no way for you to change those settings.

Usually, you need to contact your ISP (or maybe they have a FAQ on their web site that explain the steps you need to perform) and explain you need to access a database. When that's included in your hosting package, they either set the right permissions on your database folder, or they give you a DSN that points to some database. How this works, is fully up to your ISP.

So, the best thing to do is contact them and explain your situation.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Light My Way by Audioslave (Track 12 from the album: Audioslave) What's This?
Reply With Quote
  #16 (permalink)  
Old December 11th, 2007, 06:41 AM
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

The principle is probably the same. The account that executes your code (e.g. the DTS package in SQL Server) doesn't have permissions to access the remote database.

Can you provide more info about your setup? E.g. which servers are involved, the accounts they run under, the way you configured the DTS package, whether your "LIVE code" is in the same network or not etc etc.

You may want to take a look at this article: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=263 and see if it helps you understand more about security and context so you can figure out what the problem is.


Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.
Reply With Quote
  #17 (permalink)  
Old May 10th, 2012, 01:29 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default connectionstring problem

sir,
i am using database access .but when i run the browser ,it shows error like this

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

my page coding

<%@ LANGUAGE="VBSCRIPT" %>
<% option explicit %>
<html>
<bod>

<%

dim objconn
set objconn = server.CreateObject("ADODB.connection")
objconn.connectionstring = "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\inetpub\wwwroot\aspnet_client\widg etworld.mdb;Uid=Admin;Pwd=;"


objconn.open
dim objrs
set objrs=server.createobject("adodb.recordset" )
objrs.open "friends",objconn, , , adcmdtable
do while not objrs.eof

response.Write "<b>" & objrs("name") & "</b><br>"
response.Write objrs("streetaddress") & "<br>"
response.write objrs("city") & "," & objrs("state")
response.write "<br>" & objrs("zip") & "<br>"
response.write objrs("phoneno") & "<p><hr><p>"
objrs.movenext
loop
objrs.close
set objrs=nothing
objconn.close
set objconn=nothing
%>
</body>
</html>
plz solve my poblem as soon as possible
Reply With Quote
  #18 (permalink)  
Old May 10th, 2012, 02:13 AM
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,

Take a look here: http://imar.spaanjaars.com/263/how-d...0004005-errors

Also, you seem to be using an out-dated OleDb driver. Check www.connectionstrings.com for an updated version.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #19 (permalink)  
Old May 10th, 2012, 05:23 AM
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with connectionstring

sir,
i am using window7 ultimate.and odbc shows only microsoft access driver?(*.mdb).

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

/aspnet_client/friendstb.asp, line 14


i am in great trouble,plz solve it i shall be very thank ful to u.can u guide me online.
Reply With Quote
  #20 (permalink)  
Old May 10th, 2012, 06:18 AM
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

Can you post your updated OleDb connection string?

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
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
Cannot update. Database or object is read-only. zedekiah Classic ASP Databases 1 May 2nd, 2008 09:30 AM
Update Fails - Database is Read-Only pete robinson Classic ASP Basics 3 December 19th, 2007 02:40 PM
Read only Database error larry101 Classic ASP Databases 4 September 11th, 2004 08:41 AM
permit read only while database is OPEN Belier Access 5 April 6th, 2004 08:26 PM
How to read/write Access Database jmmendes Access VBA 0 November 18th, 2003 01:26 PM



All times are GMT -4. The time now is 06:43 PM.


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