Hi there!


Have a serious problem over here:

I am developing a big Online-System in VB5. My database backend is an SQL Server 6.5, Service Pack 4 (was unable to apply Service Pack 5A until now), using TCP/IP to connect.

I am programming using DAO 3.5 and the ODBC driver for SQL Server shipped with SQL Server Service Pack 4.

My problem: Anywhen between the 10th and the 30th query my program crashes with the error message "ODBC-Call failed". I already tried just programming a loop that opens and closes a recordset having the same troubles within the loop.

Is there any bug I don't know or am I just too stupid?


Thanks for any hints!

brgds

Wolfgang "Rick" Kutschera

Scientific Games Austria

Systemprogramming