February 14, 2013 at 3:14 am
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?
February 14, 2013 at 4:20 am
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