473,890 Members | 5,293 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

IIS5 > IIS6 Aspx pages with MSAccess dbs no longer working

Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx
which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database
or object is read-only."

After numerous assurances from our webhost that they have set anonymous user
write access for both the /fpdb folder and the individual databases we still
get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed
below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx
with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark



Nov 19 '05 #1
14 2501
Hi,

Try enclosing rs.addnew is a try catch block to get a better
error message. Sql server is much better for the web than access. MSDE is
a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en

Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx
which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database
or object is read-only."

After numerous assurances from our webhost that they have set anonymous user
write access for both the /fpdb folder and the individual databases we still
get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed
below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx
with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark


Nov 19 '05 #2
Hi,

Try enclosing rs.addnew is a try catch block to get a better
error message. Sql server is much better for the web than access. MSDE is
a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en

Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx
which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database
or object is read-only."

After numerous assurances from our webhost that they have set anonymous user
write access for both the /fpdb folder and the individual databases we still
get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed
below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx
with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET
Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark


Nov 19 '05 #3
I did that and it didn't catch the rs.addnew error -- it just breezed
through it and then gave the same error but for the next statement:

Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 221:
Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Line 223: if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )
Line 224: if Request("Compan y") <> "" then rs("Organizatio n")=
Request("Compan y")




"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:OV******** ******@tk2msftn gp13.phx.gbl...
Hi,

Try enclosing rs.addnew is a try catch block to get a better error message. Sql server is much better for the web than access. MSDE is a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en
Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database or object is read-only."

After numerous assurances from our webhost that they have set anonymous user write access for both the /fpdb folder and the individual databases we still get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):
Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark



Nov 19 '05 #4
I did that and it didn't catch the rs.addnew error -- it just breezed
through it and then gave the same error but for the next statement:

Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 221:
Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Line 223: if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )
Line 224: if Request("Compan y") <> "" then rs("Organizatio n")=
Request("Compan y")




"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:OV******** ******@tk2msftn gp13.phx.gbl...
Hi,

Try enclosing rs.addnew is a try catch block to get a better error message. Sql server is much better for the web than access. MSDE is a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en
Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database or object is read-only."

After numerous assurances from our webhost that they have set anonymous user write access for both the /fpdb folder and the individual databases we still get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):
Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark



Nov 19 '05 #5
MarkB i have had also such experience using MS ACCESS!!
If possible try using SQLServer as Ken adviced..
I would hint you with some fixes...
1) Have you given the MS ACCESS files the right permission make sure the you
give the ASPNET acct permission
Or even if possible the the FOLDERS where the MDB files exist.(Give it
write, read etc..
2)Whenever you open and MDB file is sometimes locks it and creates a LDF
file if i can remember
3)With Win2003 i think you have to give the FOLDER or your MDB files the
Network service acct the right permission look ath this blog for that
http://forums.asp.net/869604/ShowPost.aspx
Hope that helps
Patrick


"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database or object is read-only."

After numerous assurances from our webhost that they have set anonymous user write access for both the /fpdb folder and the individual databases we still get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):
Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark


Nov 19 '05 #6
MarkB i have had also such experience using MS ACCESS!!
If possible try using SQLServer as Ken adviced..
I would hint you with some fixes...
1) Have you given the MS ACCESS files the right permission make sure the you
give the ASPNET acct permission
Or even if possible the the FOLDERS where the MDB files exist.(Give it
write, read etc..
2)Whenever you open and MDB file is sometimes locks it and creates a LDF
file if i can remember
3)With Win2003 i think you have to give the FOLDER or your MDB files the
Network service acct the right permission look ath this blog for that
http://forums.asp.net/869604/ShowPost.aspx
Hope that helps
Patrick


"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database or object is read-only."

After numerous assurances from our webhost that they have set anonymous user write access for both the /fpdb folder and the individual databases we still get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):
Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark


Nov 19 '05 #7
Hi,

Any way you could update you code to use ado.net instead of ado?

Ken
----------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:ue******** *****@TK2MSFTNG P09.phx.gbl...
I did that and it didn't catch the rs.addnew error -- it just breezed
through it and then gave the same error but for the next statement:

Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 221:
Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Line 223: if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )
Line 224: if Request("Compan y") <> "" then rs("Organizatio n")=
Request("Compan y")




"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:OV******** ******@tk2msftn gp13.phx.gbl...
Hi,

