kris1229 wrote:A DSN defines the source to connect to. It is not the source.
I am using sun JdbcOdbc bridge to connect to ODBC DSN on windows2008 64 bit platform.
But it throws exception as following:As a guess DSN is corrupted or otherwise wrong. Delete it, recreate it using the ODBC applet. And then test it in that applet.
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
Connection con = DriverManager.getConnection("jdbc:odbc:testdsndb","sysadm","");Try null for the last value.