473,394 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

Error ADODB.Connection error '800a0bb9' line 16

I'm getting above error on line 16 which is IF objRS.EOF THEN. I'm trying to create a forgotten password form. where user enter his/her email and will send a link to reset the password. Here is where I stuck. please help


Expand|Select|Wrap|Line Numbers
  1.     <%
  2.     DIM strUsername
  3.     strUsername = Request.Form("Username")
  4.     IF strUsername <> "" THEN
  5.     %>
  6.  
  7.     <!--#inlcude file="confirm_test.asp"-->
  8.  
  9.     <%
  10.     DIM mySQL, objRS, rs 
  11.     Set objRS = Server.CreateObject("ADODB.Connection")
  12.     objRS.Open "Provider=MSDASQL.1;Password=****;Persist Security Info=True;User ID=****;Data Source=****"  
  13.     mySQL = "SELECT username, email_addr, medacist_password  FROM medacist_user WHERE username = '" & strUsername & " ' "
  14.     Set rs = objRS.Execute(mySQL)
  15.  
  16.     IF objRS.EOF THEN
  17.     Response.Write "<div align='center'>Sorry, that username does not exist. Please click back on your browser and enter a different username.</div>"
  18.  
  19.     ELSE
  20.     %>
  21.  
  22.     <form name="UpdatePassword" method="post" action="reset_form.asp">
  23.     <table>
  24.     <tr><td>Username:</td><td>
  25.     <input type="text" name="Username" size="50" value='<%=objRS("Username")%>'>
  26.     </td></tr>
  27.     <tr><td>Password:</td><td>
  28.     <input type="text" name="Password" size="50" value='<%=objRS("Password")%>'>
  29.     </td></tr>
  30.     </table>
  31.     <input type="submit" name="Submit" value="Reset">
  32.     </form>
  33.  
  34.     <%
  35.     END IF
  36.  
  37.     objRS.Close
  38.     Set objRS = Nothing
  39.     %>
  40.  
  41.     <%
  42.     ELSE
  43.     Response.Write "Please click back on your browser and enter your username."
  44.     END IF
  45.     %>
  46.  
  47.  
Jan 8 '15 #1
0 2534

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: DC | last post by:
Im getting the error ADODB.Fields error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. In the following script to copy and...
1
by: June Moore | last post by:
Hi, I am getting an error with the following code. Error is: ADODB.Connection error '800a0e78' - The operation requested by the application is not allowed if the object is closed. Any ideas how...
2
by: wolverine1654 | last post by:
I have an application that we are moving to a 2003 server using IIS6. Currently, it works fine with IIS5 on a NT server. When I try to log into the application and connect to an Oracle DB, I get...
1
by: PJ | last post by:
I'm getting an error message when posting information from my asp page to the database. This is the error message: DODB.Connection error '800a0e7c' Parameter object is improperly defined....
1
by: Steven Baeten | last post by:
Hi All, I'm running a webpage-application where, in a aspx-page,a udl is called in vbscript in an xsl-stylesheet to access a database. When I want to execute this, I receive following error...
1
by: DragonFields | last post by:
I'm hoping someone can help me. I keep receiving the ADODB.Command error '800a0cc1' error (Item cannot be found in the collection corresponding to the requested name or ordinal.) I found a couple...
4
nitindel
by: nitindel | last post by:
Hi All, I am using DbCom Handler for my DataBase Connectivity. But the Query is not firing i.e recordset is not getting populated... it is Showing the error as follows: ...
0
by: dgil2004 | last post by:
I am a real newbie when it comes to scripting, coding, etc We have a site were people go and load text documents. I can load the text document fine with no problems. But someone from another...
7
by: simonruk1 | last post by:
Hi I am new to ASP and I am getting this error: ADODB.Connection error '800a0e78' Operation is not allowed when the object is closed. /members/asp/util.asp, line 67 the code line in...
3
gauravgmbhr
by: gauravgmbhr | last post by:
Hi All, I am trying to open a binary stream from a file and the creating a new stream from the opened stream and then trying to over wright the file and i am getting the following error ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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...
0
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...
0
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...

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.