Informix CLI 2.0 : problem with ODBC driver using MS-ACCESS and MS-QUERY
Posted in 1996
I have a weird problem using Informix CLI 2.0 in combination with MS-ACCESS 2.0 and MS-QUERY. While trying to set up an ODBC connection a ran into a strange problem : When I try to attach a table from the Informix stores 7 database I get an MS-ACCESS error : "owner_tablename" is not a valid tablename (e.g. "informix.customer" is an invalid tablename. When I try to access the same table from MS-QUERY, I can perform selects but no updates, inserts or deletes. The main difference between MS-ACCESS and MS-QUERY is that MS-ACCESS uses its Jet-Engine, MS-QUERY doesn't. Public has insert, update, delete on all tables and views. Informix Belgium has advised me to put a view on every table : "create view xxxx as select * from yyyy". This allows me to attach to all the views except the ones on the stock table and on the stores table. When I grant DBA to public I a can attach to all the views from MS-ACCESS but not to the tables. I am unable to modify the views from MS-ACCESS, modifying them from MS-QUERY works fine. Microsoft Belgium has advised me to drop all indexes on the tables before attaching to them. This allows me to attach to the tables from MS-ACCESS but not to modify them. I'm a bit puzzled here ... Can anybody shed some light on this problem, please. My configurations used in testing : Informix 7.10 UC1 on SCO 3.2.4 Informix 7.12 UC1 on SCO 3.2.5 (Openserver 5). MS-Windows 95, MS-ACCESS 2.0 MS Windows 3.11, MS 32-bit TCP/IP, MS-ACCES 2.0 All combinations of Informix engines and client OS produce the same errors. Please e-mail me if you know what is going wrong. Koen