Re: [sqlite] Using ODBC with Microsoft Access
Thanks. Turned out to be a bad driver. Got the update and everything works as expected. - Original Message From: Nikki Locke <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Thursday, December 7, 2006 4:30:15 AM Subject: Re: [sqlite] Using ODBC with Microsoft Access Buzz Hill wrote: > I am trying to pull records from a Microsoft Access db using > ODBC. .. > The problem I am having is with > dates. Something as simple as: > > SELECT * FROM CostingHeader > where DeliveryDate = '2/6/2004' Access has its own unique syntax for dates (surrounded with # and in mm/dd/ format, I think). However, I have a feeling it will accept Ansi standard date format in a quoted string ('2004-02-06' for a date or '2004-02-06T12:02:02' for s date with time (the T is important). -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Using ODBC with Microsoft Access
Buzz Hill wrote: > I am trying to pull records from a Microsoft Access db using > ODBC. .. > The problem I am having is with > dates. Something as simple as: > > SELECT * FROM CostingHeader > where DeliveryDate = '2/6/2004' Access has its own unique syntax for dates (surrounded with # and in mm/dd/ format, I think). However, I have a feeling it will accept Ansi standard date format in a quoted string ('2004-02-06' for a date or '2004-02-06T12:02:02' for s date with time (the T is important). -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Using ODBC with Microsoft Access
Buzz, Access questions should be directed to Microsoft. http://office.microsoft.com/access/ On 12/6/06, Buzz Hill <[EMAIL PROTECTED]> wrote: Hi, I am trying to pull records from a Microsoft Access db using ODBC. The connection works fine. I can get results when I test for any field with an integer value. The problem I am having is with dates. Something as simple as: SELECT * FROM CostingHeader where DeliveryDate = '2/6/2004' or SELECT * FROM CostingHeader where DeliveryDate = 2/6/2004 simply fails to yield any results. I know that the date 2/6/2004 exists. I don't understand what Access is looking for. Thanks, Buzz -- -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Using ODBC with Microsoft Access
Hi, I am trying to pull records from a Microsoft Access db using ODBC. The connection works fine. I can get results when I test for any field with an integer value. The problem I am having is with dates. Something as simple as: SELECT * FROM CostingHeader where DeliveryDate = '2/6/2004' or SELECT * FROM CostingHeader where DeliveryDate = 2/6/2004 simply fails to yield any results. I know that the date 2/6/2004 exists. I don't understand what Access is looking for. Thanks, Buzz