January 14, 2010 at 2:46 pm
Is it possible?
Or should I recompile the DLL in 64 bits and recreate the assembly in sql?
Because I'm having a bug where a database was imported from SQL Server 32 bits onto a 64 bits machine and the clr is failing.
Yes the option was turn on, trustworthy trick and changed db_owner was done also, login and dbo sids match.
January 14, 2010 at 3:05 pm
Megistal (1/14/2010)
Is it possible?Or should I recompile the DLL in 64 bits and recreate the assembly in sql?
Because I'm having a bug where a database was imported from SQL Server 32 bits onto a 64 bits machine and the clr is failing.
Yes the option was turn on, trustworthy trick and changed db_owner was done also, login and dbo sids match.
This being SQL Server you could try compiling the code as AnyCPU instead of x64 which will run in both x86 and x64. Yes you could compile the code as x64 but you could get errors but if you compile AnyCPU it is easier to compile. If I remember correctly you need VS2005/8 standard edition and up to change the build options.
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply