(Last Updated On: September 10, 2013)

Demo of Matlab 2012 and SQL Server 2012 connection via Java JDBC

Note video startsat 0:30 (blame video editing software)

I have finally got this working in the video. Do note it is silent due to a new sever in play.

Note you need to activate the SQL Server services, usage of SQL Server Management Studio, and connect in Matlab via JDBC.

Matlab code came from

http://stackoverflow.com/questions/6593485/how-to-connect-to-microsoft-sql-server-2008-mssql-from-matlab

I used the Database Toolbox option with code of:

conn = database('', '','', ...
    'com.microsoft.sqlserver.jdbc.SQLServerDriver', ...
    'jdbc:sqlserver://:;database=');
curs = exec(conn, 'select * from ');
curs = fetch(curs);
curs.Data
close(curs)
close(conn)

Follow me on how I will proceed with this through my FREE newsletter 

NOTE I now post my TRADING ALERTS into my personal FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!