nyc10036

By the way, remember to register you database at the ODBC in order to make modification to the database. Good luck!

3379[/snapback]

Actually it is not necessary to register your database in ODBC.

I've used DSN-less connections and it works fine for both Microsoft Access and MySQL.,

People are willing to help, but you have got to show that you attempted to do something.

Upload a VI or two to show what you have so far.

A blanket request for someone to send you the solutions is perceived as plain laziness

and amounts to cheating.

It seems to me you may need to speak to your instructor again because you appear not to even understand what the exact requirements of the homework problems are.

Hi, I hav just started to learn ActiveX to write data into my database developed using MS Access. I need to update my database everytime I execute my VI. FYI, I am using LabVIEW 6.0. I have found an example of how to read from a database but have no idea how to choose the method and property. Have anybody have any VI or any good material to read on about ActiveX property other than the brief intro doc available in NI website? Your help will be very much appreciated.

2779[/snapback]

The Microsoft documentation about ADO is actually pretty good.

It's geared towards Visual Basic, so you'll have to "translate" it into LabVIEW.

I wrote to a MS Access database using LV 5.1 at my previous employer.

I also found the book Active Data Objects for Dummies very help.

:laugh:

I needed a good laugh for a Friday morning.

I can't believe he had the nerve.

Arnoud,

thanks very much.

setting the CursorLocation for the Recordset before opening is the key

also, in LabVIEW 6.1, I found that if the Recordset has NULLs in any field,

the Invoke Node -> GetRows will not work

What method are you using to communicate with your database?

3005[/snapback]

I am using a DSN-less connection.

I am attaching my VI.

I do not get an error, but the RecordCount returns a -1.

Download File:post-1228-1103037155.vi

I've been in the past able to read/write from Microsoft Access database.

Recently, I am trying to do the same with MySQL.

I have read the PDF file from this website.

I am having trouble with the basic of just using a SELECT * query.

I want to see the data returned.

I can't figure out how.

Anyone who has done this?