ADO Wiki example not working?

[Jfish]

I was trying to play around with ADO this AM.  I was using the Wiki example but for some reason I can't get it to work.  The symptom is that the while loop just keeps going and does not produce any data from the queries, just the consolewrite lines.  I searched the forum and saw some chatter from last year about ADO breaking changes but @water had commented that the Wiki example was not impacted.  I am figuring it must be operator error on my side but I wanted to ask all the same just to be sure.  Any guidance would be appreciated.

[water]

Which version of AutoIt do you run?

[Jfish]

I am currently on 3.3.12.0

[water]

Which example does not work? The one for Text file or for Excel?

[Jfish]

Excel: https://www.autoitscript.com/wiki/ADO_Example_Excel

 

[water]

Please change the following line and give it a try:

Global Const $iOptions = 512 ; adCmdTableDirect - Return all rows from the specified table

 

[Jfish]

Yes! That worked.  Thanks for your wizardry.  I was going crazy - thought it was my connection string or something else.  

[water]

IIRC I brushed up the example long time ago - and it looks like I introduced an error