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 |
|
samarjit_r
Starting Member
2 Posts |
 Posted - 2014-12-05 : 06:56:51
|
| On 64 bit system SQL Server 2012 with SQL Server 2005 Backward Compatibility (64 bit) installed, getting an initialization failed error when trying to execute the below query. Any idea what I am missing here. Tried to uninstall and then install SQL Server 2005 BC multiple times, but that didn't help. Looks like sp_OACreate is not able to create the object. EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2014-12-05 : 07:46:53
|
| Do you have the option of using PowerShell with SMO objects instead? DMO and sp_OACreate are deprecated and do not have native 64-bit support. SMO has equivalent methods and objects for everything DMO has. |
 |
|
|
|
|
|
SQL Server 2012 sp_OACreate