Dear,
but if i am using JDK 1.4 , why i cant connect to SQLSERVER 2008..???
is there any solution for that?
Regards

Please check if driver is available in runtime environment. If using eclipse, add to build path

Jenifer Rajkumar :
I am using microsoft sql server2008 i download Microsoft SQL Server JDBC Driver 3.0 and i set the class path as C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar; and my program is
import java.sql.*;
class Example
{
public static void main(String args[])
{
try
{
// Load the SQLServerDriver class, build the
// connection string, and get a connection
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
String connectionUrl = “jdbc:sqlserver:SQL1:sqlexpress;” +
“database=MyDatabase;” +
“user=sa;” +
“password=Admin123″;
Connection con = DriverManager.getConnection(connectionUrl);
System.out.println(“Connected.”);
// Create and execute an SQL statement that returns some data.
String SQL = “SELECT * FROM MyTable”;
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQL);
// Iterate through the data in the result set and display it.
while (rs.next())
{
System.out.println(rs.getString(1) + ” ” + rs.getString(2));
}
}
catch(Exception e)
{
System.out.println(e.getMessage());
System.exit(0);
}
}
}
While compiling time no error but running time iam getting no suitable driver found for “jdbc:sqlserver:SQL1:sqlexpress;” +
“database=MyDatabase;” +
“user=sa;” +
“password=Admin123″;
please solve my issue.

I am using microsoft sql server2008 i download Microsoft SQL Server JDBC Driver 3.0 and i set the class path as C:\Program Files\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar; and my program is
import java.sql.*;

class Example
{
public static void main(String args[])
{
try
{
// Load the SQLServerDriver class, build the
// connection string, and get a connection
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
String connectionUrl = “jdbc:sqlserver:SQL1:sqlexpress;” +
“database=MyDatabase;” +
“user=sa;” +
“password=Admin123″;
Connection con = DriverManager.getConnection(connectionUrl);
System.out.println(“Connected.”);

// Create and execute an SQL statement that returns some data.
String SQL = “SELECT * FROM MyTable”;
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(SQL);

// Iterate through the data in the result set and display it.
while (rs.next())
{
System.out.println(rs.getString(1) + ” ” + rs.getString(2));
}

}
catch(Exception e)
{
System.out.println(e.getMessage());
System.exit(0);
}
}
}

While compiling time no error but running time iam getting no suitable driver found for “jdbc:sqlserver:SQL1:sqlexpress;” +
“database=MyDatabase;” +
“user=sa;” +
“password=Admin123″;

please solve my issue.

Thanks for your kind words Deepti. We are glad it was helpful.

Thanks a lot. Recently, we migrated to sqlserver 2008 and your article proved to be very helpful