Results 1 to 2 of 2

Thread: ASP 3.0 Cursor Location why ?? {Resolved}

Threaded View

  1. Mar 7th, 2004, 07:04 AM #1
    señorbadger
    señorbadger is offline

    Thread Starter
    Addicted Member señorbadger's Avatar
    Join Date
    Oct 2003
    Location
    Mud pools of wellingborough
    Posts
    193

    Question 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
    Last edited by señorbadger; Mar 8th, 2004 at 02:07 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width