This question probably was asked quite a lot of times, but anyway.

In order to use a JDBC driver (the SQL server2000 one to be more specific), I need to set the "classpath" to

".;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar" (these are the three files that I need and are found exactly in this place).

However, when I try the statement

"Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");"

I get the ClassNotFoundException error message.

I was told to put the statement in the control panel/system/advanced/environment variables. Is there something that I am not doing right? I reboot after puting it there and it didn't work after that either. I am using Windows 2000(both pro and server as I program in my computer then put the whole thing in the server).