[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 697
  • Last Modified:

Interpreting VBScript in Under 64-bit OS

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.
0
NOVBusApps
Asked:
NOVBusApps
  • 4
  • 3
2 Solutions
 
exx1976Commented:
Not sure if this will work on server 2008, but here's an x64 version of WSH for 2003..


http://support.microsoft.com/?id=955360



HTH,
exx
0
 
NOVBusAppsAuthor Commented:
Thanks exx1976.
However, that didn't work.  Despite the article's mentioning of x64 system, the file I downloaded following the link on the article didn't even install on Win 2003 X64 systems (Error message: the Windows Script is intended for a different hardware platform)
0
 
grayeCommented:
Hang on... I can't image that creating an SQL fail over cluster would have anything to do with WOW support.   Can you point us to the documentation that lead you to that conclusion?
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
NOVBusAppsAuthor Commented:
Graye,
That is according to MS documentation here:
http://msdn.microsoft.com/en-us/library/ms143506.aspx
Search for "WOW64 is not supported for SQL Server failover cluster installations" on this page.  It's repeated 8 times on the page!!!
0
 
grayeCommented:
You are correct in that's exactly what it says...   However, I really don't believe that's what they meant to say.
I think its just a matter of wording... instead of "WOW64 is not supported for failovers", it should have said: "Failover clusters are not supported in WOW64"
Or, to paraphrase:  "You can not create a SQL cluster configuration using the 32-bit version of SQL Server on a 64-bit version of Windows"
I have posted a "community comment" for Microsoft to correct their documentation.  (You can see my comment at the end of the link)
0
 
NOVBusAppsAuthor Commented:
Graye,
I've read your comment, and you have a convincing point.  You may be correct, because it does makes little sense why SQL cluster installation would break WOW64.  However, I to would like to have better confidence before purchasing hardward and go through the trouble of setting up the cluster.  Do you know for fact that WOW64 support is still in tact?
0
 
grayeCommented:
Well, I'm 99.999% sure... but I'll confess that I have not tried it.
On the other hand, Microsoft is usually pretty prompt about making corrections to their documenation.  (I send them lots of comments/corrections).  It typically takes less than a week for them to respond.
0
 
NOVBusAppsAuthor Commented:
We are going to order the servers and try anyway.  Will report back if it works.  Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now