i had install my oracle client 64 bit at location C:\Oracle\ora64
Code: Select all
foreach (OracleHome home in OracleConnection.Homes)
{
string printf = string.Format("Name={0} ClientVersion={1} Path={2}", home.Name, home.ClientVersion, home.Path);
}
Name=ORA64 ClientVersion=11.2.0.1 Path=C:\Oracle\ora64
Could any1 please advise what else should i check ?
my PATH enviroment Variable :
C:\Oracle\ora64;C:\Oracle\ora64\bin;C:\ProgramData\Oracle\Java\javapath;C:\Oracle\product\11.2.0\client_1;C:\Oracle\product\11.2.0\client_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\;C:\Program Files (x86)\Microsoft ASP.NET\ASP.NET Web Pages\v1.0\;C:\Program Files\Microsoft SQL Server\110\Tools\Binn\;c:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\Tools\Binn\;c:\Program Files\Microsoft SQL Server\100\DTS\Binn\;C:\Tools\nant\bin;C:\Program Files\Python27;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft DNX\Dnvm\;C:\Oracle\ora32;C:\Oracle\ora32\bin;C:\Program Files\nodejs\;%systemroot%\System32\WindowsPowerShell\v1.0\;C:\Program Files\TortoiseSVN\bin;C:\Program Files (x86)\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\;%systemroot%\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\dotnet\;C:\Program Files\dotnet\
this is the error message
Devart.Data.Oracle.OracleException
HResult=0x80004005
Message=Cannot load Oracle client. Check your PATH environment variable and registry settings.
Source=Devart.Data.Oracle
StackTrace:
at ..ctor(Boolean , Boolean , OracleHome )
at .(Boolean , Boolean , OracleHome , Boolean , Boolean )
at ..ctor( , )
at . ( , Object , DbConnectionBase )
at .( , , DbConnectionBase )
at .(DbConnectionBase )
at .(DbConnectionBase )
at .(DbConnectionBase )
at . (DbConnectionBase )
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at .(DbConnection , OracleServerType& , Nullable`1& )
at .(DbConnection )
at . (RelationalOptionsExtension )
at System.Lazy`1.ViaFactory(LazyThreadSafetyMode mode)
at System.Lazy`1.ExecutionAndPublication(LazyHelper executionAndPublication, Boolean useDefaultConstructor)
at System.Lazy`1.CreateValue()
at ..ctor(RelationalTypeMapperDependencies , )
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitConstructor(ConstructorCallSite constructorCallSite, ServiceProviderEngineScope scope)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteVisitor`2.VisitCallSite(IServiceCallSite callSite, TArgument argument)
at Microsoft.Extensions.DependencyInjection.ServiceLookup.CallSiteRuntimeResolver.VisitScoped(ScopedCallSite scopedCallSite, ServiceProviderEngineScope scope)