ASP 3.0 Cursor Location why ?? {Resolved}
Hi i am trying to set the cursor location of the connection or recordset object,
every time i try i get this error
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/bboard/addins/header.asp, line 11
this is /bboard/addins/header.asp
Code:
<%
dim thers
dim theconn
dim urs
dim sql
dim connstr
set thers = server.createobject("ADODB.RECORDSET")
set theconn = server.createobject("adodb.connection")
set urs = server.createobject("adodb.recordset")
thers.cursorlocation = adUseClient
urs.cursorlocation = adUseClient
connstr = "provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
server.mappath("/BBoard/database/BadgerBoardDB.mdb")
theconn.connectionstring = connstr
theconn.open
%>
according to W3schools you can set this
http://www.w3schools.com/ado/prop_cursorlocation.asp
i am trying to get a recordcount property that is not -1 so if there
is another way please tell
