 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|
|
August 15th, 2007, 02:58 AM
|
|
Authorized User
|
|
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Urgent :ASP code and Database
Why I face the problem that is the "rsUsers.AddNew" can not update. Database or object is read-only. ???
Coding as below:
Dim rsUsers
Set rsUsers = Server.CreateObject("ADODB.Recordset")
rsUsers.Open "Db", objConn, adOpenForwardOnly, adLockOptimistic, adCmdTable
If Session("PersonID") <> "" Then ' currently logged-on user
rsUsers.Filter = "PersonID = '" & Session("PersonID") & "'"
Else ' New session
rsUsers.Filter = "GivenName = '" & Request.Form("GivenName") & "'" & _
"AND Password = '" & Request.Form("Password") & "'"
If rsUsers.EOF Then ' User not found
rsUsers.AddNew ' ...so add a new record
Please teach me... 
|
|
August 15th, 2007, 03:17 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
|
|
August 17th, 2007, 09:53 PM
|
|
Authorized User
|
|
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Sorry...actually I do not understand about the web said ,so can you briefly tell me what should I do for now???
Thank you.
|
|
August 19th, 2007, 03:04 PM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Eum, not really. The error message you get seems to suggest you have a permissions problem. The article I linked to explains in very clear steps what to do to fix the error.
If you don't understand that article, I am afraid you won't understand my explanation either.
What is it you don't understand? Where you need to apply this? Or why? Or how?
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
|
|
September 14th, 2007, 02:24 AM
|
|
Authorized User
|
|
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Athough I follow all your stay,I just can run it at my computer only.I still can not run it at my server.Why?Or you still got any solution to give solve it?
Waiting for your advice...
Thank you.
|
|
September 14th, 2007, 05:48 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
The FAQ should really solve your problem...
Since it didn't, you probably didn't follow it correctly.
Maybe you should start by providing more info. E.g, Windows version, the account you configured, folder setup and so on.
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
|
|
September 18th, 2007, 04:52 AM
|
|
Authorized User
|
|
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
The previous question, I want to know that is it correct for the pattern of group or user names(it is Internet Guest Account (LKI\IUSR_PSF-95J565R66X))???
Because I already follow all the steps...but still can not run it.
Now I face a problem which is if I not login to the page ,but I still can download the thing which are from the web site.
So could you provide me any coding or method to prevent it happen???
Waiting for your advice...
Thank you.
|
|
September 18th, 2007, 10:38 AM
|
|
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
You can wait for advice for ever if you don't supply relevant data about your system. So, again:
Maybe you should start by providing more info. E.g, Windows version, the account you configured, folder setup and so on.
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
|
|
September 18th, 2007, 09:16 PM
|
|
Authorized User
|
|
Join Date: Jun 2007
Posts: 87
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Yes.Actually my thing(Windows version, the account you configured, folder setup and so on) are same with the page which is you provided to me.But I still can not make it.So I ask you that whether my group or username correct or not?
Sorry, I just learn the language from book and touch the server side's things. So maybe I got a lots of thing which are I did not know how to do. Please teach me.
Waiting for your advices...
Thank you.
|
|
|
