Re: Date-Fields via ADO
From: Ross McKay (rosko_at_zeta.NOT.THIS.BIT.org.au)
Date: 04/27/04
- Next message: Amal: "What is the best Reportinf mechanism in .Net ?"
- Previous message: Lysander: "Date-Fields via ADO"
- In reply to: Lysander: "Date-Fields via ADO"
- Next in thread: Lysander: "Re: Date-Fields via ADO"
- Reply: Lysander: "Re: Date-Fields via ADO"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 27 Apr 2004 09:52:28 GMT
On Tue, 27 Apr 2004 01:56:05 -0700, André wrote:
>hope this is the right place to ask. Maybe somebody already heard about
>this one, and knows a remedy.
>Connecting to firebird/interbase via odbc/ado results in fatal error.
>Code "SQL Error -804, invalid structure in SQLDA structure". This only
>affects fields of type "date". Using - for example - MSQuery to retrieve
>a recordset including a date-field will cause an error. Selecting all
>other field-types and leaving out date-fields works fine.
This sounds familiar, but I don't remember much about it... however, I
suspect that your problem is one of ODBC driver compatibility. What
version / vender is your ODBC driver?
For reference, I've used the INTERSOLV 3.11.1.0 driver, and the
Visigenic 2.0.9.2 driver, against IB 5.6 with no problems, but I have a
vague memory of older drivers from INTERSOLV failing on Date fields.
You might want to make sure that the version of your Interbase client
matches the version of your Interbase server.
cheers,
Ross.
-- "There is more to life than simply increasing its speed." - Mahatma Gandhi
- Next message: Amal: "What is the best Reportinf mechanism in .Net ?"
- Previous message: Lysander: "Date-Fields via ADO"
- In reply to: Lysander: "Date-Fields via ADO"
- Next in thread: Lysander: "Re: Date-Fields via ADO"
- Reply: Lysander: "Re: Date-Fields via ADO"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
