FreeTDS Development Group

["Greg Chakmakian" <gregchak AT mac.com>]

Hi everyone.  I've gone through the user guide and think I have done
everything right.  I am running my JSP engine on OS X and am connecting to
SQL 7 on windows 2000.  I am trying to use the sample code that I found on
the freetds site. Below is the code I am using:

String url =
"jdbc:freetds:sqlserver://dbserver:1433/northwind;CHARSET=cp950;TDS=7.0;";
String login = "sa";String password = "";
Class.forName("com.internetcds.jdbc.tds.Driver");
Connection connection  = DriverManager.getConnection(url, login,
password);

Every time it fails on the "Connection" line.  Below is the error:

java.sql.SQLException
        at
com.internetcds.jdbc.tds.Constructors.newConnection(Constructors.java:305)
        at com.internetcds.jdbc.tds.Driver.connect(Driver.java:257)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:177)


I'm not sure if I have compiled something wrong, or if I'm referencing
something wrong.  I have compiled it with the --with_tdsver=7.0 argument. 
Any help I could get would be much appreciated.  Thanks in advance.

-greg