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

10gdatabaseDatabase ToolboxdatasourcehostnamejdbcMATLABoraclethintoolbox

In the Database Toolbox 3.0.1, I tried to configure my data source using the JDBC THIN driver with the CONFDS function. The URL I tried to specify is as follows:
jdbc:oracle:thin:@192.171.134.83:1521:
where @192.171.134.83:1521: is my hostname
This URL format is recognized by the Database Toolbox 3.0.1 (R14SP1) with Oracle 7 and 8 but is not recognized with Oracle 10G.

Best Answer

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