sql server x64 access x86 COM object

  • I 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?

  • I 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 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

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