ODBC Driver for Firebird: SQL Error

ODBC Driver for Firebird: SQL Error

Postby oHenri » Wed 19 Aug 2015 17:02

Up to now we are using the Firebird/ODBC for accessing a firebird DB from a Centura program.

Worked more or less - but it did not insert (text) data into BLOBs.

Now I found and tried the Devart ODBC for Firebird (trial version 32Bit on W2008R2)
By using the same program
- connection works (by using sysdba)
- but "insert" as well as "update or insert" fails with SQL error 30000 which I did'nt found anywhere.

Did anyone have this ODBC driver running?

Thanks in advance for any tips or help.
oHenri
 
Posts: 2
Joined: Wed 19 Aug 2015 16:52

Re: ODBC Driver for Firebird: SQL Error

Postby AlexP » Thu 20 Aug 2015 08:04

Hello,

Please specify the text or a screenshot of the error message.
AlexP
Devart Team
 
Posts: 5528
Joined: Tue 10 Aug 2010 11:35

Re: ODBC Driver for Firebird: SQL Error

Postby oHenri » Fri 28 Aug 2015 11:47

Now I can state the problem more precisely - and I found two problems

1) Handling of Timestamp fields
DB Field: Timestamp
PG Field: Date/Time (which is in Centura programs the equivalence to Timestamp)
Read into program: only Date portion handed over, time portion is lost.
Write into program: produces an SQL error
Dynamic SQL Error SQL error code = -303
conversion error from string ""

This handling (of real date/time fields used on programs side), however, works with Firebird's ODBC (Version 2.0.3)

When I handover the date/time in a string, then it works - but I ask me about problems of different date/time format specifications on the client side.

So from my point of view, correct date/time handling (which is then independened from local format settings) would be the best for proper operation.


2) Handling of BLOBs
By using Firebird's ODBC (Version 2.0.3), BLOB handling does not work - at most, strings are cut after about 200 bytes or so (read and write).
That's the reason why I want to try the Devart ODBC.
But the Devart ODBC also cuts long strings - in transfers more bytes, about 300 or so, but still not the whole string of about 2-8KB.

Here I am not shure if the problem is located on the programs-ODBC or on the DB-ODBC side.

To find out this, I will try out next week an ODBC to SQL Server to see how it works.
oHenri
 
Posts: 2
Joined: Wed 19 Aug 2015 16:52

Re: ODBC Driver for Firebird: SQL Error

Postby ViktorV » Wed 30 Mar 2016 13:57

Please download the latest driver version 2.0.1 and try to reproduce the issue again. If the error reproduces on the latest driver version, please send us a link to download a trial version of Centura for compatibility testing.
ViktorV
Devart Team
 
Posts: 1869
Joined: Wed 30 Jul 2014 07:16


Return to ODBC Drivers