Problem with SQLDMO.SQLServer - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Problem with SQLDMO.SQLServer

Author

Topic

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-05-19 : 08:59:47

Microsoft SQL Server 7.00 - 7.00.961 (Intel X86)
Oct 24 2000 18:39:12
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)


DECLARE @object int
DECLARE @hr int
DECLARE @src varchar(255), @desc varchar(255)
EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT
IF @hr <> 0
BEGIN
   EXEC sp_OAGetErrorInfo @object, @src OUT, @desc OUT 
   SELECT hr=convert(varbinary(4),@hr), Source=@src, Description=@desc
    RETURN
END

...generates....


hr         Source                    Description
---------- ------------------------- -------------------------------------------
0x8007007F ODSOLE Extended Procedure The specified procedure could not be found.

(1 row(s) affected)

What is the problem? Is it because it is Standard Edition?

Jay White
{0}

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-05-19 : 09:21:34

Worked for me on this :

Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

Don't know if the Service Pack has anything to do with it. Permissions ?

Damian

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-05-22 : 07:01:39

UPDATE:

See Also http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=26386

The problem we are experiencing has to do with SQL 7 and SQL 2K co-existing on a machine.

If you have a similar set-up and are using SQLDMO in this way, you may get this same error. I recommend you call Microsoft. They have a variety of hacks to solve the problem ....

Jay White
{0}

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-05-22 : 08:03:40

The question is WHY ????

You running Systems Management Server on it ?

Damian

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-05-22 : 08:11:12

No. No SMS ...

Microsoft had me shut down the 7 and 2K instances and then copy the sqlsvc.dll and sqlresld.dll from the 2K binn to the 7 binn ... brought both instances back up and SQLDMO is now working in 7 ...

Jay White
{0}

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources