|
 |
asp_database_setup thread: Internal Server Error - And Object is Read-Only
Message #1 by "JeC C" <jdcollis@b...> on Mon, 8 Jan 2001 00:08:51 -0000
|
|
I'm new to ASP, and my previous question was answered very easily by 2
great people... Thank you a lot. But this is has brought me to most
probably my final question...
My connection string works... I can view informaiton from a database, but
I cannot add things, delete things ect. I can do it on my computer. It's
obviously something to do with the server.
My Connection String is as follows.........
Set objRS = server.CreateObject("ADODB.Recordset")
objRS.open "News", strConnect, adOpenDynamic, adLockOptimistic, adCmdTable
That lets me view things...
Here's what I'm trying to do
objRS.Addnew ' Error points to this line
objRS("ID") = NewID
objRS("Date") = dateb
objRS("Title") = titleb
objRS("Main") = mainb
objRS("Dnum") = DOY
objRS("yr") = Dyear
objRS.Update
Now here's the weird thing, I submit the info to this page, and instead of
bringing up this ASP error, IE brings up a ERROR 500 INternal server
error.
I hit refresh, and ASP tells me,
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/js/admin_news.asp, line 55
What command is it to update and chagne things on an internet server? Is
it a server thing? Do I need to chuck a password in there? How?
Thank you
-JeC-
---
http://www.asptoday.com - the leading site for timely,
in-depth information for ASP developers everywhere.
---
You are currently subscribed to asp_database_setup as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_database_setup-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by "Arjan" <ajvhzn@P...> on Mon, 8 Jan 2001 22:01:31 +0100
|
|
I think you have to change the rights of the webfolder (or
database)containing your database. Because IIS sets a folder automatically
to readonly.
Arjan
----- Original Message -----
From: JeC C <jdcollis@b...>
To: ASP Database Setup <asp_database_setup@p...>
Sent: Monday, January 08, 2001 1:08 AM
Subject: [asp_database_setup] Internal Server Error - And Object is
Read-Only
> I'm new to ASP, and my previous question was answered very easily by 2
> great people... Thank you a lot. But this is has brought me to most
> probably my final question...
>
> My connection string works... I can view informaiton from a database, but
> I cannot add things, delete things ect. I can do it on my computer. It's
> obviously something to do with the server.
>
> My Connection String is as follows.........
>
> Set objRS = server.CreateObject("ADODB.Recordset")
> objRS.open "News", strConnect, adOpenDynamic, adLockOptimistic, adCmdTable
>
> That lets me view things...
>
> Here's what I'm trying to do
>
> objRS.Addnew ' Error points to this line
> objRS("ID") = NewID
> objRS("Date") = dateb
> objRS("Title") = titleb
> objRS("Main") = mainb
> objRS("Dnum") = DOY
> objRS("yr") = Dyear
> objRS.Update
>
> Now here's the weird thing, I submit the info to this page, and instead of
> bringing up this ASP error, IE brings up a ERROR 500 INternal server
> error.
>
> I hit refresh, and ASP tells me,
>
> Microsoft JET Database Engine error '80040e09'
>
> Cannot update. Database or object is read-only.
>
> /js/admin_news.asp, line 55
>
> What command is it to update and chagne things on an internet server? Is
> it a server thing? Do I need to chuck a password in there? How?
>
> Thank you
>
> -JeC-
>
---
http://www.asptoday.com - the leading site for timely,
in-depth information for ASP developers everywhere.
---
You are currently subscribed to asp_database_setup as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_database_setup-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
