adodb class
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 (2024). adodb class (https://www.mathworks.com/matlabcentral/fileexchange/28983-adodb-class), MATLAB Central File Exchange. Retrieved .
MATLAB Release Compatibility
Platform Compatibility
Windows macOS LinuxCategories
Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Discover Live Editor
Create scripts with code, output, and formatted text in a single executable document.
@adodb/
Version | Published | Release Notes | |
---|---|---|---|
1.0.0.0 |