SQL Server 2008 R2 latest updates. SQL server ODBC driver version 6.01.7601.17514 PS!!! native drivers are incompatible with the software so i cannot use them. I cannot edit or change the server software - i do not have access to sourcecode.
select MemberCount from tbl_guild where serial = 6 1255 08/23/12 07:42:20 : SqlState:HY000, NativeError:0 Msg:[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt
UPDATE ----------------------------------------------- I ran a complete trace of SQL actions when a member was accepted in game. Results: Everything seemed to work perfectly. Selects the membercount, following with user guild data update (executes the stored procedure and completes it, updating user guild serial, status etc in table general). Everything completes successfully.
It also matches the working database actions. The fact that after server reboot people are in the guild proves that it's all ok (the server updates member count in database when server is rebooted).
The problem is with membercount. It's selected into memory (zoneserver) so in game players get accepted and database membercount value updates later (server reboot or some fixed time). Pretty bad solution but nothing i can do about that.
Somehow the membercount value never reaches the zone and wont be updated in memory, So the server writes the hstmt/busy error into the log files.
I have to add that, ODBC connections and the software itself is not corrupted. I have already remade and replaced both. Also, i have used a clean backup of database (all same but without user data in it) - renaming the problematic one so all ODBC connections etc were untouched. The guilds worked and members could be accepted.
What could possibly cause the SELECT data to get lost/time out before it reaches the server software. Is there any simple software i could use to execute the same query (select MemberCount from tbl_guild where serial = 6) over ODBC to confirm if i get the value from it?