Unsupported database type: 110

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Unsupported database type: 110

Post by sinys » Wed 03 Feb 2016 15:56

Hello,
After update ODAC on new 9.6.22 release I have error:

Unsupported database type: 110

when I open OraQuery with DataTypeMap

DFM source:

Code: Select all

 object AQuery: TOraQuery
    DataTypeMap = <
      item
        DBType = 109
        FieldType = ftTimeStamp
      end
      item
        DBType = 111
        FieldType = ftTimeStamp
      end
      item
        DBType = 110
        FieldType = ftTimeStamp
      end>
...
Version 9.6.21 worked fine.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unsupported database type: 110

Post by AlexP » Thu 04 Feb 2016 09:25

hello,

To solve the issue, you should replace in DFM

Code: Select all

DBType = 110
with

Code: Select all

DBType = 112

sinys
Posts: 186
Joined: Tue 21 Feb 2012 03:44

Re: Unsupported database type: 110

Post by sinys » Thu 04 Feb 2016 14:52

Bad idea to change constant numbers.
I see now I have to change
111 -> 113
123 -> 115
124 -> 116
Can you save constant name like ftIntervalYM, ftIntervalDS etc in DFM (insted of const numbers like 113,115,116)?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Unsupported database type: 110

Post by AlexP » Mon 08 Feb 2016 09:34

We will consider the possibility implement saving of text type names in DFM in one of the next versions.

Post Reply