RE Re: NLS database and MS Access

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 #################################################################################