MATLAB: Do I receive the error message “the result set type is not supported” when I attempt to use an IBM UniVerse database with Database Toolbox 3.1 (R14SP3)

compliantdatabaseDatabase Toolboxjdbcodbcpartythirdthird-party

I am trying to access an IBM UniVerse Database. I am using Windows XP ODBC Data Source Administrator – IBM UniVerse ODBC Driver 4.00.01.7084 IBM Corporation. I can access the data using this driver, using the ODBC Connection with Microsoft Access. However, when I attempted to access this data using the Database Toolbox as follows:

1. Started the Visual Query Builder

2. Selected one of my data sources. Tables from the data source were displayed.

3. Selected one of the tables.

I received the following error dialog instead of the query builder displaying the fields from the table:

 Error: The result set type is not supported. Problem with database connection

Best Answer

This is due to the use of an older driver or a driver version that is not truly ODBC-compliant.

To resolve this issue, contact your database vendor to see if a newer version of the driver is available.

Related Solutions

MATLAB: Do I receive “[Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt” error with the Database Toolbox

This error generally happens because an ODBC connection can only have one active cursor at a time.

When you use the EXEC command to select data from a table, a cursor object is created, if you don't fetch the data from this cursor and you try to execute another EXEC command using the same connection, you will get this error message.

To work around this issue, there are two possibilities:

1. Make sure to read the rest data from the pending result set before we send the next EXEC command:

cursor_odbc_first = exec(conn_odbc,query)
%fetch the data before the next exec call
cursor_data = fetch(cursor_odbc_first);
cursor_odbc_second = exec(conn_odbc,query)

2. Use the Multiple Active Result Sets (MARS) connection setting to enable multiple active result sets in a connection.

The following link on the MSDN support page provides additional information:

 <http://msdn2.microsoft.com/en-us/library/ms345109.aspx>

MATLAB: Do I receive the error “Unable to connect to data source” with Oracle 10G and the Database Toolbox 3.0.1 (R14SP1)

This information has been incorporated into the documentation for Database Toolbox 3.0.2 (R14SP2). For previous releases, please read below for any additional information:

When connecting to the new versions of Oracle (10) database via JDBC, the database 'Name' should be the same as the suffix after the port number in the database 'URL'

For the DATABASE function DATABASEURL argument, for example, instead of running

conn = database('oracle','scott','tiger','oracle.jdbc.driver.OracleDriver',...
'jdbc:oracle:thin:@144.212.123.24:1822:')

you should use

conn = database('databasename','username','password','oracle.jdbc.driver.OracleDriver',jdbc:oracle:thin:@IP_ADDRESS_OF_DATABASE_SERVER:1521:databasename');

Best Answer

Related Solutions

MATLAB: Do I receive “[Microsoft][ODBC SQL Server Driver] Connection is busy with results for another hstmt” error with the Database Toolbox

MATLAB: Do I receive the error “Unable to connect to data source” with Oracle 10G and the Database Toolbox 3.0.1 (R14SP1)

Related Question