Devart Forums

Hi,

>You can work with Informix in UniDAC using IBM Informix ODBC Driver.

I will continue discussion here.

I tested it and result is very bad.
I am using last Unidac (4.1.4/XE2), last ODBC driver (Informix Connect 3.70) and last Informix Dynamic Server (11.70).

If INTERVAL, BLOB, CLOB, BIGSERIAL or BIGINT built-in databyte is in table, then after open "Data type is not supported." exception is thrown.

Storing some data into TEXT or LVARCHAR datatype ends with "String data right truncation".

What is interesting, storing picture to BYTE datatype returns "String data right truncation" too.

Troubles with BYTE, TEXT, BLOB and CLOB means, that no comments or pictures can be used

For now I did not test more features.

Leos

Hi leonell

I have used IBM ODBC drivers before with other components and found them unreliable. I switched to OLEDB and had no problems at all.

Thank you very much.
Please what components are you using?
I tested dbgo/XE2 and have troubles.
Leos

Added later:
My troubles were related to stores_demo database. Probably some relation to attached datablades (?!). When I created new database problematic INSERTs are working. Now I look for solution how to get last SERIAL value. Then I will prepare some more advanced example.

Hello,

The types you have listed are the specific INFORMIX types and they are presently not supported in UniDAC ODBC provider. We will try to implement the support of these types in one of the next versions of our product.

Hi Everybody,

We are trying to convert our sourcecodes from dbExpress to UniDAC, but we are facing this problem too. Is there any way to solve this problem?

We are also getting this error on BLOB fields (Informix 12.1 Server and ODBC Driver is 4.10)

If we pass this issue we will going to buy UniDAC Components.

Thanks in advance.

Thank you for the information. We will investigate the described issue and let you know the results shortly.