SQLDMO: SQL7 and 2K on the same server.

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

Site Related Forums

The Yak Corral

SQLDMO: SQL7 and 2K on the same server.

Author

Topic

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-05-20 : 11:10:08

Does anyone have a Dev box with a SQL 7 instance and a SQL 2k instance co-existing?

If so, can you run the following snippet on the 2K instance ...


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

...and then run it on the 7 instance?

What do you get?

(Thanks a million)

Jay White
{0}

ashok
Yak Posting Veteran

57 Posts

Posted - 2003-05-22 : 08:23:31

my dev box runs both sql7 and sql2k:

sql 2k ... nothing happened.
sql 7 i got the following error :
hr Source Description
---------- -------------------------- -------------------------
0x8007007F ODSOLE Extended Procedure The specified procedure could not be found.

quote:

...and then run it on the 7 instance?

HTH
--ashok

-ashok
"Bad dancing does not break an engagement."

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-05-22 : 08:31:05

Thanks for trying.

Check out http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=26332

I ended up calling Microsoft on this one ...

Jay White
{0}

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources