Jump to content

Strange problem with mySQL + Labview


Recommended Posts

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...

post-143-1219251988.jpg?width=400

Link to comment
  • 4 months later...

QUOTE (MikePorter @ Dec 22 2008, 05:10 PM)

I have never used that property for reading data from the database because it has a lot of "interesting" features.

Can you expand on that? I noticed that using it makes the query considerably faster for larger data sets (natually) and I'm pretty sure that NI uses this in their new version of the DB toolkit. I know you think the toolkit is unnecessary, but presumably both NI and Microsoft have at least some people who know what they're doing, right (ducks to avoid the shower of rotten tomatoes)?

P.S. Welcome to LAVA. Did Ben manage to convince you?

Link to comment

Hi Jed:

I use LabVIEW with ADO along with MS SQL Server and MS Access databases. I have all along used the 'GET ROWS' method to cast the variant data in to a LabVIEW 2D array of strings with consistent performance and correctness of output.

. . . Based on your reported anomaly, it appears that you may be getting the bad result from a new SQL query that may have a syntax error that is intolerant when executed via ADO, while the MySQL query utility somehow corrects the syntax error automatically or is simply tolerant to the syntax error. I am assuming here that the MySQL utility does not use ADO drivers to access MySQL.

E.g: in SQL Server T-SQL syntax, concatenating a string with a value column requires you to do something like: 'Result = ' + STR(Value,6,1) in this case the 'Value' is a column that holds a numeric parameter. This numeric parameter column cannot be concatenanted with a string unless it is first converted to a string value itself. The STR() function does that. Otheriwise, if you were to do: 'Result = + STR(Value,6,1)' then the location of apostrophes will cause the result to appear with the plus signs just as you see it in your bug report.

Can you otherwise, paste the MySQL query for us to check-out?

Regards

Anthony L.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.