quote:

---

Originally posted by krishap

Hi
I have a problem with a client that I'm trying to fix for past 1 week and could not figure out what could be wrong.

We provided a solution to the client where there is a windows service running and polling the database table and whenever there is changes in the table the poller takes the record and calls a method in the dll. This dll puts the data in a MSMQ.

The client himself modified this process little bit by stoping the service and wrote a stored procedure ( its below) which call this dll and which in turn should put that in a queue.

All is working well when this is on a stand alone machine, but when the client tests this on a clustered sql server it prints out all the messages in the sp and does not fail but doesnt put anything in the queue.
The dll is registered in the Base machine of the Sql Server
pls suggest what should I check for. Here is the code.



DECLARE @object int
DECLARE @hr int
DECLARE @property varchar(255)
DECLARE @return varchar(255)
DECLARE @src varchar(255), @desc varchar(255)
declare @methodreturnvalue int

-- Create an object.
EXEC @hr = sp_OACreate 'DatabasePoller.DatabasePoller', @object OUT
select 'After OACreate'
select @hr
select @object
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
RETURN
END

-- Call a method that returns a value.
EXEC @hr = sp_OAMethod @object, 'LogChangesInCRSToAdapterSelectQueue', @methodreturnvalue OUT, 608898346
select 'After OAMethod'
print @methodreturnvalue
select @hr
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
RETURN
END
PRINT @return

-- Destroy the object.
EXEC @hr = sp_OADestroy @object
select 'After OADestroy'
select @hr
IF @hr <> 0
BEGIN
EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT
SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
RETURN
END

Thanks
RK

---