I'm having a static library built using CVI 6.0 that interacts with MS SQL server 7.0 database. I'm using ODBC driver for SQL server for connectivity.
Also i have a multithreaded VC++ application that links to this static library and calls many functions.
When some of the windows in my application are open, they will continuously call my CVI library functions, which internally makes calls to the database.
My application runs fine for sometime. But when those windows are kept open for a long time (more than 5 min), queries to the database fails to fetch any records. Note that the same queries had got executed many times properly before and it used to fet
ch me proper recorset. I'm having only 'select' statements.
I'm calling DBinit() from VC++ app, before making any other calls to Sql20 toolkit. Also i have ensured that i'm including 'Cvi_db.h' as the 1st file.
Can anybody give me a clue as to why this is happening ?
The thing why i'm not able to understand is , why it runs fine for sometime(around 5 min), but fails afterwards. The other thing is, once one query fails, all the subsequent queries will also fail.
Thanks in advance,
Swamy
