aspose file tools*
The moose likes IDEs, Version Control and other tools and the fly likes Connect 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
Bookmark "Connect ECLIPSE WITH SQL Server 2008" Watch "Connect ECLIPSE WITH SQL Server 2008" New topic
Author

Connect ECLIPSE WITH SQL Server 2008

P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 119
Hi


I wants 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.

Thanks in advance.
John Jai
Bartender

Joined: May 31, 2011
Posts: 1776
Login failed for user 'sa'

Were you able to successfully login to the database with 'sa' credentials using other tools (SQL Server Management Studio)?
P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 119
Hi


Thanks for your reply.

Yes iam trying to connect with sa only, it will possible or not. if possible please send me the steps to connect.


Thanks in advance.
John Jai
Bartender

Joined: May 31, 2011
Posts: 1776
Replace the necessary information for your connection settings and try with this code.



sample db_url -> jdbc:sqlserver://127.0.0.1;database=DUMMY_DB

Also note the SqlServer service should be up and running.
P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 119
Hi


your code is correct only but my question is i want to connect sql server 2008 with eclipse by
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.


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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Connect ECLIPSE WITH SQL Server 2008