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
INFORMIX ODBC problems
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.
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.
Re: INFORMIX ODBC problems
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.
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.
Re: INFORMIX ODBC problems
Thank you for the information. We will investigate the described issue and let you know the results shortly.