Connect Matlab to Sql server

16 views (last 30 days)
fatma ghozzi
fatma ghozzi on 5 May 2014
Commented: Friedrich on 6 May 2014
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'

Accepted Answer

Friedrich
Friedrich on 5 May 2014
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 Comments
Friedrich
Friedrich on 6 May 2014
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.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!