jdbc connection to mssql2000 db server

[mohan kannan]

Hi all
I am using jdbc-odbc driver to connect to mssql2000 database.
The code used is below

    public void connect() throws ClassNotFoundException, SQLException, Exception
    {
        try 
        {
            // Load the Driver class file
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            // Make a connection to the ODBC datasource 
            con = DriverManager.getConnection("jdbc:odbc:Dsnname","username","password");
        }
        catch (ClassNotFoundException cnfe) 
        {
            error = "Error No. 1 : ClassNotFoundException: Could not locate DB driver.";
            throw new ClassNotFoundException(error);
        }
        catch (SQLException cnfe) 
        {
            error = "Error Number. 2 : SQLException: Could not connect to DB.";
            throw new SQLException(error);
        }
        catch (Exception e) 
        {
            error = "Error No. 3 : Exception: An unknown error occurred while connecting to DB.";
            throw new Exception(error);
        }
    } // end of connect()

I have tested this code local system with "sa" rights (default user name and password) and works successfully for creating table, adding,listiing recpords.
But when uploading the files on server (Tomcat4.0.1) with exact user name and password provided by server administrator, and when run the related jsp's involving db connection, I am getting the following error
Error Number. 2 : SQLException: Could not connect to DB
Please suggest what's the problem.
pl suggest Whether sun.jdbc.odbc.JdbcOdbcDriver can be used on the web server?
Server administrator says the dsn is configured properly and user name and password are correct.
Thanks in advance
K.Mohan
[ Edited by Dave to format code and remove the UBB smilies ]
[ February 04, 2002: Message edited by: David O'Meara ]

[David O'Meara]

Doesn't seem like you're finding enough information. Have you tried printing cnfe.getMessage()?
I'd rethrow the same exception rather than throwing it with a new message, you're losing the original.

catch (SQLException sqle)
{
    System.out.println("SQLException: "+sqle.getMessage());
    throw sqle;
}

DOM

[Dave Vick]

Try printing the venor error code too, that might give you a clue if it a SQL Server problem.
sqle.getErrorCode();
Dave