Re: RE Re: NLS database and MS Access

Hi There, The way you fix this problem is by taking advantage of our ODBC Drivers ability to cater the DBMS server sensitive host operating environment variable configuration. The OpenLink Rule Book section "[Environment Informix7]" allows you to set the appropriate values for critical Informix host operating system environment variables. Set the appropriate values for NLS in this section . "Edmar Schut" <edmar@svb.nl> wrote in article <4ta1ud$hre@cssun.mathcs.emory.edu>... > Koen replied with > >On your UNix server, make sure you created the NLS database with the > >Unix environment variable not set to C ! Set it to something like > >english_us.8859 (check you System Adminstarors Guide). > >On the client side make sure that the following I-Net parameters are > >set : DbNls to 2 and CollChar to 1. To set these, run Setnet, chose > >the [more] button, then you can adjust these parameters. > >Koen > > I'm not using I-net but the Openlink ODBC-driver. I'm sure the server > side is setup correctly, because with DBACCESS all works fine. Only > when I'm trying the use the NLS database from MS-Access or MS-Query > via the ODBC driver I get the error message. > BTW retrieving data from a non NLS database works just fine. > > Edmar. > > >On 25 Jul 1996 12:28:17 -0400, edmar@svb.nl ("Edmar Schut") wrote: > >I am experimenting a little with MS-Access 7, Openlink ODBC and On-line 7.13. > >When I create a database with NLS enabled and I want to access this > >database via the ODBC-driver with user informix I get an error message > >saying the LANG or LC_COLLATE var probably wasn't set correctly. > >When I access the same database with dbaccess all works fine, but > >then of course I defined the vars in my .profile. > >How do I set these vars from the ODBC-driver. Am I missing something > >here? > >THA, > ############################################################################ ##### > Edmar Schut > Studie-en Vakbibliotheek voor blinden, slechtzienden en andersz. gehandicapten > Dutch Library for Visually and Print Handicapped Students and professionals > Molenpad 2 > 1016 GM Amsterdam, The Netherlands > Phone: +31-20-6266465 Fax: +31-20-6208459 > E-mail: eschut@svb.nl > ############################################################################ ##### >