nyc10036

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.

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

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?