Can't connect to driver sun.jdbc.odbc.JdbcOdbcDriver

[ProgrammingB52]

Below is my code and I am getting a connection unsuccessful error. I am trying to use a sql server database. I didn't do anything in the control panel odbc datasources.

try
{
String url = "jdbcdbc:employeeExpense";

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbConn = DriverManager.getConnection(url);
msgOut.insert("Connection successful\n", 0);
msgOut.select(0, 0);
}

catch (ClassNotFoundException cnfex)
{
cnfex.printStackTrace();
msgOut.insert("Connection Unsuccessful\n" + cnfex.toString(), 0);
msgOut.select(0, 0);
}

 

[ProgrammingB52]

Got it working. What it was was in the control panel for ODBC datasources the sql server driver had to be set to windows authentication mode.

 

[stefanwagner]

Try to get an real jdbc-driver (I guess jnetdirect is a free and opensource driver for ms-sql).

seeking a job as java-programmer in Berlin:

http://home.arcor.de/hirnstrom/bewerbung