MSSQL connection hangs

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

回答 (2 件)

Ilya
Ilya 2011 年 12 月 19 日

0 投票

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
ajith
ajith 2012 年 11 月 21 日

0 投票

1 件のコメント

Jon
Jon 2014 年 2 月 25 日
This is just the user manual, nothing specific about the problem that has been asked about (hangs while trying to make connection)

サインインしてコメントする。

カテゴリ

質問済み:

2011 年 12 月 19 日

コメント済み:

Jon
2014 年 2 月 25 日

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by