Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Glasgow, Scotland

    Unanswered: ado - stored procedure warnings

    I am trying to run a stored procedure in an access front end using ado and the execute command. The process fails with the error "Warning: Null value is eliminated by an aggregate or other SET operation." - I get this warning when running the sp in query analyser but I know this is not a problem and it just continues. Is there a way to get ado to ignore these warnings and continue the code.


  2. #2
    Join Date
    Feb 2002
    Houston, TX
    Once you establish a connection use <Connection Object>.Execute "SET ANSI_WARNINGS OFF", , adCmdText.

    You might also want to issue a SET NOCOUNT ON.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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