Re: dbaccess5 crashes against IDS 7.30 with GLS/NCHAR

Richard Spitz wrote: > when I use dbaccess 5.10UC1 to connect to an IDS 7.30UC1 server over > a TCP/IP network, it dumps core when I do a simple select against > a table which contains NCHAR columns. [SNIP] > I am presently in the middle of migration from 4.x frontends and > 5.10 backend to 7.20 frontends and 7.30 server. I had hoped that > I could first migrate the server and then the client applications > one by one, but this is now a serious problem. When I switch to > 7.30 on the server, I'd like to take advantage of GLS to get the > correct collating sequence for German umlaut characters, but using > NCHAR and NVARCHAR instead of the previously used CHAR and VARCHAR > data types is mandatory for this functionality. > Seems like I'm caught between a rock and a hard place, or is there > a solution for this? Let me reiterate the advice I give everyone who is migrating from 5.xx to 7.xx. Migrate your applications to 7.xx first, they will run even better than the native 5.xx programs against the 5.xx server, they just need a 7.xx runtime environment and a pipe or network connection to the 5.xx engine. Then once the apps are recompiled and tested with minimal changes, perhaps to take advantage of new ESQL or 4GL features that are engine independent, such as multiple connections, you can upgrade the engine confident that the apps will continue to work just fine. The last step is to reengineer the converted apps to take advantage of new engine features. This is the upgrade method I use, it is the least intrusive and the most likely to succeed while your head still has hair. Some have shaken their heads at me in the past when I gave this advice. Richard's sad tail is the proof of what can happen if you try it the other way round. Art S. Kagel