Strictly through a VBScript loop, I am using OLEDB commands to insert rows into a table. Right now, cscript.exe has done 70,000 rows. I opened the DBC inside the VFP7 IDE, and did a "select count(*) from mytable" and I get zero 0 rows back. How come?

It smells like the OLEDB driver is not flushing anything, even after 70,000 rows. What can I do to make the driver actually write to the table?

Thanks.