MATLAB "JoinTwoDa​tabaseTabl​esExample" Error

1 回表示 (過去 30 日間)
ILoveMATLAB
ILoveMATLAB 2021 年 5 月 17 日
回答済み: Adam Danz 2021 年 5 月 17 日
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,'','');

採用された回答

Adam Danz
Adam Danz 2021 年 5 月 17 日
There are several steps needed to set up a data source and connect to Microsoft SQL Server database or Azure Synapse SQL.
They are explained here
You'll see at step #3 in the first link that the line you're executing assumes that you are connecting to a data source named MS SQL Server Auth.

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeDatabase Toolbox についてさらに検索

製品


リリース

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by