User`s guide

vi Contents
Initial Setup Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-9
Choosing Between ODBC and JDBC Drivers . . . . . . . . . . . . 2-10
Defining Database Drivers . . . . . . . . . . . . . . . . . . . . . . . . . 2-10
Deciding Between ODBC and JDBC Drivers . . . . . . . . . . . . 2-10
Configuring a Driver and Data Source . . . . . . . . . . . . . . . . . 2-13
Microsoft Access ODBC for Windows . . . . . . . . . . . . . . . . . . 2-15
Step 1. Check the 32-bit and 64-bit compatibility. . . . . . . . . 2-15
Step 2. Verify the driver installation. . . . . . . . . . . . . . . . . . 2-16
Step 3. Set up the data source using Database Explorer. . . . 2-16
Step 4. Connect using Database Explorer or the command
line. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-19
Microsoft SQL Server ODBC for Windows . . . . . . . . . . . . . . 2-23
Step 1. Check the 32-bit and 64-bit compatibility. . . . . . . . . 2-23
Step 2. Verify the driver installation. . . . . . . . . . . . . . . . . . 2-24
Step 3. Set up the data source using Database Explorer. . . . 2-24
Step 4. Connect using Database Explorer or the command
line. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-29
Microsoft SQL Server JDBC for Windows . . . . . . . . . . . . . . 2-33
Step 1. Verify the driver installation. . . . . . . . . . . . . . . . . . 2-33
Step 2. Verify the port number. . . . . . . . . . . . . . . . . . . . . . . 2-33
Step 3. Set up the operating system authentication. . . . . . . 2-36
Step 4. Add the JDBC driver to the MATLAB static Java class
path. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-37
Step 5. Set up the data source using Database Explorer. . . . 2-38
Step 6. Connect using Database Explorer or the command
line. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-40
Oracle ODBC for Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-44
Step 1. Check the 32-bit and 64-bit compatibility. . . . . . . . . 2-44
Step 2. Verify the driver installation. . . . . . . . . . . . . . . . . . 2-45
Step 3. Set up the data source using the ODBC Data Source
Administrator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-45
Step 4. Connect using the native ODBC connection command
line. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-47
Oracle JDBC for Windows . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-48
Step 1. Verify the driver installation. . . . . . . . . . . . . . . . . . 2-48
Step 2. Set up the operating system authentication. . . . . . . 2-48