Steve Cookson
15 years ago
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
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