Posts

Showing posts from March, 2008

JDTS Database Connectivity

I finally manage to connect my Java program to MS SQL Server 2000 using JDBC JDTS after 11 hours of understanding how to connect and configure things. I guess that’s the beauty of OpenSource tools you have to dedicate most of your time in learning things but I am pretty much sure after this painful learning curve things will get smooth.

Here is the Simple Code:
import java.sql.*;

public class NewApplication {

public static void main(String[] args){
Connection conn;
try{

Class.forName("net.sourceforge.jtds.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:jtds:sqlserver://ADVENT/DNS;user=mark;password=mark;namedPipe=true");
System.out.println("Successfully connected");
conn.close();
}
catch(Exception e){
System.err.println("Unable to connect");
e.printStackTrace();
System.exit(1);
}


}
}


Though I can search a lot o…