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

4 次查看（过去 30 天）
MathWorks Support Team
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.

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

采纳的回答

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

更多回答（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