Connect Matlab to Sql server

10 次查看（过去 30 天）
fatma ghozzi
fatma ghozzi 2014-5-5
评论： Friedrich 2014-5-6
I try to connect to Sql server via a jdbc driver : sqljjdbc4 is already insatalled and this is my code :
db = database('ChifcoProd-2013-12-12-11-37', 'dg', 'pass', 'com.microsoft.jdbc.sqlserver.SQLServerDriver',...
'jdbc:microsoft:sqlserver://localhost:1433;database=ChifcoProd-2013-12-12-11-37')
error:
db =
Instance: 'ChifcoProd-2013-12-12-11-37'
UserName: 'dg'
Driver: []
URL: []
Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: 'JDBC Driver Error: com.microsoft.jdbc.sqlserver.SQLServerDriver. Driver Not Found/Loaded.'
Handle: 0
TimeOut: []
AutoCommit: 'off'
Type: 'Database Object'

请先登录，再回答此问题。

采纳的回答

Friedrich
Friedrich 2014-5-5
Hi,
have you followed the instructions here. Basically you need to add the driver jar to MATLAB JAVA Classpath. How this is done is explained in the link I posted.
  3 个评论
显示 1更早的评论
fatma ghozzi
fatma ghozzi 2014-5-5
编辑：fatma ghozzi 2014-5-5
the problem that I don't know what means exactly 'com.microsoft.jdbc.sqlserver.SQLServerDriver' and what should I write in stade
Friedrich
Friedrich 2014-5-6
According to the doc (see the bottom of database function page) the pair is of the format:
JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Database URL: jdbc:sqlserver://localhost:port;database=databasename
Try adjusting your call to match that format and try again.

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by