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

[bill l. <cbi...@gm...>]

Steve,
You did not show how you call sqlbindcol, without detail it is hard to
guess what was wrong.

Втр, 05 Окт 2010, Steve писал(а):
> Here is a resend of the original message (including .ini files) from March
> this year.
> 
> Is that what you meant?  I can send you the Perl code snippet if you like,
> but maybe that's too much detail.
> 
> Regards
> 
> Steve
> 
> > Sent: 24 March 2010 21:50
> > 
> > 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
> > 
> 

-- 
regards,
====================================================
GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3