Generic Script Resource | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Generic Script ResourceHi, We have a Health Care app that is installed on SQL Server 2005 EE 654 bit Cluster with Windows 2003 R2 64bit. This app doesn’t reconnect users upon failover. As a result I would like to use the "Generic Script" resource which will call a Windows Script Host script and reset our IIS server.
I followed the following link: http://msdn2.microsoft.com/en-us/library/aa369319(VS.85).aspx
I’m using VBScript option within and to test out I added the following script:
Set ss = CreateObject("WScript.Shell")
If I run this of a command prompt on each node, this just works fine, but If I were to embedd this in the Generic Script resource using wscript <script name>, the following error message pops:
"An Error occured attempting to set the properties. The filename, directory name or volume label syntax is incorrect"
Appreciate any help on this. Thanks
I don’t see its a SQL related problem and have you checked under VS 2005 based forums in thsi regard.