Database Toolbox is installed but MATLAB can't locate most SQL-related commands?

Question

Sofie Herbeck 2022-6-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1746875-database-toolbox-is-installed-but-matlab-can-t-locate-most-sql-related-commands

回答： Abhijeet 2023-9-6

Screen Shot 2022-06-23 at 12.50.25.png

I installed Database Toolbox (v10.2) on MATLAB 2021b a few days ago, and can run the sqlite command, but that's about all—most of the SQLite commands listed on this page don't work. They trigger errors, e.g. "Unrecognized function or variable 'sqlwrite'." As you can see in the attached screenshot, MATLAB can't locate most of the commands (and can find execute, but I believe it's a different function than the one that's supposed to be used with databases).

Does anyone have any tips on how to troubleshoot this issue? I couldn't find any other questions about this, so I'm wondering if there was something else I was meant to install along with the Database Toolbox to get access to the full range of commands?

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

请先登录，再进行评论。

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

Answer 1

Abhijeet 2023-9-6

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1746875-database-toolbox-is-installed-but-matlab-can-t-locate-most-sql-related-commands#answer_1302661

Hi Sofie,

I understand that you are getting "Unrecognized function or variable 'sqlwrite' error while using ‘sqlwrite’ function. 'sqlwrite' is a method of the 'connection' object and can only be called on an instance of 'connection' object.

Since the function exists within the class, MATLAB does not know of its existence without having access to an instance of the class and therefore throws the error you are seeing. Please ensure that you are creating a connection and passing it to the 'sqlwrite' function using ‘connection’ object.

Please follow the steps below to set up and connect to an SQL server:

https://uk.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html

I hope this information was helpful! 