MSSQL connection hangs

2011 12 19
2 个回答
更新时间：2014 2 25
9 次查看（30 天）

0 个投票

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 个投票

refer the following link its been useful
http://radio.feld.cvut.cz/matlab/pdf_doc/database/database.pdf

1 个评论
显示 -1更早的评论 隐藏 -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)

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

产品

标签

提问:

Ilya
Ilya
2011-12-19

评论：

Jon
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