Tag Archives: JDBC

See my Demo Video of Matlab 2012 and SQL Server 2012 connection via Java JDBC

Hi there

Wow. I got past some tough challenges lately.

What is below is a ‘silent movie’ showcasing the steps needed to get Matlab to connect to a SQL Server database, query a database table, and create the results within the Matlab workspace. Kind of cool.

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

https://quantlabs.net/blog/2013/09/demo-of-matlab-2012-and-sql-server-2012-connection-via-java-jdbc/

I have for a private video for QuantLabs.net Premium Members which shows how easy it is to generate a script from within the SQL Server Management Studio.

I just posted First version high speed automated trading platform database schema with SQL Server T-SQL script

https://quantlabs.net/blog/2013/09/i-just-posted-first-version-high-speed-automated-trading-platform-database-schema-with-sql-server-t-sql-script/

Just for fun showing the evil uses of R:

Evil uses for R with this Meetup: What Can R Tell Us About The Size Of Women?

https://quantlabs.net/blog/2013/09/evil-uses-for-r-with-this-meetup-what-can-r-tell-us-about-the-size-of-women/

Oops. I also posted a 45 minute private video on a complete source walkthrough on how to use the complete Complex Engine Processing (CEP) of SQL Server’s StreamInsight. It will save you many weeks for lost time of frustration. Don’t forget, it is videos like this where you will never see again as I remove public access. Now it is time to fill the gaps in this upcoming custom high speed automated trading system I am working on. So I will be implementing these new fixes into the platform. As always:

–> JOIN TO GET IMMEDIATE ACCESS TO THIS VDIEO <–


There are many other benefits listed here by joing my QuantLabs.net Premium Membership.

Thanks Bryan

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

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!

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

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 


HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

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!

Matlab can connect to MYSQL so I am dumping Microsoft SQL Server with their Java JDBC driver issues

Matlab can connect to MYSQL so I am dumping Microsoft SQL Server with their Java JDBC driver issues

As for my test and development for market data to populate SQL Server is being abandoned due to the useelss connection functionality between Matlab and SQL Server. It seems the crappy JDBC driver from Microsoft is pure rubbish for 64 bit Windows. Refer this to similar problems I have from Matlab 2012b with dexplore.

http://www.coderanch.com/t/562190/JDBC/databases/JDBC-connection-SQL-Server

I did try the other suggested jtds but that failed to.

The good news is I can connect into my MYSQL using dexplore so guess what? Bye bye SQL Server. Nice database but no good to me from Matlab.

Please that note this important step.

NOTE: I have posted solution and guide for my QLN Membership on how to find a workaround for this.

JOIN NOW TO GET ACCESS

JOIN my FREE newsletter to see how I proceed with my development in my custom HFT platform

HOW DO YOU START A PROFITABLE TRADING BUSINESS? Read more NOW >>>

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!