Calling normal stored procedures from Extended Procedures RRS feed

  • Question

  • Hi

    I want to call a database stored procedure from an extended procedure. Can some one provide snippet of code (either in C or C++) to achieve the same ?

    Thanks & Regards
    Thursday, December 8, 2005 10:46 PM


  • You have to make connection to server using ODBC or OLEDB to do this. Please take a look at the call escape sequence topic in Books Online. The url is mk:@MSITStore:D:\Program%20Files\Microsoft%20SQL%20Server%20Books%20Online\1033\odbcsql.chm::/od_6_035_5dnp.htm. You may have to change the path depending on your installation. You can also find samples in the SQL Server CD.
    Friday, December 9, 2005 12:28 AM