User`s guide

Connecting to a Database Using the Native ODBC Interface
3-21
Item Native ODBC JDBC/ODBC Bridge JDBC
Data type support Long data types are
not supported (e.g.
LONG, BLOB, etc.)
Long data types are
supported
Long data types are
supported
Note: For details about the database.ODBCConnection syntax, see the native ODBC
interface example in database.
Compatibility and Limitations
The native ODBC interface has the following compatibility and limitation considerations:
• Native ODBC database connections are supported on MATLAB 32-bit and 64-bit
versions using the database function. The native ODBC interface supports 64-bit
database vendors. This interface is backward compatible for 32-bit versions. The
bitness of MATLAB must always match the bitness of the database driver.
• The native ODBC interface is available only for the command line. You cannot use
Database Explorer to access the native ODBC interface.
• The native ODBC interface does not support long data types such as Oracle LONG and
SQL Server NTEXT. You are accessing an unsupported data type if one of these errors
displays:
• Driver unable to retrieve length for column number: <index of column in the
query>
• Out of memory. Type HELP MEMORY for your options.
More About
• “Selecting Data Using the exec Function” on page 6-40
• “Importing Data Using the fetch Function” on page 6-48