I am using SQL Server 8.0 and I am having troubles connecting to it from my Java program, I am currently working on my local machine, I have daownloaded Microsoft's driver and I am using the following statement to connect:

Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");

It compiles OK, but results in an execution error. Can somebody help me to connect to SQL Server. Any help would be appreciated.