Big problems with multiple thread application and ODBC

[JürgenS]

Hello,

I'm using CVI Version 7.1 and the SQL Toolkit 2.0.1. Two big Access databases are used to store and retrieve informations in multiple threads. The application must be running 24hours, 365 days per year. Now the application is crashing all few days. Now I'm read in the help file of the DBInit() function I can not use the Microsoft ODBC driver for Access in multiple threads.

I have a big problem because the Access database is very complex and also the part of the CVI program for the database has approximately 20.000 lines of code.

Has anyone a solution?

Please help me.

Thanks and

kind regards

Jürgen

[Andre_Saller]

You could us ThreadLocks to gurantee, that only one thread at a time accesses your database. Maybe this will prevent thecrash.

Utility Library-->Multithreading-->Thread Lock

[JürgenS]

Many thanks for your answer.

kind regards

Jürgen