[thelist] help: Object required

Dena teke at pullman.com
Wed May 25 12:08:52 CDT 2005


Why do I get "object required" error when I call this subroutine?
I've looked through microsoft info and googled the problem, and it
should work.

sub subOpenDBConn()
    dim oConn, Path, dbConn, conntemp
    Path = Server.MapPath ("/datastore/library.mdb")
    Set oConn = Server.CreateObject("ADODB.Connection")
    dbConn = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
         "Data Source = "&Path&";" &_
         "Persist Security Info = FALSE"
    oConn.Open dbConn
    set conntemp=server.createobject("adodb.connection")
    conntemp.open oConn
end sub

here's the page that calls the sub

<% Option Explicit %>
<% response.buffer=TRUE %>

if len(iDocId)>0 then 'doc id has a value
  call subOpenDBConn()
  dim conntemp
  dim sDocQuery
  sDocQuery="SELECT doc_checkedout, doc_title, doc_callno where doc_seq = "
& iDocId & ";"
  dim rsDoc: set rsDoc=conntemp.execute(sDocQuery) 'this lines gives the
end if %>

the error points to the last line above
Microsoft VBScript runtime (0x800A01A8)
Object required: ''

More information about the thelist mailing list