error '800a0bb9' Help!!

[Nich]

Ciao a tutti,
è da tempo che combatto con questo errore senza riuscire a risolvere niente. Premetto che lo script prima era installato su server win2000 e non dava alcuni tipo di problema, da quando è su win2003 mi genera questo tipo di errore.

----------------------------------
ADODB.Recordset

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/newsletter/send.asp, line 158


----------------------------------

che non sarà colpa di cdonts..vi posto il file send.asp


<%
SQLIF = "SELECT ID FROM List"
Set RSIF = Server.CreateObject("ADODB.Recordset")
RSIF.Open SQLIF, Conn, 1, 3

If NOT (RSIF.BOF AND RSIF.EOF) Then%>

<form action="send2.asp" Method="Post">
<table border="0" cellpadding="3" cellspacing="0" align="center">
<%
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * from Settings"
RS.Open SQL, Conn, 1, 3
%>
<tr>
<td bgcolor="#DAE3F0"><font face="Verdana" size="1">Subject:</font></td>
<td bgcolor="#DAE3F0"><input type="text" name="Subject" class="inputbox" size="40"></td>
</tr>
<tr>
<td bgcolor="#C5D3E7"><font face="Verdana" size="1">Format:</font></td>
<td bgcolor="#C5D3E7"><select name="Format" class="inputbox">
<option value="Text">Text</option>
<option value="HTML">HTML</option>
</select></td>
</tr>
<tr>
<td bgcolor="#DAE3F0"><font face="Verdana" size="1">Archive Message:</font></td>
<td bgcolor="#DAE3F0"><input type="checkbox" name="Archive" checked></td>
</tr>
<tr>
<td bgcolor="#C5D3E7" colspan="2"><font face="Verdana" size="1">Body:

<textarea name="Body" class="inputbox" cols="80" rows="25"></textarea>
</font></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="Submit" value="Send" class="inputSubmit"></td>
</tr>
</table>
</form>

<%Else%>
<center><font face="Verdana" size="1">There are currently no subscribers.</font></center><%End If%>

</td>
</tr>
</table></td>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

[burruchaga]

prova a scrivere al posto di

Set RSIF = Server.CreateObject("ADODB.Recordset")
RSIF.Open SQLIF, Conn, 1, 3

quest'altra istruzione


set RSIF=conn.execute(SQLIF)

[gold]

RSIF.Open SQLIF, Conn, 3, 3

[Nich]

Ciao e grazie,
ho provato a fare come dicevi ma


-----------------------------------------------

Microsoft VBScript runtime error '800a01a8'

Object required: ''

/newsletter/send.asp, line 157

-----------------------------------------------
<%
SQLIF = "SELECT ID FROM List"
set RSIF=conn.execute(SQLIF)

If NOT (RSIF.BOF AND RSIF.EOF) Then%>

<form action="send2.asp" Method="Post">
<table border="0" cellpadding="3" cellspacing="0" align="center">
<%
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * from Settings"
RS.Open SQL, Conn, 1, 3
%>
<tr>
<td bgcolor="#DAE3F0"><font face="Verdana" size="1">Subject:</font></td>
<td bgcolor="#DAE3F0"><input type="text" name="Subject" class="inputbox" size="40"></td>
</tr>
<tr>
<td bgcolor="#C5D3E7"><font face="Verdana" size="1">Format:</font></td>
<td bgcolor="#C5D3E7"><select name="Format" class="inputbox">
<option value="Text">Text</option>
<option value="HTML">HTML</option>
</select></td>
</tr>
<tr>
<td bgcolor="#DAE3F0"><font face="Verdana" size="1">Archive Message:</font></td>
<td bgcolor="#DAE3F0"><input type="checkbox" name="Archive" checked></td>
</tr>
<tr>
<td bgcolor="#C5D3E7" colspan="2"><font face="Verdana" size="1">Body:

<textarea name="Body" class="inputbox" cols="80" rows="25"></textarea>
</font></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="Submit" value="Send" class="inputSubmit"></td>
</tr>
</table>
</form>

<%Else%>
<center><font face="Verdana" size="1">There are currently no subscribers.</font></center><%End If%>

</td>
</tr>
</table></td>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

[Roby_72]

Che "List" sia una parola riservata?

Roby

[Nich]

come faccio a sapere se è una parola riservata.
com'è possibile che su win2000 funzionava correttamente e su win203 da problemi?
grazie

[Roby_72]

