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
