Solved

DATE Data Type error in ASP - SQL dialect problem?

Posted on 2004-09-23
4
1,491 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
4 Comments
 
LVL 19

Accepted Solution

by:
NickUpson earned 250 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Creating and Managing Databases with phpMyAdmin in cPanel.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

705 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now