清空筛选条件
清空筛选条件

Database Toolbox Not loading all of the tables

2 次查看（过去 30 天）
keith Runyon
keith Runyon 2015-8-20
评论： Titus Edelhofer 2015-8-20
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.

请先登录，再回答此问题。

回答（1 个）

Titus Edelhofer
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
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!

Translated by