database connection mfiles

Version 1.0.0.0 (13.2 KB) by Tim Myers
Queries datasource directly w/o requiring mods to ODBC Data Source Administrator.
9.7K Downloads
Updated 23 Mar 2007

View License

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 (2024). database connection mfiles (https://www.mathworks.com/matlabcentral/fileexchange/8385-database-connection-mfiles), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2006b
Compatible with any release
Platform Compatibility
Windows macOS Linux
Acknowledgements

Inspired: 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!
Version Published Release Notes
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.