Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
suhav chaudhary
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
David Yutzy
tumbleweed and gunslinger
Ranch Hand
Posts: 192
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic