Connect Matlab to Sql server

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'

Answer 1

[Friedrich]

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.

[fatma ghozzi]

Hello, yes, I followed them exactly

[fatma ghozzi]

 the problem that I don't know what means exactly 'com.microsoft.jdbc.sqlserver.SQLServerDriver' and what should I write in stade

[Friedrich]

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.