Database Toolbox Not loading all of the tables

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.

Answer 1

[Titus Edelhofer]

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

[keith Runyon]

Can you elaborate on the default " database"

[Titus Edelhofer]

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