Having problem in connecting with SQL Server 2005

[rmaadil]

I am using the following code for getting connection to the SQL Server 2005 Database:

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

I have debuged the code by placing a breakpoint exactly at this line and whenever I step over this statement it generates an exception and then when I print the message in the catch block, I got the following message:

com.microsoft.jdbc.sqlserver.SQLServerDriver

which is exactly the string I am passing to the above function.

Can anybody help me?

[danielstoner]

what exception is that? Do you have the library in the path?

[rmaadil]

Can u explain me that how to include the library u r talking about. I am new to java so I don't have much knowledge about the language. Kindly elaborate.

I will be thankful to u.

[rmaadil]

Here is the code that I have written to get a connection to the SQL Server. I have also set the classpath. But still I am getting error. I have debugged the code and when I step over the Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver"); it generates an exception and the message that is printed is the string that is the parameter to the function forName. I am struck as I have searched a lot of forums and I haven't found this kind of error. Most of the errors that came due to classpath settings was "drievr cannot be found" but I think my error is not because of the classpath settings. Can anyone help me?

public class Main {


public static void main(String[] args) {

try
{

Class.forName("com.microsoft.jdbc.sqlserver.SQLSer verDriver");
Connection con = DriverManager.getConnection("jdbc:microsoft:sqlser ver://localhost:1433; DATABASENAME = Test","mimdad","aaa");
}
catch (Exception e)
{
System.out.println(e.getMessage());
}

}
}

[danielstoner]

Did you notice you have a space in the name of the class?

"com.microsoft.jdbc.sqlserver.SQLSer verDriver" !!!

and also in the URL:

"jdbc:microsoft:sqlser ver://localhost:1433; DATABASENAME = Test"

Is that just a typo?

Read more about what should be in your classpath here: HOW TO: Get Started with Microsoft JDBC