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

1 view (last 30 days)
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.

Accepted Answer

MathWorks Support Team
MathWorks Support Team on 1 Oct 2009
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');

More Answers (0)

Products


Release

R14SP1

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!