I don't know a lot about SE 7.23
but wich Online 7.2x and ODBC drivers based on pre 7.2x you get in
trouble with MS-Access:
Reason: the columns in several systables changed from char to nchar.
Access does a lot of rewding (actualy the odbc-driver does) in does
tables.
Maybe this helps
TIA,
Harald Ums
infodata@batelco.com.bh (INFODATA) wrote:
>Hello there,
>
>I have SE 7.23.FC1 sitting on DEC ALPHA server (DEC UNIX 4.0). I am trying
>to attach tables from my Informix databse thru MS-Access 2.0 on my PC (win
>95). I have I-NET 5.01.WJ2 installed and configured correctly on the PC and
>I am using the Intersolv 2.52 Informix 5 ODBC driver.
>
>In Access, when I try to attach the Informix table, I am able to see a list
>of all tables existing in the Informix database, but when I attach to any
>table, I always end up getting the foll. errors:
>
>1. "ODBC Call failed" followed by
>
>2. [Intersolv][ODBC Informix Driver][Informix]
> Corresponding column types must be compatible for each UNION statement
> (error # -308)
>
>This situation is quite puzzling. I do not see why I should be getting this
>error, as I do not have any UNION of SELECT statments.
>
>If anybody could shed some light on this one, I'd be most grateful.
>
>TIA,
>
>Sandeep Soneja
>
>
Harald Ums Tel : +49 (0)89-9507-5140
PRO 7 Televisions GmbH Fax : +49 (0)89-9507-5191
Bahnhofstra'e 28
D-80767 Unterf'hring e-mail: Harald.Ums@sevensys.de