Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shameerunni
Starting Member
2 Posts |
 Posted - 2008-08-07 : 15:00:52
|
| hello,i am tryin to insert data into a table,but it shows "java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt" actually what is the problem?what can i do for solving it? whether it needs type4 connection.now it is type1 connection im using. then if we r using type4, will u please list what r the advantages.kindly.. its very urgent for me,,anybody... shameer v |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-08-07 : 16:51:59
|
| Hi there,I don't think you've got MARS enabled (Multiple Active Result Sets feature) -- theres a configuration string you can pass to the ODBC driver.For more info check this link..http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=752879&SiteID=1I don't have direct experience with this but I think it's exactly your problem.-------------Charlie |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2008-08-07 : 16:54:57
|
in particular...quote:
Alternatively you can control MARS from the connection string. In OLE DB it's "MarsConn=yes", for ADO it's "MARS Connection=true" and for ODBC it's "MARS_Connection=yes".
-------------Charlie |
|
|
|
|
|
|
java.sql.SQLException: [Microsoft][ODBC SQL Server