Why do I receive an error while using Visual Query Builder in the Database Toolbox in MATLAB 7.6 R2008a?

I am using Microsoft SQL database system. I have multiple data sources in this database and can see a list of all of them when I open the Visual Query Builder. When I click on one of these data sources, select a catalog and choose the tables and fields in the catalog, I get the following error:

microsoft odbc sql server driver invalid object name <name of table>

There are no issues with my ODBC driver or driver connection as I can execute my SQL queries from the command prompt.

Answer 1

[MathWorks Support Team]

If you have multiple data sources on your system and you are using an ODBC driver, you will need to select the data source and the associated catalog in from the Microsoft Windows ODBC settings as follows:

 1. Start->Control Panel->Administrative Tools->Data Sources(ODBC) 

 2. Click on User/System DSN tab wherever the ODBC datasource is

 3. Select the datasource you want to query results from

 4. Click on the Configure button and click Ok

 5. If you have any catalogs associated with the datasources, select the catalog and save the settings.

 6. Restart MATLAB and execute the query again on Visual Query Builder.