ODBC and SQL Server 6.5 with VB5 DAO

[Wolfgang Kutschera]

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

[kieran_rush]

Let me see your code, I can help you with this I had the same problem, right now I'm using SQL version 7.0 this version is quite advanced compared with SQL version 6.5SP4 or 5, but anyway let me see the part of the code that is with the problem
Regards