InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:29:05 GMT20http://www.sqlservercentral.com/Forums/Topic1419915-391-1.aspxI had the same or very similar problem, a COM object on x64 ported from sql 2000 and helped installing management studio, still don't know why :-)Thu, 14 Feb 2013 04:20:28 GMTe4d4http://www.sqlservercentral.com/Forums/Topic1419915-391-1.aspxI want to transfer a database from SQL Server 2000 x86 to SQL Server 2008 R2 x64 but it uses a x86 COM object that I have no inside knowledge of. I know there are some articles out there about the same topic, but my problem is slightly different.After registering the DLL Server for Surrogate Activation, I can connect to COM object with sp_OACreate without errors, but sp_OASetProperty returns -2147352565 and sp_OAGetErrorInfo returns error source "ODSOLE Extended Procedure" and error description "Invalid index".Another thing I don't understand is that although the COM server is executable, and so out of process, I could not connect to it before using dll surrogate. Out of process servers aren't supposed to work without surrogate?Thu, 14 Feb 2013 03:14:38 GMTaoikonom