This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server 2005 Connection using SQL Explorer 3.5 in Eclipse

 
Nithish Yalamanchili
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Nithish Yalamanchili
Greenhorn
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My Database URL jdbc:sqlserver://JOHN-FME6HM/OFFICESERVERS:1433
 
Peter Johnson
author
Bartender
Posts: 5852
7
Android Eclipse IDE Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 24
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yes, i can ping that host...
 
Bauke Scholtz
Ranch Hand
Posts: 2458
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try with IP address instead of hostname.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic