I've got a Windows Service app I wrote that requires three new tables and several views and SPs to be created. I've got a complete script that works and have added a custom action in the form of a VBS file that references the script file.
My vbs file looks like this
Set WSHShell = CreateObject("Wscript.Shell")
WSHShell.Run ("sqlcmd -S OFFICE8995 -U sa -P mypassword -d DBName -i C:\Program Files\ITService\TestScript.txt")
I can run the TestScript in Query Analyzer and it works but the VBS file is not working. The database is a MSDE 2000 db and was hoping to use sqlcmd which I do have on this box. But the osq isnt working either.
How can I debug this? Anything obvious that I'm missing?
View Complete Post