MikePorter

QUOTE (jed @ Aug 20 2008, 12:08 PM)

I am having a strange problem using mySQL via ADO.

I have written a medium sized LV app that uses mySQL as a back end. It works perfectly at the customer site, on many, many XP machines.

When I connect my laptop to the network, on all permutations of XP, VISTA and LV7.1.1 and LV 8.5, any column results that were created with a CONCAT or GROUP_CONCAT function appear something like this: "?????+????++??".

I have even installed the DB locally in case it was some sort of network problem, but I still see it. I thought it might be something to do with the default character set, but it occurs when I connect to the same server. I cut/pasted the query out of a labview probe into mySQL Query Browser and it had no problem.

I see the bad results as soon as the Variant is cast with the DB function...

I have never used that property for reading data from the database because it has a lot of "interesting" features. Conceptually what you have to do is use properties to read each field of each row returned. Check here for examples and some good discussion.

Mike...

QUOTE (stefvg @ Dec 16 2008, 08:01 AM)

I am student Engineer and i am in my last year. For my thesis i have to install a power supervision on a machine. This is measured by a Schneider Elektric PM710 and now i have to make a program that writes some values that i get out of this component every few seconds to a accessdatabase so i can interpret them later. I hope somebody can help me.

Basically the process is to use ADO (ActiveX Data Objects) to connect to the *.mdb file. If you are familier with using ActiveX the process is very straightforward. Plus there are free VIs available (check the NI user forum).

Mike...