Is there a way to use odbc connection with App Designers Web App?

I have a already developed Matalb Standalone App, that is using a ODBC connection the get data from a server.

Now I want that to be compiled as a web app. Is there a way to have a ODBC connection in a web app?

note: I found a answer for using JDBC in web apps..

https://de.mathworks.com/matlabcentral/answers/1657725-how-do-i-connect-to-an-ms-sql-database-through-jdbc-in-a-deployed-web-app

Answer 1

[Praveen Reddy]

Hi Hans,

I understand that you want to deploy Web App with ODBC connection. Database Toolbox helps to connect to any relational ODBC-compliant using ANSI SQL. Please make sure you have already installed appropriate ODBC driver. Once ODBC driver is installed, you can create a data source and establish connection to your database. For establishing ODBC database connection, you can refer the following documentation.

https://www.mathworks.com/help/database/ug/odbc.html

For more information about Database Toolbox, please refer the following documentation:

https://www.mathworks.com/help/database/getting-started-with-database-toolbox.html

[Hans Nerlich]

Hi Praveen,

Thanks for your answer!

I have no problem with connection to the database, I can compile the app with App designer to a standalone app and this app is working fine when the user is installing adn set up the odbc adapter. But we are searching for a solution where the user is not need to install the app and not need to install the odbc adapter, (because every time are admin rights involved, and this is ugly!) so I tried to compile the app in Web designer to Web app, so that the user can see it in the browser.

So I need to install the ODBC driver on the web app server?

OR is is better to user JDBC connection for this?

Is it possible that multible users are using the web app at the same time?

[Jannik Schröder]

The answers to your questions can be found in the MATLAB Answers post that I linked in a seperate answer to this question. It is possible that multiple users are using the Web App at the same time.

Answer 2

[Jannik Schröder]

Please note the following MATLAB Answers post that has been published recently and deals with the same topic:

https://www.mathworks.com/matlabcentral/answers/1996108-how-do-i-connect-from-a-web-app-to-a-database-using-odbc-driver