This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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: 207

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: 207

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

Joined: Oct 27, 2005
Posts: 19649

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
subject: SQL Server JDBC Connectivity Error
Similar Threads
session handling
How to handle exception in jsp
How to set date in mysql using prepared statement?
regarding session transfer from servlet to jsp
how to change content type from multipart/form-data to text/html