PDA

View Full Version : Run SQL can't find osql.exe


Ron100
11-11-2009, 03:07 PM
We recently uninstalled SQL Server 2005 from a build machine, then reinstalled. Visual Build Pro 6 build programs using the Run SQL action now fail, with a message like the following:

osql -S BuildSQL -d MasterBackup -U user -P pass -b -n -w 10000
Failed to create process: The system cannot find the file specified.

I can see that osql.exe exists in the following folder:
C:\Program Files\Microsoft SQL Server\90\Tools\Binn

I also cannot launch osql from the Windows Command prompt. I'm assuming some environment variable or registry entry has been deleted and/or modified - can anyone tell me what I need do to fix this problem?

kinook
11-11-2009, 03:17 PM
http://www.kinook.com/VisBuildPro/Manual/sqlopttab.htm

Ron100
11-11-2009, 03:32 PM
Thanks - I cured the problem by rebooting the machine.