image thumbnail

adodb class

version 1.0.0.0 (5.44 KB) by Zhiqiang Zhang
adodb is a class to query database using ADODB

1.1K Downloads

Updated 09 Oct 2010

View License

adodb is a class to query database using ADODB

The main method of adodb is adodb.query
[res, isSuccess] = adodb.query(sql, ado_connection_string), query the
database which is specified by ado_connection_string.

ado_connection_string could be a connection string, or just provide
following information in 5*1 cells or a struct
type: connection type - currently supported: 'Access','SQL','Oracle'
server: name of server - not required for Access connection
databasename: name of database - not required for Oracle connection
user, user id to login - added to connection string if provided
password: password to login - added to connection string if provided

adodb.queryvar is an alternative of query when you only need the first
result.

usage examples

ado = adodb;
res = ado.query('select * from sys', ...
'Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;');
res = ado.query(sql, {database_type, server_name_or_ip, ...
database_name, user, password});

See also: adodb/query, adodb/queryvar, adodb/connstr

Copyright: zhang@zhiqiang.org, 2010
http://zhiqiang.org/blog/it/use-adodb-in-matlab.html

Cite As

Zhiqiang Zhang (2021). adodb class (https://www.mathworks.com/matlabcentral/fileexchange/28983-adodb-class), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2010b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Tags Add Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!