Showing posts with label api. Show all posts
Showing posts with label api. Show all posts

Monday, March 19, 2012

Extended Stored Procedure API not in new Platform SDK

Does anyone know why the Extended Stored Procedure API (formerly Open Data Services) headers and libraries (e.g. srv.h, srvdbtyp.h, opends60.lib) are not in the new Platform SDK?
Older versions of the Platform SDK had these tools included, but I installed the new Platform SDK and they're not included. Is there another SDK that I need to download and install now?Those headers don't work with Visual C++ .NET, they only work with 6.0 (some versions also work with 5.0). I can't see any point in even trying to compile that code in the same context as the newer API stuff.

-PatP|||We're still using the 6.0 compiler, not .NET (i.e. 7.x). What is the newer API stuff your referring to? Has the Extended Stored Procedure API been replaced by something else?

Extended Stored Proc write to ERRORLOG?

Is there a way to do something like raiserror using the extended stored
procedure API?
srv_sendmsg gets me the equivalent of PRINT but it doesn't get logged
in the SQL Server Logs.
Any suggestions?
Thank you.How about xp_logevent?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<nimai.malle@.gmail.com> wrote in message
news:1146514341.086831.176790@.j73g2000cwa.googlegroups.com...
> Is there a way to do something like raiserror using the extended stored
> procedure API?
> srv_sendmsg gets me the equivalent of PRINT but it doesn't get logged
> in the SQL Server Logs.
> Any suggestions?
> Thank you.
>|||I'm looking for something that I can call from inside my own extended
stored procedure, from C++.
Thanks.