Hi, I'm currently working on a VB/ASP.net project that's using large datasets.  Each time the website loads it gets these large datasets out of pervasive over ODBC what was taking up to 2 mins each time!  To help with loading times I've implemented multithreading.  The idea being that the website has to run 3 separate select statements and it would have to wait for each statement to run before moving onto the next one were as now it runs all 3 at once.  This has solved the problem of loading the data BUT for some reason every now and again one of the threads will hang while filling the dataset.   If you then try and access pervasive though code, pervasive control center or directly on the server it just hangs until you properly kill the task (by restarting the server or though task manager).

Does anyone have any ideas why this might be happening?  Can pervasive 2000i cope with multiple connections from the same application at the same time?

Cheers,
Rene