Subject | Date field via ADO/ODBC |
---|---|
Author | lysander4444 |
Post date | 2004-04-27T11:53:21Z |
Moin,
I have severe problems in accessing fields of type "date" via
ADO/ODBC, and I cannot find a reasonable explanation.
A database contains a table with all types of fields. Using - for
example - MS Query to create a new query for Excel everything works
fine until I also select the date field. Then I will get a "incorrect
values in SQLDA structure -804".
This happens with IBPhoenix-Driver as well as with EASYSOFT-Driver.
I need to find the solution, because I plan to use firebird for my
future delphi-projects (Using ADO-Components in Delphi brings up the
same error as soon as a date-field is accessed).
Using Firebird 1.5 with MDAC 2.7 SP1
Any hint will be appreciated.
regards,
André
I have severe problems in accessing fields of type "date" via
ADO/ODBC, and I cannot find a reasonable explanation.
A database contains a table with all types of fields. Using - for
example - MS Query to create a new query for Excel everything works
fine until I also select the date field. Then I will get a "incorrect
values in SQLDA structure -804".
This happens with IBPhoenix-Driver as well as with EASYSOFT-Driver.
I need to find the solution, because I plan to use firebird for my
future delphi-projects (Using ADO-Components in Delphi brings up the
same error as soon as a date-field is accessed).
Using Firebird 1.5 with MDAC 2.7 SP1
Any hint will be appreciated.
regards,
André