Bookmark Topic Watch Topic
  • New Topic

Eclipse with SQL server 2008  RSS feed

P Arunkumar
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Report post to moderator

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
Posts: 11445
Android Eclipse IDE Google Web Toolkit Java Mac Ubuntu
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
It is sorta covered in the JavaRanch Style Guide.
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!