aspose file tools*
The moose likes JDBC and the fly likes retrieve data from SQL Server 2005 using Microsoft's JDBC driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "retrieve data from SQL Server 2005 using Microsoft Watch "retrieve data from SQL Server 2005 using Microsoft New topic
Author

retrieve data from SQL Server 2005 using Microsoft's JDBC driver

Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 477

Hi dears ,

My j2ee application was running fine but suddenlly this error occurs

i tried the solution mentioned Here but still getting the same error , I'm using GlassFish Server Open Source Edition 3.0.1 (build 22) , i just upgraded from glassfish v3 ,

by the way there is another j2ee application running on the same server and fetching data from the same DB and it;s working fine

DB is Microsoft SQL server 2005

Any suggestions ?


Thanks,
Sherif
Tom Reilly
Rancher

Joined: Jun 01, 2010
Posts: 618
You say that the error suddenly occurred but then say you recently upgraded. Could there be a correlation?
Googling the error suggests that you are using the SQLServer 2000 Driver when you should be using
the SQLServer >>2005<< Driver.
Sherif Shehab
Ranch Hand

Joined: Mar 05, 2007
Posts: 477

ya i mean i didnt change anything in the application itself , only upgrading the server..
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I'd second what Tom says. The log shows you are using the MS 2000 driver, which is an awful, bug ridden thing. Upgrade your driver to the 2005 or 2008 versions, or swap to jTDS and things may improve.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: retrieve data from SQL Server 2005 using Microsoft's JDBC driver
 
Similar Threads
"Could not find stored procedure" Error
Exception
Datasource Test Connection is successful but the application is not able to connect to the Database
Issue Connecting to MS SQL Server using WAS Embedded connectjdbc Driver
SQL Server 2005 & Microsoft JDBC driver