What are the known 64-bit JDBC/ODBC bridge issues?

Hello,

On the following page there is a reference to 64 bit issues with the JDBC/ODBC bridge. Please could you let me know what these are, in particular the "data access" issues?

http://www.mathworks.com/help/database/ug/using-native-odbc-connection.html#bt1ihqi-1

I am experiencing occaisional problems retrieving data from a 64-bit version of matlab. This has never been a problem on the 32-bit version. Only a few rows are returned from the fetch function and the data is spread across too many columns which causes a subsequent crash.

Thanks, Scott

Answer 1

[Scott]

The data retrieval issues I'm experiencing sound very similar to the ones in this thread:

http://www.mathworks.co.uk/matlabcentral/answers/35887-wrong-data-size-being-returned-by-fetch-64-bit-databasetoolbx

I'm currently using the JDBC/ODBC bridge. The errors have sporadically started since switching to 64 bit (R2008a). If there are "several known issues with connectivity and data access" when using the "JDBC/ODBC Bridge" on "64-bit systems" as per the following page, then can anyone please confirm what the known issues are, and if switching to either the pure native or pure Java adapters is likely to help with the problems I'm experiencing?

http://www.mathworks.com/help/database/ug/using-native-odbc-connection.html#bt1ihqi-1