Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sun JdbcOdbc bridge can not connect to ODBC DSN on win2008 64bit platform

843859Jun 7 2010 — edited Jan 19 2011
I am using sun JdbcOdbc bridge to connect to ODBC DSN on windows2008 64 bit platform. But it throws exception as following:
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

My source code is:
1. Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

2. Connection con = DriverManager.getConnection("jdbc:odbc:testdsndb","sysadm","");

3. System.out.println(con);

4. String dbname = con.getCatalog();

5. System.out.println("database name: " + dbname);

When the code execute to line 2, it throws exception.
I use window 2008 64 bit simple chinese platform. I tried jdk1.5, 1.6 64bit ,there are all have this problem.
Does anyone help me to solve this problem? And why that problem?

Thanks a lot!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2011
Added on Jun 7 2010
3 comments
3,864 views