labview and mysql

[Vijayalakshmi]

Hi all,

I m trying to integrate Labview 7.0 (on Mandrake linux) to mysql 4.1 using C APIs.

I use the labview utility - lvmkmf

i.e lvmkmf my_conn (my_conn is the C program that uses the mysql C APIs)

The C APIs require the library mysqlclient and I have included it in the Makefile using the CINLIB macro.

And I get the following error.

gcc -shared -o my_conn.tmp \

/home/viji/cintools/cin.o my_conn.o /home/viji/cintools/libcin.a /home/viji/cintools/libmysqlclient.a

/home/viji/cintools/lvsbutil -c my_conn -t CIN -d `pwd`

/home/viji/cintools/my_conn.tmp: undefined symbol: compress

/home/viji/cintools/lvsbutil: error building resource file: 1

make: *** [my_conn.lsb] Error 2

Is the lvsbutil trying the compress the libraries and giving an error when trying to do so?

Thanks,

Viji

[Jim Kring]

Hi all,

I m trying to integrate Labview 7.0 (on Mandrake linux) to mysql 4.1 using C APIs.

I use the labview utility - lvmkmf

  i.e lvmkmf my_conn (my_conn is the C program that uses the mysql C APIs)

The C APIs require the library mysqlclient and I have included it in the Makefile using the CINLIB macro.

And I get the following error.

gcc -shared -o my_conn.tmp \

        /home/viji/cintools/cin.o  my_conn.o  /home/viji/cintools/libcin.a /home/viji/cintools/libmysqlclient.a

/home/viji/cintools/lvsbutil -c my_conn -t CIN -d `pwd`

/home/viji/cintools/my_conn.tmp: undefined symbol: compress

/home/viji/cintools/lvsbutil: error building resource file: 1

make: *** [my_conn.lsb] Error 2

Is the lvsbutil trying the compress the libraries and giving an error when trying to do so?

Thanks,

Viji

5718[/snapback]

There is an example here showing how to call the mysql C API. I'm not sure about your error (sorry), but maybe this example will provide some insight. I was able to get it to work on my Linux box.

-Jim

[Mike Ashe]

Anyone done this using MySQL under Windows and then made wrappers for both to make the upper level platform independent?

[LuI]

Anyone done this using MySQL under Windows and then made wrappers for both to make the upper level platform independent?

Mike,

don't know about the way this was done, but Anthony Lukindo from Advanced Measurements Inc. published a solution java script:emoticon(':thumbup:', 'smid_27')

smilie that acts as you asked for in LTR:

"Simplified LabVIEW Database Access: A Single VI Solution for Connecting, Reading and Writing to Your Database" by Anthony Lukindo in LabVIEW Technical Resource, Volume 12, Number 3.

As you probably know, LTR is gone now. I'd suggest contacting Anthony for this VI. If this does not work I could provide a wrapper around his VI that checks a global value to switch DB access on or off.