Previous Thread:   FOR XML PATH

2/3/2006 11:11:59 AM    Re: sqlclr framework change
"skg" <skg@yahoo.com> wrote in  
  
news:#6X2#dOKGHA.360@TK2MSFTNGP12.phx.gbl:  
  
Are you absolutely certain you are targetting a 64 bits SQL Server? I am  
  
running SQL 2005 64 bits and VS 2005, and have no issues deploying to my  
  
SQL Server (which is 64 bit).  
  
Also, it seems strange that you are getting that error message - how  
  
have you compiled the assembly? By default an assembly is compiled with  
  
the anyCPU flag, which should allow you to run on both a 64 as well as  
  
32 bits platform.  
  
Niels  
  
--  
  
**************************************************  
  
* Niels Berglund  
  
* http://staff.develop.com/nielsb  
  
* nielsb@no-spam.develop.com  
  
* "A First Look at SQL Server 2005 for Developers"  
  
* http://www.awprofessional.com/title/0321180593  
  
**************************************************



2/3/2006 11:30:13 AM    sqlclr framework change
We have sql2005 64 bit and framework 2.0  32 and 64 bit.  
  
When i try to deploy a UDF 64 bit assembly via vs.net2005 i get following  
  
error.  
  
Error: Attempted to load a 64-bit assembly on a 32-bit platform. Use  
  
ReflectionOnlyLoad() instead if trying to load for reflection purposes.  
  
Does any one know how to find whether sql is using 32 bit or 64 bit frame  
  
work. or there is a workaround.  
  
BTW we have 64 bit framework but i don't know how to configure sql to use  
  
this framework.  
  
tia.

2/3/2006 1:45:12 PM    Re: sqlclr framework change
Niel. Thanks!!!. I have my vs.net 2005 client  on 32 bit. But i set it to  
  
compile for 64 bit in the  
  
project properties. I get this error. Is your vs.net client on 64 bit.?  
  
"Niels Berglund" <nielsb@develop.com> wrote in message  
  
news:Xns975FC34A5B513nielsbdevelopcom@207.46.248.16...

2/7/2006 8:53:48 AM    Re: sqlclr framework change
"skg" <skg@yahoo.com> wrote in  
  
news:ejFPapPKGHA.2036@TK2MSFTNGP14.phx.gbl:  
  
Hi there!  
  
My VS is running on 64-bit, however it is the same version as the 32-bit  
  
(there are no 64-bit version).  
  
Are you absolutely sure that the SQL Server you deplopy to is 64 bit? If  
  
so, compile your assembly with the anyCPU flag and try it and see what  
  
happens.  
  
Alternatively you can use my SqlClrProject (from here [0]), which allows  
  
you to do autometic deployment etc, plus quite a bit more.  
  
Niels  
  
[0]: http://staff.develop.com/nielsb/code/deploypropandaddin.zip  
  
--  
  
**************************************************  
  
* Niels Berglund  
  
* http://staff.develop.com/nielsb  
  
* nielsb@no-spam.develop.com  
  
* "A First Look at SQL Server 2005 for Developers"  
  
* http://www.awprofessional.com/title/0321180593  
  
**************************************************