Subject | XTG ODBC driver... |
---|---|
Author | Klerman Gutierrez |
Post date | 2003-05-05T02:06:23Z |
Hello,
Has anyone found problems with dates using the XTG system's ODBC driver for
Interbase ?.
I have setup this simple table in FB:
customer_ID integer
customer_name varchar(40)
customer_dateofbirth DATE
With isql, I've been able to insert data in this table, for example:
insert into CUSTOMERS (customer_id, customer_name, customer_dateofbirth)
values (1, 'John', '12-31-1962');
I linked the table to an Access database with the mentioned ODBC driver. I
have tried to perform an insert from an Access query using almost all the
date formats the XTG's readme.txt mentions, with no luck. It always returns
an out of range ODBC error. The query is similar to the one above. But the
data inserted with isql is shown as expected.
Any tip will be apreciated,
Klerman
Has anyone found problems with dates using the XTG system's ODBC driver for
Interbase ?.
I have setup this simple table in FB:
customer_ID integer
customer_name varchar(40)
customer_dateofbirth DATE
With isql, I've been able to insert data in this table, for example:
insert into CUSTOMERS (customer_id, customer_name, customer_dateofbirth)
values (1, 'John', '12-31-1962');
I linked the table to an Access database with the mentioned ODBC driver. I
have tried to perform an insert from an Access query using almost all the
date formats the XTG's readme.txt mentions, with no luck. It always returns
an out of range ODBC error. The query is similar to the one above. But the
data inserted with isql is shown as expected.
Any tip will be apreciated,
Klerman