|
 |
access_asp thread: Re: Another Read-Only Connection Problem
Message #1 by "Ken Schaefer" <ken@a...> on Tue, 4 Jun 2002 12:39:50 +1000
|
|
a) Check your NTFS permissions
b) Do you have <% Option Explicit %> at the top of your page?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mwhitmill@e...>
Subject: [access_asp] Another Read-Only Connection Problem
: I'm running Windows-XP Pro using IIS.
:
: My error message is:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
: object is read-only.
: /reunion/EAI_Name_Update.asp, line 545
:
: Line 545 is: objRSEntry.update
:
: Here's the connection open:
: set objConn = Server.CreateObject("ADODB.connection")
: objConn.open "DSN=Invite2ReunionDB"
:
: Here's the record set open:
: objRSEntry.Open sqlRS, objConn, adOpenDynamic, adLockOptimistic
:
: I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
: The book said I should be able to change properties but my program blew
: up when I tried to set this value to FALSE.
:
: The properties associated with my actual Access file shows it not to be
: READ-ONLY.
:
: I checked ODBC properties on my DSN and "Read Only" is NOT checked.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #2 by mwhitmill@e... on Tue, 4 Jun 2002 20:24:32
|
|
> I'm running Windows-XP Pro using IIS.
> My error message is:
E> rror Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
o> bject is read-only.
/> reunion/EAI_Name_Update.asp, line 545
> Line 545 is: objRSEntry.update
> Here's the connection open:
> set objConn = Server.CreateObject("ADODB.connection")
> objConn.open "DSN=Invite2ReunionDB"
> Here's the record set open:
> objRSEntry.Open sqlRS, objConn, adOpenDynamic, adLockOptimistic
> I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
T> he book said I should be able to change properties but my program blew
u> p when I tried to set this value to FALSE.
> The properties associated with my actual Access file shows it not to be
R> EAD-ONLY.
> I checked ODBC properties on my DSN and "Read Only" is NOT checked.
> Where do I go from here?
> Thanks for any help you can give me.
-> -Mike
Message #3 by Karri Peterson <KPeterson@C...> on Tue, 4 Jun 2002 14:17:34 -0500
|
|
The answer to this apparently seems to be across the board--check NTFS
permissions.
Many people seem to be having trouble with this one lately.
:-)
-----Original Message-----
From: mwhitmill@e... [mailto:mwhitmill@e...]
Sent: Tuesday, June 04, 2002 3:25 PM
To: Access ASP
Subject: [access_asp] Re: Another Read-Only Connection Problem
> I'm running Windows-XP Pro using IIS.
> My error message is:
E> rror Type:
M> icrosoft OLE DB Provider for ODBC Drivers (0x80004005)
[> Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
o> bject is read-only.
/> reunion/EAI_Name_Update.asp, line 545
> Line 545 is: objRSEntry.update
> Here's the connection open:
> set objConn = Server.CreateObject("ADODB.connection")
> objConn.open "DSN=Invite2ReunionDB"
> Here's the record set open:
> objRSEntry.Open sqlRS, objConn, adOpenDynamic, adLockOptimistic
> I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
T> he book said I should be able to change properties but my program blew
u> p when I tried to set this value to FALSE.
> The properties associated with my actual Access file shows it not to be
R> EAD-ONLY.
> I checked ODBC properties on my DSN and "Read Only" is NOT checked.
> Where do I go from here?
> Thanks for any help you can give me.
-> -Mike
Message #4 by mwhitmill@e... on Tue, 4 Jun 2002 20:27:20
|
|
>
a) Check your NTFS permissions
b) Do you have <% Option Explicit %> at the top of your page?
Cheers
Ken
####################################################################
a) I can't find my NTFS permissions. I understand permissions, but don't
know how to find them and/or set them.
b) Yes, I do have <% Option Explicit %> in my program.
Looking forward to your response.
--Thanks, Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mwhitmill@e...>
Subject: [access_asp] Another Read-Only Connection Problem
: I'm running Windows-XP Pro using IIS.
:
: My error message is:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
: object is read-only.
: /reunion/EAI_Name_Update.asp, line 545
:
: Line 545 is: objRSEntry.update
:
: Here's the connection open:
: set objConn = Server.CreateObject("ADODB.connection")
: objConn.open "DSN=Invite2ReunionDB"
:
: Here's the record set open:
: objRSEntry.Open sqlRS, objConn, adOpenDynamic, adLockOptimistic
:
: I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
: The book said I should be able to change properties but my program blew
: up when I tried to set this value to FALSE.
:
: The properties associated with my actual Access file shows it not to be
: READ-ONLY.
:
: I checked ODBC properties on my DSN and "Read Only" is NOT checked.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #5 by Karri Peterson <KPeterson@C...> on Tue, 4 Jun 2002 14:22:14 -0500
|
|
NTFS permissions are the permissions the operating system puts on the file
itself. Go to the directory your .mdb file is in,
right click on it and look at properties--security. Set it to a lower
security setting--such as everyone/full control.
Ken,
Is there a better option than everyone/full control with these access file?
I hate that--that's like an invitation to hackers.
Karri
-----Original Message-----
From: mwhitmill@e... [mailto:mwhitmill@e...]
Sent: Tuesday, June 04, 2002 3:27 PM
To: Access ASP
Subject: [access_asp] Re: Another Read-Only Connection Problem
>
a) Check your NTFS permissions
b) Do you have <% Option Explicit %> at the top of your page?
Cheers
Ken
####################################################################
a) I can't find my NTFS permissions. I understand permissions, but don't
know how to find them and/or set them.
b) Yes, I do have <% Option Explicit %> in my program.
Looking forward to your response.
--Thanks, Mike
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mwhitmill@e...>
Subject: [access_asp] Another Read-Only Connection Problem
: I'm running Windows-XP Pro using IIS.
:
: My error message is:
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
: object is read-only.
: /reunion/EAI_Name_Update.asp, line 545
:
: Line 545 is: objRSEntry.update
:
: Here's the connection open:
: set objConn = Server.CreateObject("ADODB.connection")
: objConn.open "DSN=Invite2ReunionDB"
:
: Here's the record set open:
: objRSEntry.Open sqlRS, objConn, adOpenDynamic, adLockOptimistic
:
: I checked objConn.Properties("Read-Only Data Source") and it is TRUE.
: The book said I should be able to change properties but my program blew
: up when I tried to set this value to FALSE.
:
: The properties associated with my actual Access file shows it not to be
: READ-ONLY.
:
: I checked ODBC properties on my DSN and "Read Only" is NOT checked.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #6 by mwhitmill@e... on Thu, 6 Jun 2002 17:49:27
|
|
The problem is resolved. I modified the specifications which I just
couldn't find initially. In XP-PRO, when you right-click a folder you
get a "Sharing and Security" option in which I changed the sharing aspect
for the folder to include network users since this is an IIS problem and
the user is the anonymous account IUSR_.... In my case I'm protected by
a router so network usage essentially means just my home.
--Thanks to all for your help, Mike
|
|
|
View Cart
