Re: CLI-32 and Access

gbravi@dolphin.it scritto nell'articolo <33DCD818.61A9@dolphin.it>... > Hi. > I am using Access97 for accessing data thru Informix Cli-32 ODBC > drivers. When i try to link a new table, i see the message: > > [INTERSOLV][ODBC Informnix driver][Informix] Corresponding column types > must be compatible for each UNION statement. (#308) > > Strange: it work fine for already linket tables ( whith another ODBC > driver) and under MS-Query. > > Any Idea ?? > > Giorgio. > In the current statement, a column in the second or subsequent SELECT does not agree with the same column in a preceding SELECT. Review and compare all the SELECT statements. Check each point at which one selects something that is not identical to the preceding SELECT statement. Is it enough? Bye, Alberto