Stored Procedures with stupid Parameters

Results 1 to 2 of 2

Thread: Stored Procedures with stupid Parameters

  1. #1
    Tom Holder Guest

    Default Stored Procedures with stupid Parameters

    Hi,<BR><BR>I&#039m trying to use a stored parameter with my Access Database but I keep getting a stupid Driver not capable error. I&#039ve tried this on two NT machines and both do exactly the same. I&#039ve read all the examples in the Wrox books and even the example one in Beginning ASP 2.0 fails. Here is the code:<BR><BR>&#060;%<BR>Set objCmd = Server.CreateObject ("ADODB.Command")<BR><BR>objCmd.ActiveConnectio n = strDataConnect<BR>objCmd.CommandText = "displaybasket"<BR>objCmd.CommandType = adCmdStoredProc<BR>objCmd.Parameters.Append objCmd.CreateParameter("userid", adBigInt, adParamOutput)<BR>Set objRecBasket = objCmd.Execute<BR><BR>Set objRecBasket = Nothing<BR>objConn.Close<BR>Set objConn = Nothing<BR>&#037;&#062;<BR><BR>Can someone please point me in the right direction.<BR>Thanks<BR><BR>Tom

  2. #2
    Join Date
    Dec 1969
    Posts
    1,315

    Default RE: Stored Procedures with stupid Parameters

    What does your stored procedure code look like? What error message are you getting, exactly?

Posting Permissions

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