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!