C'era un link che ora non trovo...
Cmq prova a mettere list tra parentesi quadre: [List]

Roby

[Nich]

niente.
cmq vi posto tutto il codice del file send.asp

------------------------------------------------




<html>
<head>
<title><%=RSBODY("List_Name")%></title>

<script language="javascript">

function open_Code_Heading_Text() {
popupWin = window.open('help.asp?ID=Code_Heading_Text', 'remote', 'width=300,height=200')
}
function open_Code_Heading_BG() {
popupWin = window.open('help.asp?ID=Code_Heading_BG', 'remote', 'width=300,height=200')
}
function open_Code_Body_Text() {
popupWin = window.open('help.asp?ID=Code_Body_Text', 'remote', 'width=300,height=200')
}
function open_Code_Body_BG() {
popupWin = window.open('help.asp?ID=Code_Body_BG', 'remote', 'width=300,height=200')
}
function open_Code_Border() {
popupWin = window.open('help.asp?ID=Code_Border', 'remote', 'width=300,height=200')
}

</script>



</head>
<body bgcolor="#F0F0F0" vlink="#48576C" link="#48576C" alink="#000000">
<table border="0" cellpadding="0" cellspacing="0" width="650" align="center">
<tr>
<td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
<td colspan="3" bgcolor="#52637B" height="35" width="648"><font face="Verdana" size="5" color="#FFCC00"><%=RSBODY("List_Name")%></font></td>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
<td bgcolor="#8199DA" valign="top" width="130">

<table border="0" cellpadding="0" cellspacing="0" width="130">
<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Home</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="5">[img]im/clear.gif[/img]</td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">SendMailing</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">View/EditSubscribers</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">GenerateHTML</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">MailArchive</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="5">[img]im/clear.gif[/img]</td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Settings</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Support</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">Documentation</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="5">[img]im/clear.gif[/img]</td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td bgcolor="#B0C4DE" width="130" height="15"><font face="Verdana" size="1">LogOut</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1">[img]im/clear.gif[/img]</td>
</tr>
</table>

</td>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
<td bgcolor="#FFFFFF" width="100%" valign="top" height="200">

<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td bgcolor="#B0C4DE" height="15" width="100%"><font face="Verdana" size="1" color="#000000">Send Mailing</font></td>
</tr>
<tr>
<td bgcolor="#000000" height="1" width="100%">[img]im/clear.gif[/img]</td>
</tr>
</table>

<table border="0" cellpadding="2" cellspacing="0" width="100%">
<tr>
<td width="100%">



<%
SQLIF = "SELECT ID FROM [List]"
set RSIF=conn.execute(SQLIF)

If NOT (RSIF.BOF AND RSIF.EOF) Then%>

<form action="send2.asp" Method="Post">
<table border="0" cellpadding="3" cellspacing="0" align="center">
<%
Set RS = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * from Settings"
RS.Open SQL, Conn, 1, 3
%>
<tr>
<td bgcolor="#DAE3F0"><font face="Verdana" size="1">Subject:</font></td>
<td bgcolor="#DAE3F0"><input type="text" name="Subject" class="inputbox" size="40"></td>
</tr>
<tr>
<td bgcolor="#C5D3E7"><font face="Verdana" size="1">Format:</font></td>
<td bgcolor="#C5D3E7"><select name="Format" class="inputbox">
<option value="Text">Text</option>
<option value="HTML">HTML</option>
</select></td>
</tr>
<tr>
<td bgcolor="#DAE3F0"><font face="Verdana" size="1">Archive Message:</font></td>
<td bgcolor="#DAE3F0"><input type="checkbox" name="Archive" checked></td>
</tr>
<tr>
<td bgcolor="#C5D3E7" colspan="2"><font face="Verdana" size="1">Body:

<textarea name="Body" class="inputbox" cols="80" rows="25"></textarea>
</font></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="Submit" value="Send" class="inputSubmit"></td>
</tr>
</table>
</form>

<%Else%>
<center><font face="Verdana" size="1">There are currently no subscribers.</font></center><%End If%>

</td>
</tr>
</table></td>
<td width="1" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

<tr>
<td height="1" colspan="5" bgcolor="#000000">[img]im/clear.gif[/img]</td>
</tr>

[rixx]

lol ma questo è il coso per le newsletter come si chiama.....

[rixx]

non è possibile che non vada fossi in te se non hai fatto modifiche lo risostituirei!
cmq magari hai cambiato qualcosa al db
o cosi sembra, lo hai fatto?