View Single Post
  (#1 (permalink)) Old
S.I.D S.I.D is offline
Member
 
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Join Date: Jan 2009
Unhappy Problem connecting to MSSQL database in Eclipse - 01-30-2009, 02:37 PM

HI all,

I m facing problem in connecting MSSQL database in Eclipse.
I hv went thru all the steps n tried all the solutions on net but still cant find the way thru
The error i m facing is -
Code:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
	at org.eclipse.datatools.connectivity.db.generic.JDBCConnection.createConnection(JDBCConnection.java:87)
	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.db.generic.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:52)
	at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:77)
	at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:354)
	at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:57)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

The things i tried are:-
1. checked TCP/IP setting in the sql server which is enabled n the port is also set properly, even tried changing the port n tried
2. The proper driver jar files r also thr...msbase.jar, mssqlserver.jar, msutil.jar
3. Even the database name is proper
4. SQL Server SP3 is also installed

When i try pinging the SQL from JDBC Connection Properties, it failes n the above error is displayed in details
The Connection URL is jdbc:microsoft:sqlserver://EQ:1443;Database Name=ENCODB
EQ is the pc name, changed the SQL Server port to 1443
n Driver Class is com.microsoft.jdbc.sqlserver.SQLServerDriver

Waiting for experts comment n help
Thanx in advance
Siddhesh Tawde
Reply With Quote