we are using dotConnect Universal with Oracle.
Lets assume this: Two Oracle clients installed on a machine "A" and "B".
"A" is the first in the Path
Aplication should use "B" so we add "Oracle_Home = B" to the connection string.
This works perfecly fine, its taking the OCI.dll from the "B" client.
But we have the impression that ist not taking the NLS_Lang setting from the "B" client, but uses the "A" client for that.
Could you please confirm that you not only using the OCI.dll but also all the settings from this special Oracle:home and not taking any defaults from the first client in the path ?
In one of the posts you suggested below:
You can use the "Run Once Command" connection string parameter to set the necessary NLS_LANG value. For example, add the following string to your connection string:
Code: Select all
"Run Once Command=ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';"
Do you have an example on the usage of this. We are using below lines of code to connect to oracle using UniConnection.
using (UniConnection testConnection = new UniConnection(connectionString))
{
try
{
testConnection.Open();
testConnection.Close();
}
}