|
 |
asp_databases thread: Microsoft OLE DB Provider for ODBC Drivers Cannot update.
Message #1 by "swapna ankireddy" <swapnaankireddy@y...> on Fri, 20 Jul 2001 09:31:00
|
|
hi,
I am using ms-access as database. And i set all the properties
correctly.But i am not able to use update and insert commands.I am getting
this type of error.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
object is read-only.
Why i am getting this error?.Any one can help me?
thanks
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 20 Jul 2001 19:00:15 +1000
|
|
a) You have the database open elsewhere
b) The permissions for the IUSR_<machinename> account are not set correctly.
That user can not create, or cannot destory the .ldb lockfile that Access
uses
c) You have some other kind of exclusive blocking lock on the table in
question (eg another user, or recordset)
d) The recordset you are using is not updateable.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "swapna ankireddy" <swapnaankireddy@y...>
To: "ASP Databases" <asp_databases@p...>
Sent: Friday, July 20, 2001 9:31 AM
Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers Cannot
update.
: hi,
: I am using ms-access as database. And i set all the properties
: correctly.But i am not able to use update and insert commands.I am getting
: this type of error.
: Error Type:
: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
: object is read-only.
: Why i am getting this error?.Any one can help me?
: thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "swapna ankireddy" <swapnaankireddy@y...> on Fri, 20 Jul 2001 12:12:03
|
|
Thank u Ken Schaefer,
I solved my problem with ur clause b.
> a) You have the database open elsewhere
> b) The permissions for the IUSR_<machinename> account are not set
correctly.
> That user can not create, or cannot destory the .ldb lockfile that Access
> uses
> c) You have some other kind of exclusive blocking lock on the table in
> question (eg another user, or recordset)
> d) The recordset you are using is not updateable.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ----- Original Message -----
> From: "swapna ankireddy" <swapnaankireddy@y...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Friday, July 20, 2001 9:31 AM
> Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
Cannot
> update.
>
>
> : hi,
> : I am using ms-access as database. And i set all the properties
> : correctly.But i am not able to use update and insert commands.I am
getting
> : this type of error.
> : Error Type:
> : Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> : [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> : object is read-only.
> : Why i am getting this error?.Any one can help me?
> : thanks
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
Message #4 by "garth stewart" <garthe@q...> on Fri, 20 Jul 2001 17:00:43
|
|
> a) You have the database open elsewhere
> b) The permissions for the IUSR_<machinename> account are not set
correctly.
> That user can not create, or cannot destory the .ldb lockfile that Access
> uses
> c) You have some other kind of exclusive blocking lock on the table in
> question (eg another user, or recordset)
> d) The recordset you are using is not updateable.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ----- Original Message -----
> From: "swapna ankireddy" <swapnaankireddy@y...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Friday, July 20, 2001 9:31 AM
> Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
Cannot
> update.
>
>
> : hi,
> : I am using ms-access as database. And i set all the properties
> : correctly.But i am not able to use update and insert commands.I am
getting
> : this type of error.
> : Error Type:
> : Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> : [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> : object is read-only.
> : Why i am getting this error?.Any one can help me?
> : thanks
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
How do you change the ISUR settings? I had this problem at work and my
Admin fixed those settings and it solved the problem.
Message #5 by =?iso-8859-1?q?Med-Ali=20Hassayoun?= <mhassayoun@y...> on Sat, 21 Jul 2001 10:47:54 +0200 (CEST)
|
|
HI,
I use the same tools Access and ASP, the UPdate and
insert not working, but the message error is different
Update syntax error.
I use
please sent me a part of your code when you use update
and insert instruction and the connection too. i need
to now the difference between our codes.
thanks
--- swapna ankireddy <swapnaankireddy@y...> a
écrit : > hi,
> I am using ms-access as database. And i set all the
> properties
> correctly.But i am not able to use update and insert
> commands.I am getting
> this type of error.
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers
> (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Cannot
> update. Database or
> object is read-only.
> Why i am getting this error?.Any one can help me?
> thanks
>
Message #6 by Pappas Nikos <pappas@c...> on Sat, 21 Jul 2001 15:17:25 +0300
|
|
Check with your host read and write permissions
for the folder that contains the database.
Give IUSR permissions for that.( very important)
Cursor properties as well should be set properly I use(..... myConnection,3,3 )
A part of code that works ok follows
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
dim myConnection
dim rsTitleList
dim MyID
dim SqlString
Description = Request.Form("Description")
set myConnection = Server.CreateObject("ADODB.Connection")
set rsTitleList = Server.CreateObject("ADODB.Recordset")
myConnection.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.Mappath("../data/Sales.mdb")& ";" ,IUSR,""
MyID= request.Form("ID")
SqlString = "SELECT * FROM products WHERE ID = " & MyID
rsTitleList.open SqlString ,myConnection,3,3
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
that's what I use for edit / add new.
I hope it helps
Regards
Nikos
At 10:47 ðì 21/7/2001 +0200, you wrote:
>HI,
>
>I use the same tools Access and ASP, the UPdate and
>insert not working, but the message error is different
>
>Update syntax error.
>
>I use
>please sent me a part of your code when you use update
>and insert instruction and the connection too. i need
>to now the difference between our codes.
>
>thanks
>
>
>--- swapna ankireddy <swapnaankireddy@y...> a
>écrit : > hi,
>> I am using ms-access as database. And i set all the
>> properties
>> correctly.But i am not able to use update and insert
>> commands.I am getting
>> this type of error.
>> Error Type:
>> Microsoft OLE DB Provider for ODBC Drivers
>> (0x80004005)
>> [Microsoft][ODBC Microsoft Access Driver] Cannot
>> update. Database or
>> object is read-only.
>> Why i am getting this error?.Any one can help me?
>> thanks
>>
Message #7 by "Tomm Matthis" <matthis@b...> on Sat, 21 Jul 2001 11:33:16 -0400
|
|
Show us the code you're using to open the connection and execute the sql
inserts.
-- Tomm
> -----Original Message-----
> From: swapna ankireddy [mailto:swapnaankireddy@y...]
> Sent: Friday, July 20, 2001 9:31 AM
> To: ASP Databases
> Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
> Cannot update.
>
>
> hi,
> I am using ms-access as database. And i set all the properties
> correctly.But i am not able to use update and insert commands.I
> am getting
> this type of error.
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> object is read-only.
> Why i am getting this error?.Any one can help me?
> thanks
>
Message #8 by "swapna ankireddy" <swapnaankireddy@y...> on Mon, 23 Jul 2001 05:50:07
|
|
Thank u tomm,
now it's working properly.
> Show us the code you're using to open the connection and execute the sql
> inserts.
>
> -- Tomm
>
> > -----Original Message-----
> > From: swapna ankireddy [mailto:swapnaankireddy@y...]
> > Sent: Friday, July 20, 2001 9:31 AM
> > To: ASP Databases
> > Subject: [asp_databases] Microsoft OLE DB Provider for ODBC Drivers
> > Cannot update.
> >
> >
> > hi,
> > I am using ms-access as database. And i set all the properties
> > correctly.But i am not able to use update and insert commands.I
> > am getting
> > this type of error.
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or
> > object is read-only.
> > Why i am getting this error?.Any one can help me?
> > thanks
> >
>
Message #9 by "swapna ankireddy" <swapnaankireddy@y...> on Mon, 23 Jul 2001 05:52:55
|
|
Hi,
This is my code. Just go through this code.
set cnn=server.CreateObject("ADODB.Connection")
cnn.Open "Driver={microsoft access driver (*.mdb)};DBQ=c:\db1.mdb"
with this connection object i try to update the record.
> HI,
>
> I use the same tools Access and ASP, the UPdate and
> insert not working, but the message error is different
>
> Update syntax error.
>
> I use
> please sent me a part of your code when you use update
> and insert instruction and the connection too. i need
> to now the difference between our codes.
>
> thanks
>
>
> --- swapna ankireddy <swapnaankireddy@y...> a
> écrit : > hi,
> > I am using ms-access as database. And i set all the
> > properties
> > correctly.But i am not able to use update and insert
> > commands.I am getting
> > this type of error.
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers
> > (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] Cannot
> > update. Database or
> > object is read-only.
> > Why i am getting this error?.Any one can help me?
> > thanks
> >
|
|
|
View Cart
