aspose file tools*
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
Author

Eclipse with SQL server 2008

P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 119
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

Joined: Jul 26, 2007
Posts: 10372
    
    8

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


[How to ask questions] [Donate a pint, save a life!] [Onff-turn it on!]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Eclipse with SQL server 2008