Try enclosing rs.addnew is a try catch block to get a better error message. Sql server is much better for the web than access. MSDE is a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en
Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database or object is read-only."

After numerous assurances from our webhost that they have set anonymous user write access for both the /fpdb folder and the individual databases we still get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):
Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark




Nov 19 '05 #8
Hi,

Any way you could update you code to use ado.net instead of ado?

Ken
----------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:ue******** *****@TK2MSFTNG P09.phx.gbl...
I did that and it didn't catch the rs.addnew error -- it just breezed
through it and then gave the same error but for the next statement:

Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 221:
Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Line 223: if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )
Line 224: if Request("Compan y") <> "" then rs("Organizatio n")=
Request("Compan y")




"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:OV******** ******@tk2msftn gp13.phx.gbl...
Hi,

Try enclosing rs.addnew is a try catch block to get a better error message. Sql server is much better for the web than access. MSDE is a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en
Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight.
They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at
http://www.orbisoft.com/products/tas...t-version.aspx which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update. Database or object is read-only."

After numerous assurances from our webhost that they have set anonymous user write access for both the /fpdb folder and the individual databases we still get the same error. They say it is our fault in that there is something in
our code that isn't right. They say the have another user where their aspx
pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error listed below that. You also are welcome to test the page at
http://www.orbisoft.com/products/tas...t-version.aspx with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew line):
Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in
D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300; ASP.NET Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark




Nov 19 '05 #9
I have created an ultra-simple database and aspx test page at:
http://www.orbisoft.com/products/tas...hase/test.aspx
to illustrate that it is still a Windows 2003 Server permissions issue:

The aspx page HTML is simply:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">
<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="Syst em.Globalizatio n"%>

<%
Dim sPath as String, conn, rs
sPath = "D:\inetpub\www \orbisoft\fpdb\ db12.mdb"
conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Data Source=" & sPath)
rs = server.createob ject("adodb.rec ordset")
rs.open ("Table1", conn, 2, 2)
rs.addnew
rs.update
%>
It still gives the same error message "Cannot update. Database or object is
read-only."

Ken - Do you know what the ADO.NET for the above sample would be?

"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:Og******** ******@TK2MSFTN GP15.phx.gbl...
Hi,

Any way you could update you code to use ado.net instead of ado?

Ken
----------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:ue******** *****@TK2MSFTNG P09.phx.gbl...
I did that and it didn't catch the rs.addnew error -- it just breezed
through it and then gave the same error but for the next statement:

Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 221:
Line 222: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Line 223: if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )
Line 224: if Request("Compan y") <> "" then rs("Organizatio n")=
Request("Compan y")




"Ken Tucker [MVP]" <vb***@bellsout h.net> wrote in message
news:OV******** ******@tk2msftn gp13.phx.gbl...
Hi,

Try enclosing rs.addnew is a try catch block to get a

better
error message. Sql server is much better for the web than access. MSDE

is
a free version of sql server.

Try
rs.addnew
catch ex as exception
Response.write( ex.tostring)
end try

http://www.microsoft.com/downloads/d...displaylang=en

Ken
---------------------
"Mark B" <mb*******@Dele te-All-X-XorbisofXXt.com > wrote in message
news:eV******** *****@TK2MSFTNG P09.phx.gbl...
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a
scheduled hard-boot occurred during a ms-security patch install overnight. They couldn't get the server working again so they transferred our site
www.orbisoft.com to a new W2003 IIS6 server they set up.

That was a week ago.

Since that transfer, all of our ASPX pages that use Access2000 databases
have stopped working.

Our main one is our "buy" page at

http://www.orbisoft.com/products/tas...t-version.aspx
which means potential customers can't purchase there.

I have shown the error below which essentially says "Cannot update.

Database
or object is read-only."

After numerous assurances from our webhost that they have set anonymous

user
write access for both the /fpdb folder and the individual databases we

still
get the same error. They say it is our fault in that there is something in our code that isn't right. They say the have another user where their aspx pages with MSAccess are working. I said "but all aspx pages were working
fine on IIS5...."

"Line 211: rs.addnew" below is the where the error is highlighted.

The actual relevant code snip-it is as follows with the runtime error

listed
below that. You also are welcome to test the page at

http://www.orbisoft.com/products/tas...t-version.aspx
with a junk order too - I won't hold you to it:

<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN">

