MATLAB: Do I get the error “Invalid string or buffer length” when using an ODBC driver with the Database Toolbox on Windows 64-bit

64bitdatabaseDatabase Toolboxjdbcodbcserversql

I am attempting to retrieve data from my database over an ODBC connection using Database Toolbox. When using the Query Builder or command line functions, I receive the following error:

 [Microsoft][ODBC Driver Manager] Invalid string or buffer length Please verify that login information and database url are valid.

Best Answer

If you receive this message you may be using the wrong driver. For nearly all databases, you must use JDBC drivers with 64-bit machines.

This information can be found in the documentation:

http://www.mathworks.com/help/releases/R2011b/toolbox/database/ug/bq89k8o-1.html#bq89k8p-5

Related Solutions

MATLAB: Do I get the ??? Undefined function or variable ‘getTheMetaData’. error message with the Database Toolbox

This error message indicates that you are trying to connect to a database in read-only mode. The MATLAB Visual Query Builder does not support read-only connections. You initially will be able to connect to the database with a read-only username and password; but subsequent operations will generate errors.

To make a read-only connection, use the command line functionality of the Database Toolbox. e.g.

% Make connection to a database called SampleDB with username
% scott and password tiger
conn=database('SampleDB','scott','tiger');
% Execute a valid SQL statement against the database connection, conn
% and opens a cursor
curs = exec( conn, 'select freight from orders' );
% Import data from the open SQL cursor curs.
curs = fetch(curs);

For more information on using the Database Toolbox functions, please refer to Chapter 3 of the Database Toolbox User's Guide.

MATLAB: Access Apache Hive using ODBC driver

I've tested Hive access via JDBC Driver, but not ODBC Driver yet, but I think possibly, yes.

First, 64 bit ODBC Driver is requied.

Next, configure ODBC data source in Database Toolbox. And I think you can access to Hive

datasource = 'Hive'; % The name of datasource specified in configureODBCDataSource
username = 'XXX';
password = 'YYY';
conn = database(datasource, username, password);
selectquery = 'SELECT TOP 10 * FROM TABLENAME';
data = select(conn,selectquery);

Ref: https://www.mathworks.com/help/database/ug/database.html#btcofz6

Best Answer

Related Solutions

MATLAB: Do I get the ??? Undefined function or variable ‘getTheMetaData’. error message with the Database Toolbox

MATLAB: Access Apache Hive using ODBC driver

Related Question