Kenneth.Rice

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

Outcomes