<%@Page aspcompat=true Language = VB Debug="true"%>
<%@Import Namespace="aspN etEmail"%>
<%@Import Namespace="Syst em.Data"%>
<%@Import Namespace="Syst em.Data.OleDb"% >
<%@Import Namespace="aspN etMX"%>
<%@Import Namespace="Syst em.Globalizatio n"%>

<script language="VB" runat="server">

Dim strFirstName as String
Dim strLastName as String
Dim strExisting as String
Dim strNumberUsers as String
Dim strCompany as String
Dim strTitle as String
Dim strEmailAddress as String
Dim strAddress as String
Dim strCity as String
Dim strState as String
Dim strZip as String
Dim strCountry as String
Dim strTelephone as String
Dim strIndustry as String
Dim strOtherIndustr y as String
Dim strWHSpecific as String
Dim strComment as String
Dim strPromoCode as String
Dim strProductName as String
Dim dblQuantity as Double
Dim dblProductPrice as Double
Dim dblExtension as Double
Dim dblPromotionalC odeSavings as Double
Dim dblTotalUSD as Double
Public Function strProper(strRa w as String) As String
Dim currentTextInfo
currentTextInfo = CultureInfo.Cur rentCulture.Tex tInfo
strProper = currentTextInfo .ToTitleCase(st rRaw)
End Function

Function bolStoreEntries ()
'Store entries temporarily for populating after validation fail
'************** *************** *************** *************** ***
strFirstName = Request("FirstN ame")
strLastName = Request("LastNa me")
strExisting = "No"
strNumberUsers = Request("Number Users")
strCompany = Request("Compan y")
strTitle = Request("Title" )
strEmailAddress = Request("EmailA ddress")
strAddress = Request("Addres s")
strCity = Request("City")
strState = Request("State" )
strZip = Request("Zip")
strCountry = Request("Countr y")
strTelephone = Request("Teleph one")
strIndustry = Request("Indust ry")
strOtherIndustr y = Request("OtherI ndustry")
strWHSpecific = Request("WhereH eard")
strComment = Request("Commen t")
End Function
</script>
<%
Dim bolErr as Boolean
bolStoreEntries
fCalculatePrice s
If Request("OrderN ow") <> "" Then

'Save to database
'************** **
Dim strHTML as String
Dim strlf as String
Dim strS1 as String
Dim strS2 as String
Dim strS3 as String
Dim strErr as String
Dim bSuccess as Boolean
Dim sPath as String
Dim conn
Dim rs
Dim lngInvoiceNumbe r as Long
Dim lngInvoiceRefer ence as Long

sPath = "D:\inetpub\www \orbisoft\fpdb\ dbOnlineOrders. mdb"

conn = Server.CreateOb ject("ADODB.Con nection")
conn.open ("Provider=Micr osoft.Jet.OLEDB .4.0;" & "Persist Security
Info=TRUE;" & "Data Source=" & sPath, "Admin", "")
rs = server.createob ject("adodb.rec ordset")
rs.open ("tblOrders" , conn, 2, 2)
rs.addnew

if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
if Request("LastNa me") <> "" then rs("LastName") =
strProper(Reque st("LastName") )

etc...



And here's the error it now gives (falling over on the 211 rs.addnew

line):

Server Error in '/' Application.

Cannot update. Database or object is read-only.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Runtime. InteropServices .COMException: Cannot
update. Database or object is read-only.

Source Error:

Line 209: rs.open ("tblOrders" , conn, 2, 2)
Line 210:
Line 211: rs.addnew
Line 212:
Line 213: if Request("FirstN ame") <> "" then rs("FirstName") =
strProper(Reque st("FirstName") )
Source File:

D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x Line: 211

Stack Trace:

[COMException (0x80040e09): Cannot update. Database or object is
read-only.]

Microsoft.Visua lBasic.Compiler Services.LateBi nding.InternalL ateCall(Object o, Type objType, String name, Object[] args, String[] paramnames,

Boolean[]
CopyBack, Boolean IgnoreReturn) +798
Microsoft.Visua lBasic.Compiler Services.LateBi nding.LateCall( Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack) +23
ASP.order_detai ls_aspx.__Rende r__control1(Htm lTextWriter __output,
Control parameterContai ner) in

