How can I access MS SQL Server from MATLAB web application

15 views (last 30 days)
I am trying to connect to a MS SQL Server with success when using this code:
datasource = "NAME";
username = "xxx";
password = "yyy";
conn = database(datasource,username,password);
However, when i wnat to specify connection details to be able to connect from a deployed web application I get en error
databasename = "NAME";
username = "xxx";
password = "yyy";
driver = "";
url = "jdbc:sqlserver://localhost:1433;databaseName=NAME";
javaaddpath('C:\Microsoft SQL server\sqljdbc_8.4\enu\mssql-jdbc-8.4.1.jre8.jar');
conn = database(databasename,username,password,driver,url);
This is the error I get
Error using database (line 59)
Unmatched parameter name '' must be a string scalar or character vector
that can represent a field name.

Answers (1)

Tamir Suliman
Tamir Suliman on 1 Sep 2020
Edited: Tamir Suliman on 1 Sep 2020
you could attempt to remove that line making sure data source is specified if I m reading the matlab documentation correctly or use ' instead of "





Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!