Why do I receive the error "Unable to connect to data source" with Oracle 10G and the Database Toolbox 3.0.1 (R14SP1)?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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.
Respuesta aceptada
MathWorks Support Team
el 1 de Oct. de 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 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Database Toolbox en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!