Setup/Configure a DSN-less database without the Database Toolbox GUI MATLAB R2018b

Please how do I setup a DSN-less database connection without using the Database Toolbox GUI on MATLAB R2018b?

Answer 1

[Piyush Kumar]

@Emeka Udeogu,

There is a function odbc, introduced in R2021a which allows us to create a connection to a database using a DSN-less connection string. (DSN is a data source name.)

Please check this page for some examples - https://www.mathworks.com/help/database/ug/odbc.html#d126e39668

Since you are using R2018b, you must upgrade the MATLAB version to use this function.