Connecting To SQL Server

[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());
}

}
}

[felixtfelix]

hi,

You have to add sqljdbc.jar to your classpath. That is the file which will connect with database with JDBC driver. Any queries please feel free.

Regards

Felix T

[rmaadil]

I have used the following command in the command prompt to set the classpath but its not working yet. Help me ASAP

set classpath=C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_1.2\enu\sqljdbc.jar

[felixtfelix]

Hi,

It seems that you are connecting with SQL SERVER 2000. So add the following three files to the class path

1.Add the follwing files in the classpath
1.msbase.jar
2.mssqlserver.jar
3.msutil.jar


Regards

Felix

[rmaadil]

I am connecting with SQL Server 2005.

[felixtfelix]

hi,

Then you have to use the following DBDRIVER

com.microsoft.sqlserver.jdbc.SQLServerDriver

Regards
Felix

[erichua]

your driver name is strange, make sure your driver jar and the driver name are corret.

[herfnai]

hello you must make odbc and:
Connection cn=null;
Statement stm=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn=DriverManager.getConnection("jdbc:odbc:database name");
stm=cn.createStatement(ResultSet.TYPE_SCROLL_SENSI TIVE,
ResultSet.CONCUR_UPDATABLE);
JOptionPane.showMessageDialog(null,"connected");

}catch(Exception e)
{JOptionPane.showMessageDialog(null,"eroor" +"\n"+e.getMessage());


}