Connection to DB on MSSQL

The driver string for connecting to MSSQL Server is "jdbc:jtds:sqlserver://localhost:1433/tempdb".

If you know, how to connect to any database through jdbc, just replace the driver string. Also put the driver jar in your classpath. The default username for MSSQL Server is "sa" and there is not password.

For more on how to connect to a db through Jdbc, you can find documentations on sun's site.

First try yourself and post whatever you have tried.

vineet.mangala at 2007-7-12 21:58:06 >

Thanks, aniseed.

I have downloaded the driver and installed it. Also added msbase.jar, msutil.jar and mssqlserver.jar to the classpath. But there is some another error. Here is my code

/**

* @(#)Test.java

*

*

* @author

* @version 1.00 2007/6/29

*/

import java.sql.*;

public class Test {

static String jdbcDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";

static String url = "jdbc:microsoft:sqlserver://universal:1433;DatabaseName=borej;User=sa;Password=";

static String SQLCreate =

"CREATE TABLE CONTACT_INFO ("+

"CONTACT_ID INTEGER NOT NULL PRIMARY KEY,"+

"FIRST_NAME VARCHAR(20) NOT NULL,"+

"MI CHAR(1) NULL,"+

"LAST_NAME VARCHAR(30) NOT NULL,"+

"STREET VARCHAR(50) NOT NULL,"+

"CITY VARCHAR(30) NOT NULL,"+

"STATE CHAR(2) NOT NULL,"+

"ZIP VARCHAR(10) NOT NULL"+

");";

public Test() {

try{

Class.forName(jdbcDriver);

}

catch(ClassNotFoundException e){

System.err.println(e.getMessage());

}

}

public void execute(String SQLCommand){

try{

Connection con = DriverManager.getConnection(url);

Statement stmt = con.createStatement();

stmt.execute(SQLCommand);

con.close();

}

catch(SQLException e){

System.err.println(e.getMessage());

}

}

public static void main(String[] args) {

Test test = new Test();

test.execute(SQLCreate);

}

}

ERROR is:

Couldn't establish socket.

Please tell me what is my fault, what I did wrong.

er_nsta at 2007-7-12 21:58:06 >

Hi, guys.

I have not found solution yet.

When I am trying with JTDS

Class.forName("net.sourceforge.jdbc.jtds.Driver")

DriverManager.getConnection("jdbc:jtds:sqlserver://localhost:1433/master;user=sa;password=") ;

I am getting IONetwork exception connection: Connection refused.

When I am trying on JDBC SQL Driver 2000

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

DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433","sa",""):

I am getting exception: Error establishing socket. Anyone please help me.

er_nsta at 2007-7-12 21:58:06 >

Can u check ur connectionUrl anf Class.forName

try this out

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

connection=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;User=abc;Password=xyz")

n have to set classpath for SQLjdbc driver?

try the help web page tht is thr where u have installed/downloaded SQl JDBC drivers........

Good Luck...

hetal_giria at 2007-7-12 21:58:06 >