Re: DATETIME becomes TEXT when linked to MS-Access

[jon.cooper]

David - I am experiencing exactly the same problem when accessing the db from Coldfusion. I have installed 3.51.11-2-win.exe and stopped and restarted the entire machine to make sure everything kicks off correctly but still getting the same problem when performing pretty much any action on a date. eg:

select count(*) as counter, dayname(date) as daystring
from views v, lookup_viewtypes lvt
where lvt.viewtypeid = 1 and lvt.viewtypeid = v.viewtypeid and v.uniqueid = 12345
group by day

Daystring comes out as binary which is completely unusable.

This is now causing me serious grief and could do with a quick response!

many thanks

Jon