?
Solved

DATE Data Type error in ASP - SQL dialect problem?

Posted on 2004-09-23
4
Medium Priority
?
1,516 Views
Last Modified: 2013-12-09
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.
0
Comment
Question by:tbinkley
2 Comments
 
LVL 19

Accepted Solution

by:
Nick Upson earned 1000 total points
ID: 12134311
I think the problem is the intersolv odbc driver you are using, it was only intended to talk to dialect 1 databases
before such things existed. It was originally used for interbase 5.

To confirm this download a tool that doesn't use odbc and use that to apply the exact same SQL
personally I use ibadmin which has a suitable trial version from http://www.sqlly.com/

to fix it you need to replace the odbc driver, I can recommend either the ibphoenix one (www.ibphoenix.com)
or the easysoft one (www.easysoft.com)
0
 
LVL 10

Expert Comment

by:kacor
ID: 12134356
Hi tbinkley,

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



0

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
I recently worked on a Wordpress site that utilized the popular ContactForm7 (https://contactform7.com/) plug-in that only sends an email and does not save data. The client wanted the data saved to a custom CRM database. This is my solution.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question