| fsdf on Apr 12, 2002 at 5:02:36 AM | Rating: 2 |
| kwizu on Mar 29, 2002 at 11:20:23 AM | No Rating |
I got the following error message when I submit a Join.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Too many arguments were supplied for procedure sp_adduser.
/membership/members/join.asp, line 69
|
| rphelan on Mar 7, 2002 at 8:44:48 AM | Rating: 5 |
Everything works great...good work..
Great for the beginner |
| rphelan on Mar 6, 2002 at 3:28:57 AM | Rating: 2 |
Error Type:
Active Server Pages, ASP 0126 (0x80004005)
The include file '/inc/utility.asp' was not found.
/register/members/join.asp, line 21
How can I get over this error.
I unzipped the files as described, but when I run the demo I get the above error!
Please help |
| Fantaman on May 29, 2001 at 11:14:00 PM | No Rating |
I've got this message:
Home Page : User Manager
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The request for procedure 't_user' failed because 't_user' is a table object.
/inc/utility.asp, line 95
|
| cciko on May 14, 2001 at 7:48:00 AM | Rating: 4 |
Very good for newbies, it explains each step with discriptions. |
| colinyan on Dec 20, 2000 at 6:27:01 PM | Rating: 1 |
-
|
| oanhlu on Dec 14, 2000 at 3:26:12 PM | No Rating |
| Thanks for useful info with complete source code. I haven' t try it yet, however the explanation is clear to me. Thanks again. |
| SimonGibson on Dec 13, 2000 at 7:40:08 AM | Rating: 5 |
I thought this article gave a clear explaination of the technique. Some of the techniques demonstrate maintainabilty of code by using functions for the commonly used elements such as the connection string.
Well Done! |
| louisF on Sep 12, 2000 at 10:31:43 AM | Rating: 5 |
I also had a problem with the inc file. I noticed that my DSN was not setup correctly. I got the code to work fine.
Great article SE staff! |
| btado on Sep 11, 2000 at 3:18:13 PM | Rating: 5 |
Using the utility.asp, I'm having problems appending a numeric datatype:
oCmd.Parameters.append oCmd.CreateParameter("FLR_I", adNumeric, adParamInput,5,Request.Form("FLR_I"))
Is there something special that needs to be passed to SQL for a adNumeric datatype parameter?
Any help would be greatly appreciated. |
| eddiebt on Jul 13, 2000 at 3:34:44 AM | No Rating |
Very clear, easy to follow - have yet to implement so cannot comment on robust issues, but could not see anything glaringly at fault.
Two questions.
Where does u_password2 come in?
And regarding validation, will you be doing anything on the database side. I'm interested because I wrote an ASP validation script for a similar project, which worked (i.e. returned errors) but I could not stop the content from being written to the DB.
Eddie
|
| Tmalik on May 12, 2000 at 6:22:27 AM | Rating: 5 |
| My email IDhttp://www.siteexperts.com/paradise/getResource.asp?r_id=1337 tushir_malik@hotmail.com |
| Tmalik on May 12, 2000 at 6:18:17 AM | Rating: 5 |
Excellent to learn...I'm using ASP for the first time, can anybody send me the html pages or forms used.
I understood the concept but don't know how exactly I can call the asp pages. Help me!! |
| gustavol on Apr 21, 2000 at 7:56:59 PM | Rating: 5 |
| jsani on Feb 10, 2000 at 2:43:05 AM | Rating: 4 |
This is a great Example, but there seems to be a problem with implemetation of the demo. I have followed the instructiosn to a tee, setup the db, DSN, modified the Utility.asp file to reflect the correct username and password, but everytime I run the join.asp, I get the following error:
ADODB.Connection error '800a0e7a'
ADO could not find the specified provider.
/membership/inc/utility.asp, line 81
I can establish the ADO connection from the ODBC test dialog no problem, but the code is unhappy. |
| juststeve on Dec 20, 1999 at 7:42:41 AM | Rating: 3 |
There are typeos in the code contained in the article body....would be good to be alerted to the zip file at the _beginning of the article.
So far, I've created all the db objects...now, when running join.asp I'm getting an error on the cmd.execute(statement) in the utility.asp.
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/paula_masters/_inc/utility.asp, line 27
Executes are tricky deals...lots can go wrong. How do I go about troubleshooting this?
|
| som300 on Dec 8, 1999 at 10:22:57 AM | Rating: 4 |
| Sounds difficult but very useful. |
| kramik on Oct 28, 1999 at 3:08:36 PM | Rating: 5 |
It worked quite well after wrestling with the inc/utility.asp username and password and adding this user to SQL User Login security accounts, and assigning write permissions to the to the table to this user.
This was a good example. I would that I had the time to modify to be usable.
I would like to see a basic ASP template for Querying a database, and updating a database. Similar to how dbWeb provided a tool to query, insert, delete, or modify databases. If anyone knows of a good tool, or ASP sample, I would appreciate it (Drumbeat, NebObject, FrontPage are no good; InterDev is too complicated; dbWeb causes server crashes).
keith@kramis.com |
| swarrick on Oct 26, 1999 at 6:11:22 AM | Rating: 4 |
|
I have not directly used this code, but have used very similar mechanisms in the past. All have worked well and I am glad to see that my approach has been similar to that here.
A particular problem worth noting - if one is using the identity column in anyway - it is not always easy to get at it in ASP just after the record has been added. It took me a long time with the ADO manuals to figure out how to get it!
A useful extension to this is to use the identity or some other unique value as a cookie - thus returning visitors can be readily welcomed back by name....!
Simon |
| andrepublic on Oct 21, 1999 at 9:27:53 AM | Rating: 4 |
ERROR MESSAGE -- too many arguments
for stored procedure sp_adduser
I loaded all the files - yet, when
I run join.asp -- I get an error
message for sp_adduser.
can anyone figure out why this is
happening just to me? |
| swazi on Oct 11, 1999 at 9:28:58 PM | No Rating |
Hi Scotts,
I was already did to add a DSN name "membershipdb" and i already change the utility.asp from getConnection function to match the DSN I've created on ODBC and I test my connection on ODBC after I assigned the DSN name which is mebershipdb and it was succesfully connected and I use an sa as my username and passowrd was blank to connect on my SQL server..
But it is still same error Login Failed..
Why help me..you can try to browser the error at this site
http://203.177.8.36/membership/
Please help me I would highly appreciate your help in advance.. I need to run this registration program I will use this on our intranet site..
Thanxs Scott...
|
| davidfreibrun on Oct 9, 1999 at 6:10:52 AM | Rating: 5 |
I liked the article on creating membership very much.. Could the author speak more to the limitations in this approach?
What kind of scalability problems could I run into if I built my membership database this way? Why do people use LDAP, AUO, and other Site Server components to do this when they can use this solution? |
| Scott Isaacs on Oct 8, 1999 at 7:58:16 AM | No Rating |
You need to create a DSN. After creating it, go to utilities.inc and change the values in getConnection to match the DSN you created.
Scott |
| swazi on Oct 8, 1999 at 2:55:14 AM | Rating: 5 |
Please help me I got problem on implimenting this applications and I always get an error of "Login Failed"
Do I need to as DSN which name is mebershipdb?
Help
|
| sangle on Oct 7, 1999 at 8:11:34 AM | Rating: 5 |
| Excellent articles and a good starting point for user registration. |
| eappell on Sep 29, 1999 at 11:02:11 AM | Rating: 5 |
I'm trying to implement this, but I keep getting this error when I try to join:
ADODB.Command error '800a0bb9'
The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.
/login/utility.asp, line 26
Here's line 26: oCmd.CommandType = adCmdStoredProc
Help? |
| eappell on Sep 28, 1999 at 4:16:21 PM | Rating: 5 |
Excellent article. Can someone tell me, is there an article for SQL beginner's on how to run the scripts included in the article to create the databases? I can't find that feature in the docs...
Thanks! |
| dmartini on Sep 28, 1999 at 9:51:00 AM | Rating: 5 |
| Very good article. Thanks. |
| ifiok on Sep 21, 1999 at 1:03:47 PM | Rating: 5 |
| good article |
| safranek on Sep 21, 1999 at 12:21:29 AM | Rating: 5 |
| very good :-)) |
| bambang on Sep 12, 1999 at 8:01:29 AM | Rating: 5 |
| very good. gives me a clear understanding about what happens behind a site registration. |
| kypark on Sep 10, 1999 at 9:33:45 AM | No Rating |
| test |
| dhughes on Sep 7, 1999 at 12:47:41 PM | Rating: 5 |
| Excellent way to get your feet wet. |
| osmangazi on Sep 7, 1999 at 10:04:39 AM | Rating: 5 |
| very good intro |
| MJohn on Sep 7, 1999 at 5:26:00 AM | Rating: 4 |
| Good intro |
| Ueli on Sep 7, 1999 at 12:31:30 AM | Rating: 4 |
| Good intro into the topic. |
| 2bit on Sep 6, 1999 at 1:46:59 AM | Rating: 5 |
Great article. Thanks a lot. |
