清空筛选条件
清空筛选条件

MSSQL connection hangs

3 次查看（过去 30 天）
Ilya
Ilya 2011-12-19
评论： Jon 2014-2-25
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
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
refer the following link its been useful
http://radio.feld.cvut.cz/matlab/pdf_doc/database/database.pdf
  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)

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Configure Environment 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by