We need to upgrade our SQL setup to an SQL-2008 server fail-over cluster, with 2 machines on Windows Server 2008 64-bit. The application, however, has the need to interpret user-entered VB Scripts at database tier. We currently have a CLR procedure to do that, but it in turn depends on MSScript.OXC for script interpretation. The propblem is, MSScript.OXC fails to load on all 64-bit OS we've tried unless the caller app is compiled using x86 (32-bit) option.
In our current set up (SQL 2005 / Windows Server 2003 single machine, no cluster), the workaround is a custom Windows service complied with x86 option to interface with MSScript.OCX. The MSSQL CLR procedure calls the custom service & pass the scripts to it, which in turn loads MSScript.OCX to perform script interpretation and returns result to the CLR procedure. In this set up, however, we're still depending on WOW-64 support by the OS.
From reading documentation on SQL-2008, I believe there will be no WOW-64 support if the systems are configured for SQL fail-over clustering. Thus, based on my understanding, there is a road block here.
Please advice if you see a solution to this. Evidently, if there is a native 64-bit way to perform interpretation of VBScripts, that will solve our problem. Anyone aware of a way to do that?
Thanks in advance for your help.