Can someon explain this to me....

[tkoehn]

-- Create an object
exec @hr = sp_OACreate 'AbacBill.PutFile', @object output
if @hr <> 0 begin
select @return = -100 - 1
goto errole_lbl
end

What does the 'AbacBill.PutFile' mean? I know the AbacBill is a database. I don't understand the .PutFile part.

Tony

 

[tlbroadbent]

sp_OACreate is a stored procedure that creates an instance of the OLE object on the computer running Microsoft SQL Server. AbacBill is the component name of an OLE Automation server, and PutFile is the name of the OLE object to be created.

Read about sp_OACreate in SQL Books Online or at

http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_oa-oz_9k2t.asp.

Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous