PATH not working?

[anorakgirl]

I have added a location (C:\mysql\bin) to my Path Environment Variable (System not USer).

When I type show PATH at a command prompt, it includes the new directory:
Path=C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem; C:\mysql\bin;C:\Program Files\Microsof
t SQL Server\80\Tools\BINN; C:\j2sdk1.4.2_02\bin; C:\java\ant\bin;
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH


But when I type the name of a command in that directory, it doesn't find it, and I get
C:\>mysql
'mysql' is not recognized as an internal or external command,
operable program or batch file.

mysql.exe is definitely in C:\mysql\bin. The same problem occurs for other files in my PATH too, but it looks right to me. Has anyone come across this? I have rebooted, I have no User PATH env variable...

Thanks for any ideas!
Tamsin


~

http://www.anorakgirl.co.uk

~

 

[anorakgirl]

Just been given the solution on the Microsoft news groups -For info: the PATH stops being processed when an error is encountered, and in my case the leading space before C:\mysql\bin is breaking it...

~

http://www.anorakgirl.co.uk

~

 

[bcastner]

C:\Program Files\Microsoft SQL Server\80\Tools\BINN

Get rid of that last N in BINN.

 

[anorakgirl]

actually the path to the SQL Server tools executables on my PC is C:\Program Files\Microsoft SQL Server\MSSQL\Binn, as I say the problem was the space in front of some of the entries.
Thanks anyway!

~

http://www.anorakgirl.co.uk

~