database connection mfiles
Queries datasource directly w/o requiring mods to ODBC Data Source Administrator.
You are now following this Submission
- You will see updates in your followed content feed
- You may receive emails, depending on your communication preferences
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!
Cite As
Tim Myers (2026). database connection mfiles (https://in.mathworks.com/matlabcentral/fileexchange/8385-database-connection-mfiles), MATLAB Central File Exchange. Retrieved .
Acknowledgements
Inspired: ADO OLE Database Connection, adodb_tools
General Information
- Version 1.0.0.0 (13.2 KB)
MATLAB Release Compatibility
- Compatible with any release
Platform Compatibility
- Windows
- macOS
- Linux
| Version | Published | Release Notes | Action |
|---|---|---|---|
| 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. |
