i give dmo to smo conversion

Question

i give dmo to smo conversion

danschl

SSCertifiable

Points: 5770
More actions
January 16, 2012 at 12:14 pm

#266701

it appears that DMO is not supported anymore in sql2008r2
EXEC @hr= sp_OACreate 'SQLDMO.SQLServer', @objServer OUT
so i was trying to convert to SMO
EXEC @hr= sp_OACreate 'Microsoft.SqlServer.Management.Smo', objServer OUT
Microsoft.SqlServer.Management.Smo.Server
'Microsoft.SqlServer.Smo'
'SQLSMO.SQLServer'
everything i try gives a invalid string class error

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

danschl (1/16/2012)
it appears that DMO is not supported anymore in sql2008r2
EXEC @hr= sp_OACreate 'SQLDMO.SQLServer', @objServer OUT
so i was trying to convert to SMO
EXEC @hr= sp_OACreate 'Microsoft.SqlServer.Management.Smo', objServer OUT
Microsoft.SqlServer.Management.Smo.Server
'Microsoft.SqlServer.Smo'
'SQLSMO.SQLServer'
everything i try gives a invalid string class error

You are correct, SQLDMO is being phased out.

For SQLDMO-SQLSMO functions mapping please see: http://msdn.microsoft.com/en-us/library/ms162159.aspx

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

danschl SSCertifiable Points: 5770 More actions · Answer 2

thanks i found that:-P

but i dont see how to make the connection (everything i have tried gives me error :unsure:

EXEC @hr= sp_OACreate 'Microsoft.SqlServer.Management.Smo', objServer OUT

or

Microsoft.SqlServer.Management.Smo.Server

o

'Microsoft.SqlServer.Smo'

or

'SQLSMO.SQLServer'

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 3

http://www.sqlservercentral.com/Forums/Topic823529-22-1.aspx

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Paul White SSC Guru Points: 150467 More actions · Answer 4

Aren't all the cool kids using PowerShell these days?

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

danschl SSCertifiable Points: 5770 More actions · Answer 5

i saw that earlier too

but everytime i run it i get

on all 3 calls

ODsole extended procedure error

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 6

danschl (1/16/2012)
i saw that earlier too
but everytime i run it i get
on all 3 calls
ODsole extended procedure error

I think you missed Barry Young's post on that one...

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

danschl SSCertifiable Points: 5770 More actions · Answer 7

http://www.sqlservercentral.com/articles/Editorial/77292/

didnt phil factor say PS is going bye to

danschl SSCertifiable Points: 5770 More actions · Answer 8

Error Occurred Calling Object: ODSOLE Extended Procedure sp_OADestroy usage: ObjPointerToBeDestroyed int IN.

copying the exact info from the last post

word application

spellcheck