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)
Show older comments
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
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');
0 Comments
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!