Dreamweaver - ASP Headache

Author

ASP Headache - I need help

Webspert

2004-04-21, 2:55 pm

I am very new to creating dynamic pages, and have been following the
instructions I got in a book called Dreamweaver MX Magic, and also from a
Dreamweaver extension for Events Calendar from Dreamlettes. In both
instances, I run into the same errors. I am pretty sure I have followed the
instructions, and have started over several times now, but it always ends
the same.

When I preview the page in the browser (both IE and Netscape) I get an
error:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.

/asp/TMPxcmmnw7043.asp, line 22

Does anyone know about this? I'm about ready to tear out what little hair
I have left. I thought Dreamweaver MX was supposed to produce the correct
code
automatically. Where is it (or where am I) going wrong?

Thanks in advance.

Alan

middletree

2004-04-21, 2:55 pm

There is no way to answer this question without either seeing your code, or
knowing exactly what steps you took to get to where you are now. But the
code would be best.

"Webspert" <webspert@thewebspert.com> wrote in message
news:c5rvqv$rh6$1@forums.macromedia.com...
> I am very new to creating dynamic pages, and have been following the
> instructions I got in a book called Dreamweaver MX Magic, and also from a
> Dreamweaver extension for Events Calendar from Dreamlettes. In both
> instances, I run into the same errors. I am pretty sure I have followed
the
> instructions, and have started over several times now, but it always ends
> the same.
>
> When I preview the page in the browser (both IE and Netscape) I get an
> error:
>
> ADODB.Recordset error '800a0bb9'
> Arguments are of the wrong type, are out of acceptable range, or are in
> conflict with one another.
>
> /asp/TMPxcmmnw7043.asp, line 22
>
> Does anyone know about this? I'm about ready to tear out what little hair
> I have left. I thought Dreamweaver MX was supposed to produce the correct
> code
> automatically. Where is it (or where am I) going wrong?
>
> Thanks in advance.
>
> Alan
>
>
>

Webspert

2004-04-21, 2:55 pm

Thanks very much for the response. I really appreciate the help. Here is
what I did, followed by the code generated by Dreamweaver MX.

1. I built and uploaded a database.
2. I created a page password.asp with a form frmLogin with action
validation.asp
3. I created a page validation.asp and tested the connection string name:
connUsername string: agents using driver on testing server. The test came
back sucessful.
4. I created a record set rsLogin following the instructions on pages 272 &
273 of Dreamweaver MX Magic.
5. When I preview the file, I get the error:

ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another.
/agents/TMPl6pdiwc2w1.asp, line 22

The code produced by Dreamweaver MX is:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

<%
Dim rsLogin__varUsername
rsLogin__varUsername = "0"
If (Request.Form("tfUsername") <> "") Then
rsLogin__varUsername = Request.Form("tfUsername")
End If
%>
<%
Dim rsLogin__varPassword
rsLogin__varPassword = "0"
If (request.Form("tfPassword") <> "") Then
rsLogin__varPassword = request.Form("tfPassword")
End If
%>
<%
Dim rsLogin
Dim rsLogin_numRows

Set rsLogin = Server.CreateObject("ADODB.Recordset")
rsLogin.ActiveConnection = MM_connUsername_STRING
rsLogin.Source = "SELECT Username, Password FROM tbLogin WHERE Username='" +
Replace(rsLogin__varUsername, "'", "''") + "' AND Password='" +
Replace(rsLogin__varPassword, "'", "''") + "'"
rsLogin.CursorType = 0
rsLogin.CursorLocation = 2
rsLogin.LockType = 1
rsLogin.Open()
rsLogin_numRows = 0
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
</body>
</html>
<%
rsLogin.Close()
Set rsLogin = Nothing
%>

Line 22, which it doesn't seem to like, is: rsLogin.ActiveConnection =
MM_connUsername_STRING

"middletree" <middletree@HTOmail.com> wrote in message
news:c5s2ra$18k$1@forums.macromedia.com...
> There is no way to answer this question without either seeing your code,
or
> knowing exactly what steps you took to get to where you are now. But the
> code would be best.
>
>
> "Webspert" <webspert@thewebspert.com> wrote in message
> news:c5rvqv$rh6$1@forums.macromedia.com...
a[color=darkred]
> the
ends[color=darkred]
hair[color=darkred]
correct[color=darkred]
>
>