DATE Data Type error in ASP - SQL dialect problem?
Posted on 2004-09-23
Anybody know why I'm getting this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[INTERSOLV][ODBC InterBase driver][InterBase]Dynamic SQL Error, SQL error code = -206, Column unknown, HIRE_DATE, Client SQL dialect 1 does not support reference to DATE datatype
I know my database is set to dialect 3. I can't get it to return or write to any field in DATE data type.
The column is named HIRE_DATE, btw so I don't know why it would say it is unknown.