Dear!
If using direct mode is it possible to set NLS Settings at connection level or string. If not, please give us link how to check and set database NLS settings... We are using Oracle 10g and connection via direct mode. Everything works, except sorting is wrong.
Best regards, Gregor
NLS SETTINGS
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
You can change NLS settings at several different levels:
- for the whole system, you can change regional settings in the 'Control Panel' -> 'Regional and Language Options' window;
- for the application, you can specify NLS settings via the static OracleGlobalization.SetApplicationInfo method;
- for the current session only, you can use the OracleConnection.SetSessionInfo method.
Please tell us if this helps.
- for the whole system, you can change regional settings in the 'Control Panel' -> 'Regional and Language Options' window;
- for the application, you can specify NLS settings via the static OracleGlobalization.SetApplicationInfo method;
- for the current session only, you can use the OracleConnection.SetSessionInfo method.
Please tell us if this helps.
NLS LANGUAGE
Hi!
If we have web asp.net application in which point to set OracleGlobalization.SetApplicationInfo?
Best regards, Gregor
If we have web asp.net application in which point to set OracleGlobalization.SetApplicationInfo?
Best regards, Gregor
-
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
You can set the application info, e.g., in the Application_Start method of the Global application class:
http://msdn.microsoft.com/en-us/library/2027ewzw.aspx
Feel free to contact us if you have any additional questions.
http://msdn.microsoft.com/en-us/library/2027ewzw.aspx
Feel free to contact us if you have any additional questions.
NLS SETTINGS
Dear!
Of course, I didn't thought of this, since I do not set a lot of things in application level....))
Thank you, that's it )
Best regards, Gregor
Of course, I didn't thought of this, since I do not set a lot of things in application level....))
Thank you, that's it )
Best regards, Gregor