PIOLEDB Timeout parameter

Discussion created by Kenneth.Rice on Feb 24, 2011
Latest reply on Feb 28, 2011 by andreas

Hi folks Im confused and need help.


I am running this query : Select Distinct  tag FROM piarchive..picomp2
WHERE status =-170 AND time BETWEEN '1-Jan-2009' AND '1-Feb-2009'


it works fine on PIOLEDB msc console "GREAT" but I need the result set in a report form i.e. Excel


I set the timeout parameter as hi as it is on the msc console and run query only to get a Timeout has expired message.


Same results if I run command line tool MyPISQL or the GUI PI OLE DB Tester.


I prefer the results in Excel.


Any help is appreciated


thanks in advance