Bug in Database Connectivity Toolset Version 1.0.1

[Yvan_Gauthier]

This bug is probably a problem related to ADODB.  Here is my problem.  I’m trying to get the possible values from an Enum field in a MySQL database.  I’m using this SQL command: SHOW COLUMNS FROM table_name LIKE enum_name.  When using the MySQL Query browser, I get the following response: enum('element1','element2','element3','element4').  When using the Database Connectivity Toolset I get the following response: enum('element1','element2','element3','e\00\00\00\00\00\00\00\00\00.  In other words, I get the first 40 characters OK and the other characters are transformed to \00.  I tried the LabSQL toolkit from Jeffrey Travis and I get the same result so I’m guessing the problem is coming from ADODB.  Has anybody seen this problem?  Am I supposed to specify the number of characters to be received somewhere?  If so, where do I find this parameter?

I’m using the following software:
- WINXP Pro SP2
- Labview 7.0
- MySQL 4.0.13
- Database Connectivity Toolset 1.0.1

Any help would be appreciated.

Yvan Gauthier
Programmer
Ignis Photonyx

[Elsa Fung]

did you try the "DB Tools List Columns.vi"?

i never use the database functions in LV, so i'm not sure how it works... hope this helps ^_^

[Yvan_Gauthier]

That is a good suggestion.  I actually didn't see that VI.  Unfortunatally, the information given about colums in this VI is only basic types such as string, long, double,...  The enum type is seen as a string so I don't get the detail about the enum values.

Thanks anyway,
Yvan

[Elsa Fung]

the column information output doesn't do any good either?

sorry couldn't help...

[Ankita]

Hi Yvan,

I haven't worked with SQL databases before but I would like to verify the bug you have reported so I could report it to the R&D team for investigation.

Could you please post your database on this thread so I could verify if its a bug.

Regards,

Ankita

[Yvan_Gauthier]

Here is the picture of my code.  Thanks for the help.