ODP.NET

I find that Managed ODP.Net cannot work with windows path containning non-ascii characters. When I was trying to connect to oracle database using Oracle.ManagedDataAccess.dll from a location with non-ascii characters in its path, I got a System.IndexOutOfRangeException. Via RedGate .Net Reflector, I caught the source error line.

The error source:

OracleInternal.Network.AddressResolution.VetCIDValue(string CIDValue) //The value of CIDValue is @"E:\\Documents\\2014\\GpsMidware\\svn代码

                                                                                                          //\\map_gps\\WcfService\\bin\\Debug\\GpsMidwareService.vshost.exe"

        {

            StringBuilder builder;

            try

            {

                builder = new StringBuilder(CIDValue);

                for (int i = 0; i < builder.Length; i++)

                {

                    if (ValidChars[builder[i]] == 0) //This is where the exception is thrown. The length of the array ValidChars is only 256,

                                                               //and the value of builder[i] is its unicode value, so if the path contains any non-ascii

                                                               //character, then the index will be out of range!!!

                    {

                        builder[i] = '?';

                    }

                }

            }

            catch (Exception)

            {

                return "";

            }

            return builder.ToString();

        }

The production version of Oracle.ManagedDataAccess.dll is 4.121.1.0, the file version is 4.121.1.20131211, coming from

ODAC 12c Release 2 and Oracle Developer Tools for Visual Studio (12.1.0.1.2) http://www.oracle.com/technetwork/cn/topics/dotnet/utilsoft-086879.html

----------------------------------------------------------------------------------------------------

The call stack: