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
Citar como
Zhiqiang Zhang (2024). adodb class (https://www.mathworks.com/matlabcentral/fileexchange/28983-adodb-class), MATLAB Central File Exchange. Recuperado .
Compatibilidad con la versión de MATLAB
Compatibilidad con las plataformas
Windows macOS LinuxCategorías
Etiquetas
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Descubra Live Editor
Cree scripts con código, salida y texto formateado en un documento ejecutable.
@adodb/
Versión | Publicado | Notas de la versión | |
---|---|---|---|
1.0.0.0 |