wood burning stoves*
The moose likes JDBC and the fly likes I am facing a lot of problems with sql server 2000 odbc drivers. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "I am facing a lot of problems with sql server 2000 odbc drivers." Watch "I am facing a lot of problems with sql server 2000 odbc drivers." New topic
Author

I am facing a lot of problems with sql server 2000 odbc drivers.

suhav chaudhary
Greenhorn

Joined: Oct 25, 2004
Posts: 1
hi all.....
I am facing a lot of problems with sql server 2000 odbc drivers.
and the database

when i try a awt database application in ms access it is working perceftly

but is it not working in using sql server 2000 database and i am using the JRUN 4 as the java server

and some times i am getting the exception with sql server

java.sql.SQLException : [Microsoft] [ODBC SQL Server Driver] Connection is busy with results for another hstmt.


pl give me some solution to my problem

i am facing pblm from past 2 weeks

pl give me replies at suhavchaudhary@yahoo.com

thank you
suhav
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30085
    
149

Suhav,
Welcome to JavaRanch!

Are you using connection pooling or threads? Are you closing your result sets, statements and connections? Is it possible that the connection is in use?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
David Yutzy
tumbleweed and gunslinger
Ranch Hand

Joined: Jun 29, 2001
Posts: 192
It sounds like you are not properly closing your connections, statements, or something like that.

We're using SQL Server 2000 and process over 100 million DB operations a month with no issues.

One word of caution, eventhough many people say you do not have to close Statements, PreparedStatements, or CallabelStatements before closing Connections: do it. It does matter. Don't leave it up to the driver to handle this. We've found vast differences in how drivers handle this, especially the MS Type 3 Driver, which is aweful BTW.
[ November 04, 2004: Message edited by: David Yutzy ]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: I am facing a lot of problems with sql server 2000 odbc drivers.
 
Similar Threads
Getting ClassCastExceptions with CachedRowSet
Database connectivity driver other than JDBC-ODBC Driver ??
JDBC-UnsupportedOperationException
java.lang.UnsupportedOperationException
Facing Big Problem with Sql Server 2000 Odbc Driver