MATLAB: Do I receive the error “Io Exception: Connection refused” with Oracle 10g and the Database Toolbox 3.1.1 (R2006a)

Database Toolbox

I am using the Query Builder from the Database Toolbox 3.1.1 (R2006a) to connect to my Oracle 10g database. Using the arguments as specified in the documentation, I get a dialog box with the following error:

 Io Exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERF=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))

If I use the DATABASE function with the following syntax:

conn = database('databasename','username','password','driver','databaseurl');

I get the following message in the database object, and the database is not opened:

 Io Exception: The Network Adapter could not establish the connection

Best Answer

The issue is related to the incorrect usage of the DATABASE function. The DATABASE function expects the 'databasename' parameter to be the same as the SID parameter at the end of the 'databaseurl'. If the two are not the same, the 'databasename' is appended to the string in the 'databaseurl'.

In the Query Builder, the database 'Name' should be the same as the suffix after the port number in the database 'URL'

The correct syntax for the DATABASE function with Oracle 10g and the Thin Client JDBC drivers is

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

Related Solutions

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');

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>

Best Answer

Related Solutions

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

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

Related Question