Win a copy of Functional Reactive Programming this week in the Other Languages forum!
    Bookmark Topic Watch Topic
  • New Topic

Eclipse with SQL server 2008

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

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 not.my 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
Posts: 11193
15
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 http://www.coderanch.com/t/579885/java/java/Connect-ECLIPSE-SQL-Server
 
    Bookmark Topic Watch Topic
  • New Topic