Complete package for connecting to, querying, and closing connections to SQL, Oracle, and MS Access databases.
The main advantage of these functions is that they implement a "DSN-less" connection, which means you can run queries against a server without having to first add the datasource to your ODBC Data Source Administrator.
Just input the server name, database name, and optional uid/pwd to open a connection using an ActiveX control.
It takes only 4 lines of code to open a connection, run a query, and close the connection. It's that simple!
引用格式
Tim Myers (2024). database connection mfiles (https://www.mathworks.com/matlabcentral/fileexchange/8385-database-connection-mfiles), MATLAB Central File Exchange. 检索来源 .
MATLAB 版本兼容性
平台兼容性
Windows macOS Linux类别
- Reporting and Database Access > Database Toolbox >
- Computational Finance > Database Toolbox >
- MATLAB > External Language Interfaces > COM with MATLAB > Use COM Objects in MATLAB >
标签
致谢
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!版本 | 已发布 | 发行说明 | |
---|---|---|---|
1.0.0.0 | Updated oledbquery.m to enable inerting and updating records. Added examples to README.txt. Added help text in catch section of oledbcn.m when database connection cannot be made. |