Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 JDBC driver and URL for Sql Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-18 : 09:19:05
Jackly writes "Hi,

I followed all you instructions to try to find the answer to my questions first from your site by going to the manual, going to your FAQs, searching all the indicated pages for the answers. I simply couldn't find them. Consequently, I have no choice but to ask my questions:
I have Sql Server 2000 installed with the correct driver (I downloaded it from the microsoft site). I called my database merlin. My jdbc driver string is com.microsoft.jdbc.sqlserver.SQLServerDriver and my url string is jdbc:microsoft:sqlserver://localhost:1433;merlin. My questions are the following:
1) Are the strings correct?
2) Are there default username and password that you know of and that I could use to connect to merlin?
3) If so, how would the url string be changed to include that username and that password?

For all the other databases (Oracle, MySql, Informix) that I am using, I can connect to them and create my tables using their jdbc drivers and URLs in an XML file that I run with Java. For the SqlServer2000, I get a "Cannot connect..." Check the correctness of the url" type of error message.

Please help"
   

- Advertisement -