tbinkley
asked on
DATE Data Type error in ASP - SQL dialect problem?
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The InterBase Date data type dialect 1 includes a date portion (including day, month, and year)
and a time portion (including hours, minutes, and seconds).
This DATE datatype is 64 bits long for values 1 Jan 100 to 11 Dec 5941 and also includes time information.
Since IB6 you can choose dialect 3 too.
Dialect 3: transition features are interpreted as SQL-92 compliant.
DATE has changed from a 64-bit quantity containing both date and time information to a 32-bit quantity containing only date information
TIME is a 32-bit quantity containing only time information.
TIMESTAMP is a 64-bit quantity containing both date and time information (same as DATE in InterBase 5 and older).
That's why your setting don't support the reference to DATE datatype.
May be your setting is not 3 but 1. Try to check it.
wbr Janos