Why do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver?

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.

Answer 1

[MathWorks Support Team]

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')