Why do I receive the error "Unable to connect to data source" with Oracle 10G and the Database Toolbox 3.0.1 (R14SP1)?

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.

Answer 1

[MathWorks Support Team]

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