[Firebird-odbc-devel] Firebird 2.1 ODBC Numeric and Date fields.

[Steve C. <ste...@sc...>]

Hi People,

I am using Perl on Linux (Kubuntu 9.10) with Firebird 2.1.  I wanted to use
ODBC, but in the end I gave up using it because I couldn't get the DATE or
number formats to work.  Instead I used the DBI::Interbase driver, while it
works, it is subject to occasional crashes, so I'd like to go back to trying
ODBC.

My current problem is that if I use isql on employee.fbd, (eg select first 1
change_date from salary_history), I get:

1992-12-15 00:00:00. (Data type timestamp)

if I use it on my own database, (eg select first 1
att_patient_examination_ddt from tbl_patient_exam), I get:

22256-10-18.  (Data type date)

Any ideas what I could do?

Well, actually, writing that last bit has helped.  If I change from a DATE
data type to a TIMESTAMP, it seems to work, but now I need to check time
fields and number fields.  Surely the DATE format should work?  What do I
need to do to fix this (NB Flamerobin has no such problems on the same
field)?  I am also encoutering other sporadic problems such as a read being
successful one moment and unsuccessful the next?  Is this a known problem?

Regards

Steve

The odbcinst.ini file entry is:

[Firebird]
Description		= Firebird/InterBase(r) driver
Driver		= /usr/lib/libOdbcFb.so
Setup		= /usr/lib/libOdbcFb.so
UsageCount		= 2

The odbc.ini file entries are:

[END_DB]
Description = Firebird
Driver = Firebird
Dbname = localhost:/home/steve/Documents/Endoscopia/DB/ENDOSCOPIA.FDB
Client          =
User = SYSDBA
Password = masterkey
Role            =
CharacterSet    = NONE
ReadOnly        = No
NoWait          = No
Dialect         = 3
QuotedIdentifier        = Yes
SensitiveIdentifier     = No
AutoQuotedIdentifier    = No

[Employee]
Description = Firebird
Driver = Firebird
Dbname = localhost:/home/steve/Documents/employee.fdb
Client          =
User = SYSDBA
Password = masterkey
Role            =
CharacterSet    = NONE
ReadOnly        = No
NoWait          = No
Dialect         = 3
QuotedIdentifier        = Yes
SensitiveIdentifier     = No
AutoQuotedIdentifier    = No