BorlandTalk.com

Adele le Roux · Guest

Hi All,

I recently wrote my first com object and I am having the following
problem...
I call my com object from a stored procedure in SQL Server and I get the
following error when the object is created. If I create the said com object
using a delphi application I get no errors.
Number: -2147467262
Description: No such interface supported
What I have done in the mean time (to get this up and running) is to create
a standard windows DLL (using Delphi) and created an ActiveX DLL in Visual
basic that calls the said delphi DLL. I am really confused as to why the
delphi com object does not work. Here is the steps that I followed to
create my com object (just a quick test com object).
I create a new ActiveX Library (File > New > ActiveX > ActiveX Library).
Then I create a com object within the activx library (File > New > ActiveX >
Com Object). I then create a new method and select a widestring (Bstr) as
the result type. When I call it from within SQL server I get the above
mentioned error. Does anyone have an idea what that means??? The class
string referred to in the SQL stored procedure is right as it gives another
error if it is not. PLEEEEEEEEEEEEEEEEEEAAASE HELP!!!

Thanks a million,
Adele