MSSQL connection hangs

조회 수: 7 (최근 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일
  댓글 수: 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 CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by