Re: NLS database and MS Access

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