Using myOLEDB in LV

[jwodin]

I'm trying to build a vi that can send and receive data to a mySQL database (basically just timestamps and values). I have been able to do this using Microsoft's ODBC driver and the LabVIEW 8.2 DB Tools vi's, but the querying and writing seems to be slower than I would expect. Multiple people online seem to say that this is because of various ActiveX objects that are opened by the OBDC driver.  I found a MyOLEDB driver on sourceforge, which installed two files on my machine:

libmysql.dll
MyProv.dll

Has anyone had success using these libraries (presumably using the Call Library Function Node) to connect to a database? Is there an example somewhere? Should this be faster?  I can't seem to find suitable documentation on the code in these libraries.

Thanks

Jesse Wodin

[mikeporter]

When you say operations are slower than expected, can you quantify that a bit? Also have you tried some other mechanism for accessing the database other than the Database Connectivity Toolkit? There are the LabSQL drivers, as well as the ones that I have created and posted. Another thing to consider is the studlyness of machine the code is running on and what other processes are running on it. Basically, you have a lot of things to check.

• Your computer could be slow
• There could be other software that is negatively impacting performance (anti-virus software can, for example, muck things up badly)
• mySQL could have a performance issue.
• The drivers (at any of several levels) could be inefficient

Mike...