Version 3.3 (R2007a) Database Toolbox™ Software Release Notes

Version 3.3 (R2007a) Database Toolbox™ Software

This table summarizes what's new in Version 3.3 (R2007a):

New features and changes follow.

• setdbprefs Accepts Structure Input

• Visual Query Builder Generated M-File Includes Placeholder for Password and Assigns Preferences to Structure

• Preference Added for Temporary Registry Output; Ensures Full Output for getdatasources

setdbprefs Accepts Structure Input

The setdbprefs function now accepts a structure as input. For example, you can run the following commands to assign values to s:

s.DataReturnFormat = 'numeric';
s.ErrorHandling = 'report';

You can also do this for other setdbprefs properties whose values you want to change. Then set the preferences using the values in s by running the command:

setdbprefs(s)

For more information, see the setdbprefs reference page.

Visual Query Builder Generated M-File Includes Placeholder for Password and Assigns Preferences to Structure

When you run a query in the Visual Query Builder and select File > Generate M-File, the resulting M-file now includes a placeholder string password in the database statement. If a password is required for the connection, such as for connections established via JDBC drivers, substitute the password for the password string. If no password is required, the M-file will run as is. For more information, see About Generated M-Files.

The generated M-file assigns values for the preferences to the structure s. For more information, see the setdbprefs reference page.

Preference Added for Temporary Registry Output; Ensures Full Output for getdatasources

When you use getdatasources to view the data sources for your system, ensure that you view all data sources by specifying a temporary, writable, output directory using the new preference, TempDirForRegistryOutput. This is useful when you add data sources and do not have write access for the MATLAB^® current directory, where the toolbox temporarily writes ODBC registry settings. Without write access, getdatasources does not always return data sources you added. In that event, run setdbprefs to specify a value for the TempDirForRegistryOutput preference, where the value is the full pathname to a directory for which you have write access.

Version 3.4 (R2007b) Database Toolbox™ Software

Version 3.2 (R2006b) Database Toolbox™ Software