Database Toolbox |
 |
Setting Up a Data Source for JDBC Drivers
- To set up a data source for use with a UNIX workstation or PC using JDBC drivers, you include a pointer to the JDBC driver location in the MATLAB
$matlabroot/toolbox/local/classpath.txt
file. For example, add the following line to your classpath.txt
file.
/dbtools/classes111.zip
where classes111.zip
is the file containing JDBC drivers. The file is available from your database provider.
- If you want to use the Visual Query Builder, perform these steps after completing step 1 to set up the JDBC data source.
- Start MATLAB if it is not already running.
- Access the Configure Data Source dialog box by typing
- Complete the Name, Driver, and URL fields. For example:
Name: orcl
Driver: oracle.jdbc.driver.OracleDriver
URL: jdbc:oracle:thin:@144.212.33.130:1521:
- Click Add to add the data source.
- Click Test to establish a test connection to the data source. You are
prompted to supply a username and password if the database requires it.
- Click OK to save the changes and close the Configure Data Source
dialog box.
To remove the data source, select it from the Data source list in the Configure Data Source dialog box, click Remove, and click OK.
| Setting Up a Remote Data Source for ODBC Drivers | | Starting the Database Toolbox |  |