Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

RecSet.Open

How do i open RecSet.Open ? Or rather what parameters do i use?
Just "RecSet.Open" gives me nothing but this error message:

Action is not allowed on an object that refers to a closed or illegal connection
/login.asp, line 64

(roughly translated from swedish)


Comments

  • vanithvanith Member Posts: 44
    [b][red]This message was edited by vanith at 2002-9-25 14:39:49[/red][/b][hr]
    : How do i open RecSet.Open ? Or rather what parameters do i use?
    : Just "RecSet.Open" gives me nothing but this error message:
    :
    : Action is not allowed on an object that refers to a closed or illegal connection
    : /login.asp, line 64
    :
    : (roughly translated from swedish)
    :
    :
    :

    hi!

    Syntax for using an ADO Recordset object.
    recordset.Open Source, ActiveConnection, CursorType, LockType, Options

    But all of these parameters are optional, which means either some of them have default values or you can specify them individualy by setting the respective properties like
    recordset.Source = "Select * from employee"
    Set recordset.ActiveConnection = connectionobject

    recordset.CursorType = 2 'adOpenDynamic
    recordset.LockType = 1 'adLockReadOnly

    then simply calling the recordset.open will open the recordset object.

    CursorType, LockType, Options have default values but Source and ActiveConnection must be specified before opening a Recordset. ActiveConnection is a ADODB.Connection object which must have been opened before you set the ActiveConnection property to the recordset.

    For more Info refer
    http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthrstopen.asp

    sample code
    -----------
    [code]
    dim cn, rs
    Set cn = Server.CreateObject("ADODB.Connection")
    Set rs = Server.CreateObject("ADODB.Recordset")
    cn.Open "DSNNAME","IUSRNAME","IUSRPWD"

    rs.open "select * from tablename", cn

    rs.close
    cn.close

    Set rs = Nothing
    Set cn = Nothing
    [/code]

    :)heers,
    vanith



  • Andre YoungAndre Young USAMember Posts: 0

    _____ / http://forcoder.org / free ebooks and video tutorials about \ C MATLAB Perl Java R Assembly C# Go Scratch C++ Objective-C PL/SQL Visual Basic .NET Python Delphi PHP Visual Basic Ruby JavaScript Swift Dart Transact-SQL Clojure Bash SAS FoxPro VBScript Fortran D Awk Crystal Kotlin Erlang Lua Ada COBOL Hack Alice Lisp Apex ABAP ML F# Julia Prolog Logo Rust Scheme LabVIEW Scala \ __

Sign In or Register to comment.