Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-27 : 08:24:10
|
| Shallu writes "I want to create an object of my com component through sql server 2000 using sp_oacreate() method. i am getting an error that invalid class string. i am doing it like this..create procedure test_add as DECLARE @object int DECLARE @hr int DECLARE @src varchar(255), @desc varchar(255) EXEC @hr = sp_OACreate 'AddProject.Class1', @object OUT,1 IF @hr <> 0 BEGIN EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc RETURN END can anybody tell me where i am wrong?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-09-27 : 09:45:32
|
| Did you register your COM object on the SQL Server using regsvr32.exe? If yes, are you absolutely sure the class name is correct? (did you check the registry, in other words?) |
 |
|
|
|
|
|
Instantiating a com Object