File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 202

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

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

Joined: Oct 27, 2005
Posts: 19541

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
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: SQL Server JDBC Connectivity Error
Similar Threads
regarding session transfer from servlet to jsp
session handling
How to handle exception in jsp
How to set date in mysql using prepared statement?
how to change content type from multipart/form-data to text/html