Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    7

    Unanswered: Calling a stored procedure from a dll

    When I call a stored procedure from a dll written in Builder C++, it gets blocked. But if I call the same SP from the main program, it works fine. but I need to call SP from the dll. What's the problem?
    Thanks...

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run PROFILER and see the activity when trying to call from the .DLL.

    Also you can add that SP as extended stored procedure by uisng sp_addextendedproc as specified in the books online.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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