Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Open and Close Database Connection

Establish and end connection to relational databases

Database Toolbox™ lets you connect to various relational databases by installing the database and driver. If you do not want to install a database and driver, you can use the MATLAB® interface to SQLite. For details, see Working with the MATLAB Interface to SQLite.

Functions

close Close database and driver resource utilizer
database Connect to database
isopen Determine if database connection or database cursor is open
isreadonly Determine if database connection is read only
logintimeout Set or get time allowed to establish database connection
ping Retrieve status information about database connection
set Set properties for database or cursor object
setdbprefs Set preferences for retrieval format, errors, NULLs, and more
close Close database and driver resource utilizer
sqlite Create SQLite connection

Apps

Database Explorer Configure, explore, and import database data

Topics

Database Explorer Workflow

Working with Database Explorer

Discover Database Explorer functionality and set preferences.

Configure Data Sources and Connect to Databases

Create a data source and connect to one or more databases.

Programmatic Workflow

Connecting to a Database Using the Native ODBC Interface

Learn about the native ODBC interface and how it compares to other database connection types.

Working with the MATLAB Interface to SQLite

To analyze your data using SQL in MATLAB without access to a database or driver, use the MATLAB interface to SQLite.

Import Data Using the MATLAB® Interface to SQLite

This example shows how to move data between MATLAB® and the MATLAB® interface to SQLite.

Was this topic helpful?