User`s guide

2 Getting Started with Database Toolbox
2-170
6
Enter your user name in the Username field and your password in the Password
field, or leave them blank if your database does not need them.
7
Click Test to test the connection. If your connection succeeded, Database Explorer
displays Connection Successful!
8
Enter a data source name in the Data Source Name field in the Create a New
JDBC data source dialog box. Use a new data source name that does not appear
in the existing list of data source names. Click Save. The new JDBC data source
appears in the list of data sources in the Connect to a Data Source dialog box.
9
If this time is the first time that you are creating a data source using Database
Explorer, the New file to store JDBC connection parameters dialog box opens.
Use this dialog box to create a MAT-file that saves your specified data source
information for future Database Explorer sessions. This MAT-file name is stored in
setdbprefs('JDBCDataSourceFile') and is valid for all MATLAB sessions.
Navigate to the folder where you want to put the MAT-file, specify a name for it that
includes a .mat extension, and click Save.
After you complete the data source setup, connect to the SQLite database using
Database Explorer or the command line with the JDBC connection.
Step 4. Connect using Database Explorer or the command line.
Connect to SQLite using Database Explorer.
1
After setting up the data source, connect to your database by selecting the data
source name for the SQLite database from the Data Sources list. Enter a user name
and password or leave them blank if your database does not require them. Click
Connect.