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

2009 6 27
1 个回答
回答已采纳
13 次查看（30 天）

0 个投票

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.

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

 采纳的回答

0 个投票

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 个）

类别

在 帮助中心 和 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