Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server x64 access x86 COM object Expand / Collapse
Author
Message
Posted Thursday, February 14, 2013 3:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 29, 2013 4:25 AM
Points: 1, Visits: 14
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?
Post #1419915
Posted Thursday, February 14, 2013 4:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 8:36 AM
Points: 225, Visits: 1,754
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
Post #1419964
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse