|
 |
asp_databases thread: error '80040e21'
Message #1 by "Eric Van Camp" <eric.vancamp@c...> on Tue, 28 Nov 2000 22:49:45 -0000
|
|
Hello,
i got this message on an asp page...
although i included adovbs.inc, to define adLockOptimistic,adOpenDynamic,
i inserte a connections string and defined and opened it,
i defined and opened a recordset..
what is going on?
<body text="#FFFFFF" link="#0000A0" vlink="#0000A0" alink="#0000A0"
bgcolor="#FFFFFF">
select * from BFORMS <font face="Arial" size=2>
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial"
size=2>error '80040e21'</font>
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 29 Nov 2000 12:26:18 +1100
|
|
What is the error message?
----- Original Message -----
From: "Eric Van Camp" <eric.vancamp@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, November 29, 2000 6:24 PM
Subject: [asp_databases] error '80040e21'
> Hello,
> i got this message on an asp page...
> although i included adovbs.inc, to define adLockOptimistic,adOpenDynamic,
> i inserte a connections string and defined and opened it,
> i defined and opened a recordset..
> what is going on?
> <body text="#FFFFFF" link="#0000A0" vlink="#0000A0" alink="#0000A0"
> bgcolor="#FFFFFF">
> select * from BFORMS <font face="Arial" size=2>
> <p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial"
> size=2>error '80040e21'</font>
>
Message #3 by Stephane_Dattenny@D... on Wed, 29 Nov 2000 01:41:00 -0600
|
|
Can you give use the ASP server side code ?
Best regards / Cordialement
Stephane Dattenny
Dell Computers - EMEA IT - VB and Web developer
Phone: +33 (0)4 99 75 49 88
-----Original Message-----
From: Eric Van Camp [mailto:eric.vancamp@c...]
Sent: 29 November 2000 08:25
To: ASP Databases
Subject: [asp_databases] error '80040e21'
Hello,
i got this message on an asp page...
although i included adovbs.inc, to define adLockOptimistic,adOpenDynamic,
i inserte a connections string and defined and opened it,
i defined and opened a recordset..
what is going on?
<body text="#FFFFFF" link="#0000A0" vlink="#0000A0" alink="#0000A0"
bgcolor="#FFFFFF">
select * from BFORMS <font face="Arial" size=2>
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial"
size=2>error '80040e21'</font>
Message #4 by "Eric Van Camp" <eric.vancamp@c...> on Wed, 29 Nov 2000 08:18:44 -0000
|
|
the error message is displayed hereunder...
the erro 80040e21 microsoft ole db Provider for ODBC Drivers
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, November 29, 2000 1:26 AM
To: ASP Databases
Subject: [asp_databases] Re: error '80040e21'
What is the error message?
----- Original Message -----
From: "Eric Van Camp" <eric.vancamp@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, November 29, 2000 6:24 PM
Subject: [asp_databases] error '80040e21'
> Hello,
> i got this message on an asp page...
> although i included adovbs.inc, to define adLockOptimistic,adOpenDynamic,
> i inserte a connections string and defined and opened it,
> i defined and opened a recordset..
> what is going on?
> <body text="#FFFFFF" link="#0000A0" vlink="#0000A0" alink="#0000A0"
> bgcolor="#FFFFFF">
> select * from BFORMS <font face="Arial" size=2>
> <p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial"
> size=2>error '80040e21'</font>
>
Message #5 by "Eric Van Camp" <eric.vancamp@c...> on Wed, 29 Nov 2000 11:35:34 -0000
|
|
here it is..again
<% response.buffer = true %>
<!--#include virtual="includes/adovbs.inc" -->
<!--#include virtual="includes/tools_ameel.inc"-->
<html>
<head>
<title><%=storename%> Maintenance</title>
<!--#include virtual="includes/sysadmin.inc"-->
<%
rem create a sso to provide link to the database
set conn = Server.CreateObject("ADODB.Connection")
rem set connect info
conn.Connectionstring = "DSN=" & application("OdbcConname") & ";UID=" &
application("OdbcUsername") & ";PWD=" & application("OdbcPassword")
rem open the connection
conn.open
%>
</head>
<body text="#FFFFFF" link="#0000A0" vlink="#0000A0" alink="#0000A0"
bgcolor="#FFFFFF">
<%
temp1 = request.form("qsi")
rem make ADO recordset
Set rsbforms = Server.CreateObject("ADODB.Recordset")
SQL = "select * from bforms"
response.write sql
rsbforms.open SQL,conn,adLockOptimistic,adOpenDynamic,adCmdText
rsbforms.addNew
rsbforms("coyid")=request.form("coyId")
rsbforms("typeid")=request.form("typesid")
rsbforms("addressid")=request.form("addressid")
rsbforms("tel")=request.form("tel")
rsbforms("fax")=request.form("fax")
rsbforms("btw")=request.form("btw")
rsbforms("hr")=request.form("hr")
rsbforms("b1")=request.form("b1")
rsbforms("b2")=request.form("b2")
rsbforms("b3")=request.form("b3")
rsbforms("b4")=request.form("b4")
rsbforms("email")=request.form("email")
rsbforms("description")=request.form("description")
rsbforms("paper")=request.form("paper")
rsbforms("printcolors")=request.form("printcolors")
rsbforms("col1")=request.form("color1")
rsbforms("col2")=request.form("color2")
rsbforms("col3")=request.form("color3")
rsbforms("col4")=request.form("color4")
rsbforms("paper")=request.form("paper")
rsbforms("printcolors")=request.form("printcolors")
if temp1 = "Yes" then
rsbforms("actif") = -1
else
rsbforms("actif") = 0
end if
rsbforms.Update
rsbforms.Close
set rsbforms = nothing
' response.redirect "index.asp?sessionid="&sessionid
%>
</body>
</html>
-----Original Message-----
From: Stephane_Dattenny@D... [mailto:Stephane_Dattenny@D...]
Sent: Wednesday, November 29, 2000 7:41 AM
To: ASP Databases
Subject: [asp_databases] RE: error '80040e21'
Can you give use the ASP server side code ?
Best regards / Cordialement
Stephane Dattenny
Dell Computers - EMEA IT - VB and Web developer
Phone: +33 (0)4 99 75 49 88
-----Original Message-----
From: Eric Van Camp [mailto:eric.vancamp@c...]
Sent: 29 November 2000 08:25
To: ASP Databases
Subject: [asp_databases] error '80040e21'
Hello,
i got this message on an asp page...
although i included adovbs.inc, to define adLockOptimistic,adOpenDynamic,
i inserte a connections string and defined and opened it,
i defined and opened a recordset..
what is going on?
<body text="#FFFFFF" link="#0000A0" vlink="#0000A0" alink="#0000A0"
bgcolor="#FFFFFF">
select * from BFORMS <font face="Arial" size=2>
<p>Microsoft OLE DB Provider for ODBC Drivers</font> <font face="Arial"
size=2>error '80040e21'</font>
Message #6 by "Mike H." <mhaining@p...> on Thu, 30 Nov 2000 16:40:51 -0000
|
|
I am getting the same error. I am verifying a logon and trying to update
my table with time of last login. Here are code snippets:
strUserName = request.form("UserName")
strPassword = request.form("Password")
strConn = {connection string}
strSQL = "SELECT * FROM Clients "
strSQL = strSQL & "WHERE Upper(Username) = '" & Trim(Ucase(strUserName)) &
"'"
strSQL = strSQL & " AND Upper(Password) = '" & Trim(Ucase(strPassword)) &
"'"
Set rsLogin = Server.CreateObject("ADODB.Recordset")
rsLogin.Open strSQL, strConnect, adOpenStatic, adLockPessimistic,
adCmdText
If rsLogin.EOF AND rsLogin.BOF Then
'user is not logged in, display message the user and have them try
again
else 'user is successfully logged on
rsLogin("Lastlogin") = Date
rsLogin.Update
Response.Clear
Response.Redirect("LoggedInPage.asp")
end if
Here is the error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/myUrl/LoginPage.asp, line 77
(where Line 77 is the rsLogin.Update above).
Any suggestions?
Thanks,
Mike
|
|
|
View Cart
