RE: [U2] unioledb connection from SQL2000
What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
Up here, in the Great White North, we have to watch the regional settings. Sometimes using a different date format causes problems - whether it's the order or the delimiter. It seems to be a problem with your dates - so this is where I would start... Colin Alfke Calgary, AB -Original Message- From: Lettau, Jeff 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 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unioledb connection from SQL2000
First off. Thanks for the response. Next. We figured it out. We used an updated driver from our version 6.03??? Unidata disk instead of the 5.2??? Version that was on the old server. I think the numbers of the actual driver are not that different. But to make a long post shorter I'll just say the answer to the question is formatting. The date needs to be 2005-06-27 not 06-27-05 Why? I don't know. And do I care? Not all that much now that it works. So the secret word of the day is International date format. So It's 3 words. So sue me. I'll return to lurking again. Thanks. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Noah Hart Sent: Thursday, August 25, 2005 2:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unioledb connection from SQL2000 What version Unidata and Client tools (especially ODBC driver) are you using? Noah -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff Sent: Thursday, August 25, 2005 8:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] unioledb connection from SQL2000 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 u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/