Database Variant to data not working when converted from LV 2010 to 9

[NitzZ]

Hi all,

I have a simple code which i made in LV 2010 for displaying data from an MS access sheet into an array in which i used the DATABASE VARIANT TO DATA tool. But when i converted this file into an LV 9 VI and opened it in another computer running with LV 9 , the wires connecting the data terminal of SELECT DATA tool and DATABASE VARIANT TO DATA tool are broken. Error message is Type 1 is 2d array and type 2 is void. Opening the same converted file in LV 2010 doesn't give any error and is running fine.Can anyone please tell me what should i do to rectify this problem.

Regards,

Nitzz. 

[altenbach]

Random thought: Do both computer have the same version of office installed?

[NitzZ]

Thanx for your reply Christan. Yes, both are having the same Office. I even tried installing LV 9 in the same computer which had LV 2010 and then tried to open this file, but still it is showing the same error. The DATABASE VARIANT TO DATA tool itself is looking different in LV9. I mean in LV 2010 the input data terminal is thick just as the output terminal of SELECT DATA tool. But in LV9 the data input terminal is a thin variant wire as thick as a ID array. 

Any solutions for this?? I am so stuck because of this as i developed the whole code using LV 2010 (trial version) and I want to run this in LV 9 to make the exe. This is the most important part of the code without which i can't proceed. Rewriting the whole code would be so painful for me.

Regards,

Nitz..

[blawson]

DB variant to data saw a lot of improvements in LV2010.  It works pretty differently in 2009 and earlier, and it had some issues.  Use a normal variant-to-data primitive instead.

[NitzZ]

Hello Barrette,

Could you please post an example of selecting a table from the database (access) using the Select from Database tool and then displaying it to an LV indicator. I have posted an example of what i am trying to do, but i am getting an error.

Any kind of help would be appreciated.

Regards,

Nitzz

[G_K]

Hello Nitzz,

I just modified your vi to convert the data base table data in to a specified cluster data forma and i hope this will solve your problem.

Ganesan Kani

[NitzZ]

Hello Ganeshan,

I still am getting some errors. Can you please check this vi.

Regards,

Nitzz

P.S. : Can you post the vi instead of the image?

[G_K · Accepted solution]

Nitzz,

The changes you have done in your attached vi is not correct.

pls find the vi attached..

[NitzZ]

Thats exactly what i needed.. thank you so much..;)