| 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: 26201
|
|
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 ]
|
|
 |
|
|
subject: I am facing a lot of problems with sql server 2000 odbc drivers.
|
|
|
0
