MATLAB Answers

Ilya
0

MSSQL connection hangs

Asked by Ilya
on 19 Dec 2011
Latest activity Commented on by Jonathan on 25 Feb 2014
I do the following
javaclasspath('/Applications/MATLAB_R2011a.app/sqljdbc/enu/sqljdbc4.jar')
conn = database('StudyWarehouse', 'username', 'pass', 'com.microsoft.sqlserver.jdbc.SQLServerDriver', 'jdbc:sqlserver://server.com:1433;database=StudyWarehouse');
After that the whole things just hangs without any messages ("Busy" forever). How could I approach this problem? Currently I don't even know where to start from...
Configuration:
  • Matlab 7.12 (R2011a)
  • Mac x64
  • Database toolbox 3.9
  • MSSQL Server 8 (on the server side)
Thanks in advance, Ilya

  0 Comments

Sign in to comment.

2 Answers

Answer by Ilya
on 19 Dec 2011

Managed to do it via jTDS driver
javaaddpath('/Applications/MATLAB_R2011a.app/jtds/jtds-1.2.5.jar')
conn = database('StudyWarehouse', 'user', 'pass', 'net.sourceforge.jtds.jdbc.Driver', 'jdbc:jtds:sqlserver://server:1433/StudyWarehouse');
But still curious how to make the microsoft driver work

  0 Comments

Sign in to comment.


Answer by ajith on 21 Nov 2012

refer the following link its been useful

  1 Comment

This is just the user manual, nothing specific about the problem that has been asked about (hangs while trying to make connection)

Sign in to comment.