ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/index.asp, line 19
Dok kod izgleda ovako:
<%@ Language=VBScript %>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<P>
<OBJECT id="Con" PROGID="ADODB.Connection" RUNAT="server"></OBJECT>
<OBJECT id="rsAnketa" PROGID="ADODB.Recordset" RUNAT="server"></OBJECT>
<%
Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("DB\Anketa.mdb")
rsAnketa.Open "PiO", Con, adOpenStatic, adLockReadOnly, adComTable
rsAnketa.MoveFirst
Do While Not rsAnketa.EOF
%>
<p><%= rsAnketa.fields("BrojPitanja").Value %>. <%= rsAnketa.fields("Pitanje").Value %></p>
<form method="post" action="Index.asp">
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">
<input type="radio" value="V1" name="R1"> <%= rsAnketa.fields("Odgovor1").Value %></p>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">
<input type="radio" name="R1" value="V2"> <%= rsAnketa.fields("Odgovor2").Value %></p>
<p style="MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px">
<input type="radio" name="R1" value="V3"> <%= rsAnketa.fields("Odgovor3").Value %></p>
</form>
<hr>
<%
rsAnketa.MoveNext
Loop
%>
<form method="post" action="Index.asp" id=form2 name=form2>
<input type="button" value="Dodaj u anketu" name="B3">
<P></P></form>
<P></P>
</BODY>
</HTML>
Greška je na liniji rsAnketa.Open...
U VB-u sam namjerno pogrešio u connection string-u i dobio sam istu poruku, međutim, kada sam ispisao isti kao i na ASP stranici sve je prošlo OK. Kreirao sam konekciju i u Connection Builder-u u VB-u i prekopirao je na ASP stanicu uz samo podešavanje putanje i opet dobio istu poruku. Gdje griješim?