Two Laptop Bag
The moose likes JDBC and Relational Databases and the fly likes SQL Server JDBC Connectivity Error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Server JDBC Connectivity Error" Watch "SQL Server JDBC Connectivity Error" New topic

SQL Server JDBC Connectivity Error

Sagar Shroff
Ranch Hand

Joined: Jun 07, 2011
Posts: 209

Hello All,

I am using a 64 bit Windows 7 machine. I have installed SQL Server 2008 and post that SP1.
I have configured a data source using the data source ODBC Administrator.

Below is the code and and i am also attaching one image which is the screenshot of the exception !.Its been from 5,6 hours i have been trying to find the solution for this
but i am not getting one.Then thought of java ranch as it always does.I hope you guys might find once more one solution for me ! Thanks in advance !
When i test the Data Source here, it works fine. "TESTS COMPLETED SUCCESSFULLY"

However while working from Java, i get an error.

Below is the code i am using.

Error Message is as below :-

Sagar Shroff
Ranch Hand

Joined: Jun 07, 2011
Posts: 209

Any alternate solutions using some other jdbc drivers would also be appreciated.
Rob Spoor

Joined: Oct 27, 2005
Posts: 20137

I don't know the answer, but here's someone with the same error. You may want to watch that thread.

How To Ask Questions How To Answer Questions
I agree. Here's the link:
subject: SQL Server JDBC Connectivity Error
It's not a secret anymore!