aspose file tools*
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
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Server JDBC Connectivity Error" Watch "SQL Server JDBC Connectivity Error" New topic
Author

SQL Server JDBC Connectivity Error

Sagar Shroff
Ranch Hand

Joined: Jun 07, 2011
Posts: 208

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



OCJP-90%,OCPWCD-95%
Sagar Shroff
Ranch Hand

Joined: Jun 07, 2011
Posts: 208

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

Joined: Oct 27, 2005
Posts: 19760
    
  20

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


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
 
subject: SQL Server JDBC Connectivity Error