stored procedure

Results 1 to 2 of 2

Thread: stored procedure

  1. #1
    Join Date
    Dec 1969

    Default stored procedure

    Can anyone tell me how to fix this error?<BR>Error Type:<BR>ADODB.Command (0x800A0E7D)<BR>Requested operation requires an OLE DB Session object, which is not supported by the current provider.<BR><BR>After this is the ASP code<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR> Set objCmd = Server.CreateObject("ADODB.Command")<BR><BR> objCmd.ActiveConnection = objConn<BR> objCmd.CommandType = 4<BR> objCmd.CommandText = "ADD_BOOKING"

  2. #2
    Join Date
    Dec 1969

    Default Umm...

    Don&#039;t you have to OPEN the connection before assigning it to the ActiveConnection property of the command object?<BR><BR>Surely, otherwise it&#039;s not "active"? :-)<BR><BR>Craig.

Posting Permissions

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