We moved our SQL2000 database to a windows2003 server. Now when I try to do a query against my Unidata database it fails to return any rows. But only on this query. Select ID,Inv_So_Date,Sales,Record_Type,Ord_Class,Order_Type_Desc from DailySales WHERE Inv_So_Date >= "06-27-05" AND Inv_So_Date <= "09-25-05"; If I take the date selection out of my query, it runs fine. I get about 2 million rows and it takes 20 minutes but it runs. I won't say all the queries work, but I can say that most do work without issues. Including the Linked server to Unidata works. But just not this oledb connection with parameters in a DTS package. Is there some trick to get this to work.
Jeffrey Lettau ERP Systems Manager polkaudio ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
