Call C library functions from Labview

[MutazAG]

hi,

the situation is as follows:

am going to use LabVIEW SUN Solaris (hence i cannot use the DB connectivity tools), and i need to access MySQL database, which happens to be ODBC complaint and has C based API...

is there a way to access ODBC compliant databases from LV in unix, maybe a 3rd party tool or something similar..

if not, how can i use the MySQL C API from LV under unix?

best regards,
MutazAG

[Labviewguru]

The Enterprise Connectivity Toolkit Addon for LabVIEW should allow you to do this, as it uses SQL. If the database is SQL compliant (I believe mySQL is) then you should have no problems.

[MutazAG]

true,

mySQL is ODBC compliant, and thats whats required.. the issue arises when using LV under Linux/Unix (as the db client side) since the Ehterprise Connectivity Toolkit only works with Windows Client applications.

[Randy_H]

MutazAG,

You can certainly call the C API using the Call Library Function node in the Functions >> Advanced palette. You should be able to call to an ODBC API this way as well.

Randy Hoskin
Applications Engineer
National Instruments
http://www.ni.com/ask

[Rolf]

"Randy H" wrote in message
news:506500000005000000229B0000-1027480788000@exchange.ni.com...
> MutazAG,
>
> You can certainly call the C API using the Call Library Function node
> in the Functions >> Advanced palette. You should be able to call to an
> ODBC API this way as well.
>
> Randy Hoskin
> Applications Engineer
> National Instruments
> http://www.ni.com/ask

This works indeed nicely but more involved ODBC API functions may be
difficult or impossible to aproach with the Call Library Node. If your
requirements however are simple there is no reason why
this shouldn't work.

Rolf