Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20

Thread: Problem with Store Procedure

  1. #16
    Join Date
    Sep 2002
    Posts
    5,938
    Tried connect with sql instance name instead of local?

  2. #17
    Join Date
    Feb 2003
    Posts
    1,048
    Try calling the "Execute" method instead of "Exec". I don't think "Exec" is a valid command in this case.

  3. #18
    Join Date
    May 2005
    Posts
    10
    Originally posted by Rawhide
    Try calling the "Execute" method instead of "Exec". I don't think "Exec" is a valid command in this case.
    if I use "Execute" method instead of "Exec" the stored procedure doesn't run and I must kill it with task manager

  4. #19
    Join Date
    Feb 2003
    Posts
    1,048
    Which is it? Does it not run or do you have to kill it with task manager? If it doesn't run, there's nothing to kill.

  5. #20
    Join Date
    May 2005
    Posts
    10
    Originally posted by Rawhide
    Which is it? Does it not run or do you have to kill it with task manager? If it doesn't run, there's nothing to kill.
    If I execute the stored procedure it I jam and nothing cannot be made more (to stop the procedure, to close SQL query Analizer..). if I replace "Execute" with "Exec" the procedure I come executed and from the error:
    "Execute failed
    OLE Automation Error Information
    HRESULT: 0x80020006
    Source: ODSOLE Extended Procedure
    Description: Nome sconosciuto."

Posting Permissions

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