Article ID 2475
Article Title WebApp date display and/or decimal separator is using wrong Regional Settings
Article URL http://www.dataaccess.com/kbasepublic/KBPrint.asp?ArticleID=2475
KBase Category Web Apps
Date Created 07/09/2015
Last Edit Date 07/09/2015


Article Text
ISSUE:
Our web application works as intended when running from the Studio/Debugger, but when invoked in a browser via the direct URL, the date display and decimal and thousands separator seem to be configured for different Regional settings.


SOLUTION:
Keep in mind that when you run a web application in the Studio Debugger, it uses the Windows Regional Settings that the current Windows user (probably your development user id) is using. When running directly as a web application, the service is most likely logging into Windows using another user id (the local system account by default), which may have different Windows Regional settings configured.

Go to Control Panel > Administrative Tools > Services and find DataFlex {version} Web Application Server. Right-click and select Properties. On the Log On tab, see what user account the service is running. By default, this will be the Local System account.

If you want the ability to specify Windows Regional settings (as well as database access rights, etc.) for a DataFlex web application, you should create another Windows user account specifically for the web application(s).

After creating the new Windows user account, and log into Windows using that account to configure it's Regional settings (from the Control Panel). Then, go to Control Panel > Administrative Tools > Services and find DataFlex {version} Web Application Server. Right-click and select Properties. on the Log On tab, change the account running this service to the new account (from the system account).

Now restart the service and log out of Windows. Log back into Windows the way you normally would and  test again as you did before.




Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2021 Data Access Corporation. All rights reserved.

The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.