MSSQL connection hangs

1 Ansicht (letzte 30 Tage)
Ilya
Ilya am 19 Dez. 2011
Kommentiert: Jon am 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

Antworten (2)

Ilya
Ilya am 19 Dez. 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

ajith
ajith am 21 Nov. 2012
  1 Kommentar
Jon
Jon am 25 Feb. 2014
This is just the user manual, nothing specific about the problem that has been asked about (hangs while trying to make connection)

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu Reporting and Database Access finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by