MATLAB "JoinTwoDatabaseTablesExample" Error
조회 수: 1 (최근 30일)
이전 댓글 표시
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,'','');
댓글 수: 0
채택된 답변
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
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Database Toolbox에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!