How do I connect a Unix based Java App to Windows based Ms Sql Server

[Sudmill]

Hi,


Im am looking for assistance to get a unix based java app connecting on a local network to a Windows based MS SQL Server to obtain information.

Any suggestions to a free and stable solution? If JDBC is the way to go how would I implement it across platforms?
Im pretty new to Java so any help would be greatly appreciated !

Cheers,

J. Cheers

John (Sudmill)

 

[Vepo]

Hi John,

You have to use JDBC-ODBC bridge,
page

http://developer.java.sun.com/developer/onlineTraining/Database/JDBCShortCourse/jdbc/jdbc.html

will illustrate how the things work.

-Vepo

 

[IPOz]

Please download the JDBC driver for SQL 2000 from

http://www.microsoft.com.It

is easy to use with the online help.
After downloading you shoud add 3 jar files to current JVM's classpath(msbase.jar;mssqlserver.jar;msutil.jar)
The following is codesnippet:
....

String sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr = "jdbc:microsoft:sqlserver://yourSQLserverBox:1433";

Class.forName(sDBDriver);
Connection conn = DriverManager.getConnection(sConnStr,"YourUser","YourPassword"
System.out.println( "Maximum row size: " + conn.getMetaData().getMaxRowSize() );
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from yourTable"
...

Regards! IPO_z@cmmail.com
Garbage in,Garbage out