January 16, 2012 at 12:14 pm
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
January 16, 2012 at 12:31 pm
danschl (1/16/2012)
it appears that DMO is not supported anymore in sql2008r2EXEC @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.January 16, 2012 at 12:53 pm
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'
January 16, 2012 at 12:59 pm
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.January 16, 2012 at 1:30 pm
Aren't all the cool kids using PowerShell these days?
January 16, 2012 at 2:15 pm
i saw that earlier too
but everytime i run it i get
on all 3 calls
ODsole extended procedure error
January 16, 2012 at 2:17 pm
danschl (1/16/2012)
i saw that earlier toobut 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.January 16, 2012 at 2:21 pm
http://www.sqlservercentral.com/articles/Editorial/77292/
didnt phil factor say PS is going bye to
January 16, 2012 at 2:57 pm
Error Occurred Calling Object: ODSOLE Extended Procedure sp_OADestroy usage: ObjPointerToBeDestroyed int IN.
copying the exact info from the last post
word application
spellcheck
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply