Re[2]: Puzzling ODBC Error ...

We are using a lot of 16 bit applications on windows 95, and yes we did have several problems, but using WJ2 along with the Intersolv driver provided with the WJ2 release solved all of it ( QEINF509.DLL ). A word of caution, though. WJ2 has a known memory leak problem, and is "reportedly" fixed in the WJ3 release. A lot of support staff at Informix themselves were not aware of this fact. I do not know if that could be the problem Let me know if you have fixed/found the problem Sujata ______________________________ Reply Separator _________________________________ Subject: Re: Puzzling ODBC Error ... Author: <Nils.Myklebust@idg.no> at internet Date: 10/8/97 5:13 PM I would expect all kinds of errors and problems using old 16 bit software on Windows 95. You should upgrade your ODBC driver and MS Access to the latest versions. If you do you will save yourself so much trouble the cost of the upgrade isn't an issue at all (unless you view your own time as extremly cheap of course). It's very important to understand that MS Windows and it's software is not very compatible from version to version. Both MS and other suppliers do all kind of strange things that might or might not work on a new version. This upgrade from 16bit to 32bit adressing is additionally quite extensive, so I would expect even more problems than usual. 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 Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org