File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes IDEs, Version Control and other tools and the fly likes eclipse with sql server 2005 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 2005

in.anurag Singh
Greenhorn

Joined: May 14, 2010
Posts: 25
Hi,
I am trying to connect the Eclipse with Sql Server 2005. What I have done so far is as below:

1) I have installed sql server 2005.
2) I have downloaded drivers for sql server 2005.
3) opened Eclipse->Window->open perspective->Database Development
4) Right click on database connections in Data Source Explorer and selected New->SQL Server.
5) The window that is opened is "new connection profile".
6) Then, user name and password are blank, port number is 1433, database name is "pubs". I have checked the "use integrated authentication, and then the connection url is " jdbc:sqlserver://localhost:1433;databaseName=pubs;integratedSecurity=true; " i.e. by default
7) From the new driver definition, I selected Microsoft SQL Server 2005 JDBC Driver.
8) Add the Driver file to the Jar List, The driver file name is sqljdbc.jar.
9) In the properties the password and userId is empty, and connection url is "jdbc:sqlserver://localhost:1433;databaseName=pubs" . this all is by default.
10) After Clicking o.k., when I click the "test connection" on "New Connection Profile", I get an error "ping failed" and the details are:

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSecurity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:206)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:72)
at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55).

Please help me in connection Sql Server 2005 with the eclipse. Due to this, I am unable to execute database programs in my eclipse....
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

First I'd try removing the parameter it says is invalid, and seeing what happens.
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16012
    
  19

"Integrated security" means that your authentication comes from the Windows login. For JDBC, you don't want that, you want to be able to pass in explicit userid/password external credentials.

You also need to set up the SQL Server connection options if you intend to connect from an external system. I don't think you're having that problem at the moment, but then if you're not connecting from another system, you wouldn't.


Customer surveys are for companies who didn't pay proper attention to begin with.
P Arunkumar
Ranch Hand

Joined: Jan 05, 2012
Posts: 119
Hi

Same like this iam 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.
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16012
    
  19

As Manish has pointed out, we prefer that you do not ask the same question more than once. It causes too much confusion. Also, we call bringing up an old dead message thread such as this one "resurrecting a zombie" and we discourage that as well, since if you're answering the original question, chances are that the original participants don't care anymore, and if you start a new discussion, it's confusing, so we'd prefer you start your own thread instead.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: eclipse with sql server 2005