D2010: UseUnicode option must be set to True ...
Posted: Tue 26 Oct 2010 17:57
We're using the latest version of D2010 and DbxOda v.4.50.21.
Because of an issue with have with consistency between the DbxSda & DbxOda drivers, we need to turn Unicode off. I've set the driver options in the Ini file to UseUnicode=False and UnicodeEnvironment=False.
The first time you make a connection, it works fine. If you set SqlConnection1.Connected = false, then back to true, it raises the error 'UseUnicode option must be set to True for Unicode OCI environment'.
I saw the Extended Driver Options in the Readme.html file, from how I interpret the info there, because we're using D2010 I don't have to do the SQLConnection.SetOption in the AfterOpen, it's ok to just set Params.Value[UnicodeEnvironment'] := 'False';
Do I have this correct? If so, why would it connect fine the first time, but a subsequent disconnect and connect causes the error to occur?
Any help or insight you might have would be greatly appreciated,
- Rich Werning
Because of an issue with have with consistency between the DbxSda & DbxOda drivers, we need to turn Unicode off. I've set the driver options in the Ini file to UseUnicode=False and UnicodeEnvironment=False.
The first time you make a connection, it works fine. If you set SqlConnection1.Connected = false, then back to true, it raises the error 'UseUnicode option must be set to True for Unicode OCI environment'.
I saw the Extended Driver Options in the Readme.html file, from how I interpret the info there, because we're using D2010 I don't have to do the SQLConnection.SetOption in the AfterOpen, it's ok to just set Params.Value[UnicodeEnvironment'] := 'False';
Do I have this correct? If so, why would it connect fine the first time, but a subsequent disconnect and connect causes the error to occur?
Any help or insight you might have would be greatly appreciated,
- Rich Werning