Database Toolbox Not loading all of the tables
조회 수: 2 (최근 30일)
이전 댓글 표시
Sometimes when I pull up a SQL DB in Matlab Database Explorer APP I get all of the tables that are in that db and other times I get 2 or none. What's the deal?
I have been fiddling with it to try and make the DB tables always appear but it's really finicky. Once I got the tables to appear in the Database Explorer App, I used the App to generate a script. Of course when the app was displaying all o find tables the script correctly found all of the tables. The next day I login to my workstation and try to run the script, and the toolbox only found a couple of the hundreds of tables in that DB. So then I pull up the APP and it won't find the tables either.
댓글 수: 0
답변 (1개)
Titus Edelhofer
2015년 8월 20일
Hi,
are you using SQL Server? And configured via ODBC database sources? Often the default database is not specified or not correctly specified. This should be done to get consistent results ...
Titus
댓글 수: 2
Titus Edelhofer
2015년 8월 20일
When you configure the ODBC connection, you start with the SQL Server, then comes authentication (user + password), and on the next screen comes a field default database (or something similar, in German it's Standarddatenbank :)). There the default database of the server should be selected (ask your system administrator which it is).
Titus
참고 항목
카테고리
Help Center 및 File Exchange에서 Connect to Database and Import Data Interactively에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!