D:\Inetpub\www\ orbisoft\produc ts\taskmanager\ 2005\purchase\o rder-details.asp
x:211
System.Web.UI.C ontrol.RenderCh ildren(HtmlText Writer writer) +27
System.Web.UI.C ontrol.Render(H tmlTextWriter writer) +7
System.Web.UI.C ontrol.RenderCo ntrol(HtmlTextW riter writer) +243
System.Web.UI.P age.ProcessRequ estMain() +1926
Version Information: Microsoft .NET Framework Version:1.1.432 2.2300;

ASP.NET
Version:1.1.432 2.2300
Any ideas very much appreciated ....

Mark




Nov 19 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
3753
by: John Chertudi | last post by:
We are poised to migrate about 600 ASP sites from a single IIS5 server to a new pair of IIS6 servers. However, it appears that all files with includes like: <!-- #include virtual="../../includes/file.asp" --> will not work on IIS 6, it returns ASP 0126, include file not found. We have enabled parent paths, but I can't find any documentation that suggests that IIS 6 handles include directives differently than IIS 5.
1
1643
by: Naga Kiran | last post by:
Hi I have a small query in ASP.Net on windows2003 server platform.. I built an Application in ASP.Net.... This application is hosted on the system where that system has Windows2003 Operating system (with IIS6.0). In my application relative paths are not working after hosting in windows 2003 system(IIS6.0). When the application was on windows2000prof, it worked fine. But only after migrating to windows2003(IIS6.0), it stopped working.
4
2375
by: JK | last post by:
We recently installed our web application on Windows 2003 and found that our ASPX pages are not coming up correctly. We are using sessionstate=StateServer and cookieless=true for Web.config. Applications run perfectly in Windows2000 or XP but in Windows2003 under IIS6 we do not see any of our images and style sheets applied. This is because sessionid is added to the web path and IIS is not able to access it How can we make this working in...
0
1339
by: Mark B | last post by:
Our webhost (www.usbusinessweb.net) had a W2K IIS5 server crash after a scheduled hard-boot occurred during a ms-security patch install overnight. They couldn't get the server working again so they transferred our site www.orbisoft.com to a new W2003 IIS6 server they set up. That was a week ago. Since that transfer, all of our ASPX pages that use Access2000 databases have stopped working.
0
1012
by: Dariusz Tomon | last post by:
Hello My problem is like that: I have got IIS 5.0 server (WIN2000) with a lot of services written in ASP. Now we'd like to move to new machine with win2003 (IIS6). I heard that there are a couple of problems with that migration - I mean old asp pages need some tailoring when moving to new IIS6. I also know about IIS isolation mode but the problem occured because I have got Microsoft CMS installed on the new machine and it's impossible...
5
2292
by: Terry Strachan | last post by:
Hi, I have an asp.net webapp that works fine on my development machine, win2k/iis5 however, when I move the site across to win2k3 / iis6 i get the following error on postback of any page; *------------------------------------------* Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information
0
1174
by: Brian | last post by:
I have an ASP.NET 1.1 application that does URL rewriting via a custom HttpModule. We recently migrated this application from Win2k/IIS5 to Win2k3/IIS6. In IIS5, I added a wildcard application map that filtered the verbs I wanted to handle. In IIS6, the wildcard application is added differently and it doesn't allow for verb filtering. How can I do the same sort of filtering in IIS6? Thanks! -Brian
1
2667
by: Luwk | last post by:
I have an application that communicates with the Company's Active Directory to get the OU of the users. This said application is an ASP.Net web site and has the Windows Authentication enabled. . Now, here's the anomaly: If the application is run on a Server using IIS 5.1, the application works like a charm and the communcation with the Active Directory occurs without any problem.
7
2798
by: Electric Co. | last post by:
Hello, note: This is for a Faculty web site that is undergoing a migration to an open source solution so my motives are legit. I need to build a relay from IIS handling URL_A to a PHP server (URL_B), get the content from the PHP server (if it exists) and then serve it out via IIS. If the content does not exist then I need to pass the request through to the IIS server and serve the pages from there. All of this needs to be done...
4
3435
by: S.Tedeschi | last post by:
Hi all guru, for sure I'm too old for a bunch of no-sleep-nights. M$' drivin' me nut. Switching my ASP.NET 1.1 apps to 2.0 has made me tryin' for several days with no success. -My IIS5.1 (Xp Media Center, SP2) refuses to serve even the simplest aspx page (1 button + 1 textBox), rendering only "Server Application Error The server has encountered an error while loading an application during the processing of your request"
0
9979
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9823
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10827
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10924
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10463
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9637
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
8017
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7170
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5854
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.