Read from database (Access) and update fields using MS ADODB

[a 3]

Hello,

I am trying to get records from database using MS ADODB._connection & ADODB._Recordset objects (from LabVIEW 6)

I can:
1. open connection (with ADODB._connection)
2. write into tables (with ADODB._command)

I can not: gets records and update fields using ADODB._connection & ADODB._Recordset.

I do not know:
1. how to connect between the connection that was opened and the recordset object
2. where I can write the SQL text as input to the recordset

Attached is DataBase.llb with DB_read.vi that display my steps.

Thanks.

[Lab Viewer]

Try this one, after updating the names for database and the table you want.

Let me know if it's working.

p.s.: if you have problems, it could be a different adodb version ... but the sequence of methods is the same