Why do I get an error when I try to access a remote database using the Microsoft SQL 2000 JDBC driver?
1 view (last 30 days)
Show older comments
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.
Accepted Answer
MathWorks Support Team
on 27 Jun 2009
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 Comments
More Answers (0)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!