database connection mfiles
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!
Zitieren als
Tim Myers (2024). database connection mfiles (https://www.mathworks.com/matlabcentral/fileexchange/8385-database-connection-mfiles), MATLAB Central File Exchange. Abgerufen.
Kompatibilität der MATLAB-Version
Plattform-Kompatibilität
Windows macOS LinuxKategorien
- Reporting and Database Access > Database Toolbox >
- Computational Finance > Database Toolbox >
- MATLAB > External Language Interfaces > COM with MATLAB > Use COM Objects in MATLAB >
Tags
Quellenangaben
Inspiriert: ADO OLE Database Connection, adodb_tools
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!Live Editor erkunden
Erstellen Sie Skripte mit Code, Ausgabe und formatiertem Text in einem einzigen ausführbaren Dokument.
Version | Veröffentlicht | Versionshinweise | |
---|---|---|---|
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. |