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

Question

Hans Nerlich 2023-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1985029-is-there-a-way-to-use-odbc-connection-with-app-designers-web-app

编辑： Jannik Schröder 2023-7-17

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Praveen Reddy 2023-6-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1985029-is-there-a-way-to-use-odbc-connection-with-app-designers-web-app#answer_1262318

编辑：Praveen Reddy 2023-6-26

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

2 个评论
显示无隐藏无

Hans Nerlich 2023-6-26

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 2023-7-17

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.

请先登录，再进行评论。