ADO SQL Server

[Tracy_M]

Please help if you can- Why when I run a basic, bare-bones SQL SELECT query through SQL Enterprise Mgr it returns records in 2 seconds- but when I run this same query through ADO it takes forever! I set the Command timeout to 5 minutes and it still is not enough. For testing only I have a simple loop to MoveNext through all the records.

Thank You In Advance

TM