Evridb examples

Examples use EVRI Database Object

NOTE: For PLS_Toolbox 6.1 and newer.

Connecting to Office 2007 Access Database

• If you don't have Office 2007 or newer installed you'll need to download and install the newest Access database driver from here:

http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en

• Make a database object with the appropriate 'location' and 'name':

>> mydb = evridb('type','access');
>> mydb.location = 'C:\Users\scott\Desktop';
>> mydb.dbname = 'test.accdb';

• Test the connection, if you don't get a 1 back check the location and dbname:

>> mydb.testconnection
ans =
     1

• Get a list of the tables in the database:

>> mytables = mydb.get_access_tables
mytables =
    '~TMPCLP877991'
    'table1'
    'table2'
    'table3'

• Get a cell array of all the table data in "table1" with the first row containing column names:

>> mydb.use_column_names = 'yes';
>> mydb.return_type = 'cell';
table1Data = mydb.runquery('select * from "table1"')
table1Data =
    'id'    'field01'
    [ 1]    'value1'
    [ 2]    'value2'
    [ 3]    'value3'
    [ 4]    'value4'

Connecting to System Data Source Name (DSN)

Make sure you have drivers installed and DSN created. Search Microsoft for DSN instruction for you particular system if you do not have DSN set up.

>> mydb = evridb('type','dsn');
>> mydb.dsn = 'name_of_DSN;
>> mydb.testconnection
ans =
     1

Connecting to MS SQL Server

This example used a .mdf file "attached" to a local instance of SQL Server Express. The local database server was created using these instructions. Originally a DSN was created where the server syntax "(localdb)\v11.0" was located via Server Setup dialog box.

>> dbo = evridb('mssql');
>> dbo.driver = '{SQL Server Native Client 11.0}';
>> dbo.provider = '';
>> dbo.server = '(localdb)\v11.0';
>> dbo.dbname = 'MyTestDatabase';
>> dbo.testconnection

  1