MATLAB "JoinTwoDatabaseTablesExample" Error

Question

ILoveMATLAB 2021-5-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/832558-matlab-jointwodatabasetablesexample-error

回答： Adam Danz 2021-5-17

采纳的回答： Adam Danz

在 MATLAB Online 中打开

Matalb throws an error when running the following the "JoinTwoDatabaseTablesExample". What am I missing?

Step 1: Open Join Two Databse Table Example

openExample('database/JoinTwoDatabaseTablesExample')

Step 2: Run first section of Code

%% Join Two Database Tables
% Use an ODBC connection to import product data from an inner join between
% two Microsoft(R) SQL Server(R) database tables into MATLAB(R). 
%%
% Create an ODBC database connection to a Microsoft SQL Server database
% with Windows(R) authentication. Specify a blank user name and password.
% The database contains the tables |productTable| and |suppliers|.
datasource = 'MS SQL Server Auth';
conn = database(datasource,'','');

Step 3: MATLAB throws the following error message.

Error using database (line 59)
Unable to access data source name. Use databaseConnectionOptions to create a data source. Use
configureODBCDataSource to create an ODBC data source.
Error in JoinTwoDatabaseTablesExample (line 10)
conn = database(datasource,'','');