mySQL driver

[Ayad Hindi]

Hi,
I downloaded the latest mySQL driver(mm.mysql-2.0.14) and unjared it into C:\mm.mysql-2.0.14.
So far so good.
I wrote a simple java program in Visual Cafe to access mySQL database using the dirver. I put the driver's home directory (C:\mm.mysql-2.0.14) in the directories for the visual cafe project, and it works perfectly.
Now, when I try to run it from the command prompt, previously setting my classpath and path enviroment variables to C:\mm.mysql-2.0.14, it gives me:
java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
Why is it not finding it?? I've been playing with my classpath all day to get java.exe work (now it does thanks to the posts here) and when I finally get it this other classpath problem comes up
Can anyone help me please?
Thanks
Ayad Hindi

[Gregg Bolinger]

Could you please post what you are typing at the command prompt to try and execute your java program. You also might want to show us your directory structure where your class files are located.
Thanks.

[Marilyn de Queiroz]

If you go to this page and follow a link under JavaRanch Cattle Drive - JDBC, you may find something helpful.
[ June 28, 2002: Message edited by: Marilyn deQueiroz ]

[SoonAnn Lim]

Sound's like your classpath is not set correctly for your driver. Echo your class path to check if mm.mysql driver is in the path.

[Ayad Hindi]

Thanks for everyone for their replies.
The driver now works, I just needed to restart my computer !!!
Weird, I didn't need to restart for the jdk classpath but mysql driver I do.
Anyway, thanks for the help
Ayad Hindi