MSAccess and Informix

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

Karmen — Wed, 10 Mar 1999 10:58:13 +0100 — source: Informix-list mailing list archive (1991-1998)

Hello All, We have Informix OnLine 7.22.UC1 and Sun Solaris 2.5 on server side, and Informix CLI 2.50.TC2, WIN95, MSAccess (Office97) on client side. Tables from Informix database are linked into MSAccess application. How to do ORDER BY informix_table_name.column_name on linked table when informix_table_name.column_name don't have unique index. There is no problem when we have unique index on informix_table_name.column_name, but we get ODBC call failed in other casses. Thanks in advance, Karmen

↪ replying to Karmen

Klaus Gotthardt — Wed, 10 Mar 1999 12:03:43 +0100 — source: Informix-list mailing list archive (1991-1998)

Karmen wrote: > > Hello All, > We have Informix OnLine 7.22.UC1 and Sun Solaris 2.5 on server side, and > Informix CLI 2.50.TC2, WIN95, MSAccess (Office97) on client side. > Tables from Informix database are linked into MSAccess application. > How to do ORDER BY informix_table_name.column_name on linked table > when informix_table_name.column_name don't have unique index. > There is no problem when we have unique index on > informix_table_name.column_name, but we get ODBC call failed in other > casses. > Thanks in advance, > Karmen Change the properties 'datensatzgruppentyp' in german of the query (right mouse) from dynaset to snapshot. -- Klaus Gotthardt, Johann Wolfgang Goethe-Universität,Verwaltungsdatenverarbeitung Email: K.Gotthardt@em.uni-frankfurt.de Tel:+49 (0)69-798-23380 Fax:+49 (0)69-798-23381 pgp-key: http://www.rz.uni-frankfurt.de/~gotthard/KLAUS_GOTTHARDT.PGP