File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes IDEs, Version Control and other tools and the fly likes Eclipse with SQL server 2008 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Reply locked New topic

Eclipse with SQL server 2008

P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 119

I am trying to connect Eclipse with Sql server2008. but iam facing some error messages.

in Eclipse-> Windows -> open Perspective -> others -> Database Development -> ok

I got DataSource Explores Screen, then in database Connection-> rightClick -> click new -> connection profile will open.

In that i have selected sqlserver-> next -> driver details -> i have selected sqljdbc4.jar file because iam using jdk1.6

In next tab we can see properties like connection url and driver class my doute is my system is client system i want to connect with server my server name is SQL1. But in URL there is no ServerName.

My URL wants to be in this format

But iam getting

If i change the URL and i add server details in next step insted of database name server=SQL1 is showing.
Then Click Ok.

In next step it is asking for database name ,username , password.

If i gave all the details and click test connection its showing Ping Failed !.

The error message is
I have copy and pasted sqljdbc_auth.dll file in c:\windows\system32

Still same problem from my knowledge Eclipse is not connecting with server, i wants to access the server but i don't know the way please guide me.

I tried in google i got failed connection only please help me.

My system is client and server is another system i want to connect my client system with server system with dataSource it will be possible or server name is SQL1.

I want to connect my datasource with my server system (SQL Server Management Studio).

Please guide me to solve my issue.

Thanks in advance.
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 10824

Please do NOT post the same question multiple times. Since you already got a few answers, let us continue the discussion in your other topic here

[How to ask questions] [Donate a pint, save a life!] [Onff-turn it on!]
I agree. Here's the link:
subject: Eclipse with SQL server 2008
It's not a secret anymore!