Groups | Blog | Home
all groups > sql server programming > november 2003 >

sql server programming : XPs and Web Services??


Claude Vernier
11/3/2003 10:56:46 PM

Hello,

Thanks to OJ for previous answer in message:
Ext. Procs. Web Services, C#, C++, PLEASE HELP ME!

I'll continue my Extended procedure in C++ calling a web
service...

I need help on how to replace the DLL on the server.
I used two commands to free my DLL and still:
-sp_dropextendedproc 'xp_proc'
-DBCC xp_proc(FREE)

I can't update the file.
Can someone please help me?


I have a few other questions, if someone could help me...

-Using the xp_ template for C++ in VS.Net, I didn't
selected ATL, is that important for the Web Services part?
-How can I specify parameters for my xp_
-I achieved to add a Web Reference to my web service and
found the code to call the method. My problem is that
this method expects a BSTR*, how can I create one as in
C#: string myvar = "tests";
-The code sample I found did: HRESULT hr =
myobject::myclasse.myfunction(); and then, an if testing
the result of hr, but how do I access the value returned
(a string) by the Web Service?

Thank,
oj
11/4/2003 10:37:17 AM
Claude,

I don't do xp so can't offer much help here. However, see if this might
help...
http://sqldev.net/xp/KnowledgeBaseArticles.htm

--
-oj
RAC v2.2 & QALite!
http://www.rac4sql.net


[quoted text, click to view]

Gert E.R. Drapers
11/10/2003 12:49:45 AM
If you are that familiar with C++ you are a greatly endangering your SQL
Server installation, because your DLL will run in-process.
Get a professional to write the XP.

GertD@SQLDev.Net

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2003 All rights reserved.

[quoted text, click to view]

AddThis Social Bookmark Button