LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

How can I organize multiplethreading access to the database via SQL CVI Toolkit?

I have to organize multiplethreading access to the database Access (Microsoft Access Driver in ODBC).
I have tryed to use function
DBInit (DB_INIT_MULTITHREADED) before function DBConnect, but this function doesn't work (returns error code).
I have 3.525 version of ODBC.
I use LAB Windows/CVI 7.1.
Note that singlethreading access work successfully.
How can I organize multi-threading access to the database?
Maria.
 
0 Kudos
Message 1 of 5
(3,234 Views)

Try configuring you Access database as a System DSN.

What is your error code?

If it still does not work, attach you database along with code and I will try it.

 

 

robskii

0 Kudos
Message 2 of 5
(3,205 Views)

Thank you for your reply.

I'll check what is an error code and I'll back with reply tomorrow.

0 Kudos
Message 3 of 5
(3,192 Views)

I would make sure that the Microsoft Jet drivers are also atleast on version 3.   Prior to that, I don't think the Jet drivers were multithreaded.  This might be your problem.  But your system would have to be way out of date...

Orlan

0 Kudos
Message 4 of 5
(3,184 Views)
Thank you to all ! After I register it as DSN server it works successfully.
0 Kudos
Message 5 of 5
(3,131 Views)