Re: [sqlite] Using ODBC with Microsoft Access

[Buzz Hill]

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]
-

[sqlite] Using ODBC with Microsoft Access

[Buzz Hill]

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