MATLAB: Do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver

20002005databaseDatabase Toolboxdriverjavajdbcmicrosoftremoteserversqlsununix

I have Microsoft SQL Server 2000 Driver for JDBC and I installed it on a host Sun Solaris machine. I am trying to connect to a remote database using the JDBC driver.
I issue the following commands
   conn = database
('iri','andy','andy','com.microsoft.jdbc.sqlserve
r.SQLServerDriver','jdbc:microsoft:sqlserver://an
dre1:1433');
conn.Message
 I get the following error message:
 [Microsoft][SQLServer JDBC Driver]Unable to
 connect.  Invalid URL.

Best Answer

This documentation bug has been fixed for Release 14 (R14). For previous releases, please read below for any possible workarounds:
To connect to the remote database using the Microsoft SQL 2000 JDBC Driver please use the following command:
conn = database
('iri','andy','andy','com.microsoft.jdbc.sqlserve
r.SQLServerDriver','jdbc:microsoft:sqlserver://an
dre1:1433;database=iri')
Related Question