Script Component can't find the binary code

Dear all：

I have set the PrecompileScriptIntoBinaryCode property to true,but the Script Component show the message "can't find the binary code" after I finish the script language and save it . What's wrong with it ? I ever tried the same code, and it's OK with no problem. When did the problem happen ?

Please give me a help ....Thanks a lot!

If you are using a x64 Machine then you may face this problem. Under project properties, Debug option, set Run64bitRuntime to false. Now edit your script and save.. Reply if that persists..

Thanks

Subhash Subramanyam

|||And if you're not on 64-bit, make sure you have SP2 installed for SQL Server. (If you just recently applied the Microsoft patches, including the .Net 2.0 security fix, then your scripts will break.)|||

Hi all,

We are running on 32 bit machines with SP2 but still encountered this problem with script components that have been running for months without error. Even if I set almost all code to comment this persists.

This first appeared after the installation of the Microsoft July Security Patches MS07-036 --> MS07-041.

In the end, I was forced to set for these script components precompile to false. Does anyone know if a fix for this problem is planned in a future MS patch?

Kind regards,

|||

Paul,

Take a look through here for a hotfix:

http://support.microsoft.com/kb/931846

|||

Dears,

My problem was solved after installing SQL Server 2005 SP2.

I am in the same situation with Paul . The problem occured since I installed Windows Patches .

Phil, Thank you a lot~~