This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes IDEs, Version Control and other tools and the fly likes SQL Server 2005 Connection using SQL Explorer 3.5 in Eclipse Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "SQL Server 2005 Connection using SQL Explorer 3.5 in Eclipse" Watch "SQL Server 2005 Connection using SQL Explorer 3.5 in Eclipse" New topic
Author

SQL Server 2005 Connection using SQL Explorer 3.5 in Eclipse

Nithish Yalamanchili
Greenhorn

Joined: Aug 16, 2007
Posts: 24
Hi

Iam trying to connect to SQL Server 2005 using SQL Explorer 3.5 in Eclipse Ganymede. Iam creating new connection, following is the error iam facing
Could not coonect to your database alias, the exact message was: Cannot connect to SQL Server/User. Check your URL. The TCP/IP coonection to the host has failed.java.net.UnknownHostException.

Please help me.

Thanks
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5823
    
    7

What is your database URL? The error message indicates that the hostname used on the URL is not valid (that is, it cannot convert the name to a valid IP address).


JBoss In Action
Nithish Yalamanchili
Greenhorn

Joined: Aug 16, 2007
Posts: 24
My Database URL jdbc:sqlserver://JOHN-FME6HM/OFFICESERVERS:1433
Peter Johnson
author
Bartender

Joined: May 14, 2008
Posts: 5823
    
    7

Is the hostname JOHN-FME6HM valid? Can you ping that host? Is there an entry for this host in your hosts file?

Also, what is the full exception stack trace? Usually, the host not found error prints out the name of the host being looked for.
Nithish Yalamanchili
Greenhorn

Joined: Aug 16, 2007
Posts: 24
yes, i can ping that host...
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
Try with IP address instead of hostname.
 
 
subject: SQL Server 2005 Connection using SQL Explorer 3.5 in Eclipse