NO SQL Server, stay with PostGresSQL database

(Last Updated On: February 26, 2015)

NO SQL Server, stay with PostGresSQL database
I also decided not move ahead with SQL Server as well due to uncessary complexities to set up a connection from Matlab. As a result, the notes and caveats are below but I am sticking with PostGreSQL for now as it is very easy to work with and multi platform. It is open source as well which means it is FREE.
http://www.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html
http://www.mathworks.com/help/database/ug/database.html
For JDBC connection:
http://www.mathworks.com/help/database/ug/microsoft-sql-server-jdbc-windows.html
My Notes and caveats:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9d84f135-ae13-450e-b0b6-87d37576d8f8/sql-server-agent-gives-remote-procedure-call-failed-0x800706be?forum=sqltools
Try opening the SQL server configuration manager with RUN AS ADMIN option and see if that makes any differencofe
Add in the C:\Users\Bryan\AppData\Roaming\MathWorks\MATLAB\R2014a\javalibrarypath.txt contains something like:
C:\Users\Bryan\AppData\Roaming\MathWorks\MATLAB\R2014a\sqljdbc_4.1\enu\auth\x64
The javaclasspath.txt has
C:\Users\Bryan\Downloads\Microsoft JDBC Driver 4.1 for SQL Server\sqljdbc_4.1\enu\sqljdbc.jar
I had to correct:
C:\Users\Bryan\Downloads\Microsoft JDBC Driver 4.1 for SQL Server\sqljdbc_4.1\enu\sqljdbc4.jar

If you the JDBC 4.1, you will get error of
3:01:30 PM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>

SEVERE: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

Use the JDBC4.0 not 4.1!
I created Data Source to SQL Server with sample sa credentials for SQL Server authentication
 

Join my FREE newsletter to learn more about how I use PostGres For trading 

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!
This entry was posted in Matlab, Quant Development and tagged , , , on by .

About caustic

Hi i there My name is Bryan Downing. I am part of a company called QuantLabs.Net This is specifically a company with a high profile blog about technology, trading, financial, investment, quant, etc. It posts things on how to do job interviews with large companies like Morgan Stanley, Bloomberg, Citibank, and IBM. It also posts different unique tips and tricks on Java, C++, or C programming. It posts about different techniques in learning about Matlab and building models or strategies. There is a lot here if you are into venturing into the financial world like quant or technical analysis. It also discusses the future generation of trading and programming Specialties: C++, Java, C#, Matlab, quant, models, strategies, technical analysis, linux, windows P.S. I have been known to be the worst typist. Do not be offended by it as I like to bang stuff out and put priorty of what I do over typing. Maybe one day I can get a full time copy editor to help out. Do note I prefer videos as they are much easier to produce so check out my many video at youtube.com/quantlabs