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