Hi All,
I have created a system DSN using ODBC administrator to connect to SQL Server 2008 database using SQL Server Native Client 10.0.
My system configuration is :
Windows Server 2008 R2 64 bit
SQL Server 2008 64 bit
JDK 6.0.18 64 bit
Now when I try to connect to database using this DSN and JDBC-ODBC bridge, I get the following exception:
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)
The same code works fine on my 32 bit machine. Could it be an issue with the ODBC
JDBC bridge or am I doing something wrong here?
Tulika.