Search found 4 matches

by Niels Wijnja
Tue 31 Aug 2010 08:56
Forum: dotConnect for Oracle
Topic: Can not load Oracle client. Check your PATH environment vari
Replies: 24
Views: 88557

Started this as a normal user.
Path returns:

Code: Select all

C:\oracle\10.2.0\client\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\IBM\Director\bin;C:\Program Files\Common Files\IBM\ICC\cimom\bin;C:\Program Files\Windows Imaging\;C:\Program Files\Citrix\System32\Citrix\IMA;C:\Program Files\Citrix\System32\Citrix\IMA\Subsystems;C:\WINDOWS\System32\Citrix\IMA;C:\Program Files\Citrix\system32;C:\Program Files\Common Files\Citrix\System32\;C:\Program Files\Common Files\Citrix\System32;C:\Program Files\Microsoft Application Virtualization Client;C:\Program Files\QuickTime\QTSystem\;C:\Program Files\Unit4\Unit 4 Multivers\bin\
Regkey returns:

Code: Select all

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
I also have full control for all users on the ORACLE key, so we might want to exclude that.
by Niels Wijnja
Thu 26 Aug 2010 15:15
Forum: dotConnect for Oracle
Topic: Can not load Oracle client. Check your PATH environment vari
Replies: 24
Views: 88557

Shalex wrote:1. Please specify the exact error message.
2. Does your normal user have access to the PATH variable and to the registry?
1. See http://www.devart.com/forums/viewtopic.php?t=18830
detailed information available in that post.

2. Normal user has been given full control to the Oracle key in HKLM\Software; could you clarify your question about the path variable?
Ofcrouse the user can read the contents of the path variable, otherwise a lot of applications would've stopped working. It's a system variable so the normal user can't change it but definitely read it.
by Niels Wijnja
Thu 26 Aug 2010 09:39
Forum: dotConnect for Oracle
Topic: Can not load Oracle client. Check your PATH environment vari
Replies: 24
Views: 88557

Had this same problem (well, not while developing but while running an application as a standard user).
Turns out.. simply putting the contents of the ORACLE_HOME registry value in an environment variable called ORACLE_HOME (almost obvious ;)) did the trick.
Very weird as the standard user does have access to the full oracle registry key under HKLM, seems like a nice bug to me.

edit: wow, 1 reboot later it stopped working.. great.
by Niels Wijnja
Wed 25 Aug 2010 11:24
Forum: dotConnect for Oracle
Topic: Can not load oracle client without local admin rights
Replies: 1
Views: 5618

Can not load oracle client without local admin rights

Application is running on a Windows 2003 terminal server, with local admin rights the application starts; without local admin rights i get the following error:

Code: Select all

Exception type: InvalidOperationException
Exception message: Can not load Oracle client. Check your PATH environment variable and registry settings.
InnerException: 
Exception occurred in: Devart.Data.Oracle
Exception thrown by: Void .ctor(Boolean, Boolean, Devart.Data.Oracle.OracleHome)
Stack trace:
   at Devart.Data.Oracle.ak..ctor(Boolean A_0, Boolean A_1, OracleHome A_2)
   at Devart.Data.Oracle.ak.a(Boolean A_0, Boolean A_1, OracleHome A_2)
   at Devart.Data.Oracle.OracleInternalConnection..ctor(y connectionOptions, OracleInternalConnection proxyConnection)
   at Devart.Data.Oracle.bx.a(h A_0, Object A_1, DbConnectionBase A_2)
   at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, h A_1)
   at Devart.Common.DbConnectionPoolGroup.c(DbConnectionPool A_0)
   at Devart.Common.DbConnectionPool.a()
   at Devart.Common.DbConnectionPool.GetObject()
   at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
   at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
   at Devart.Common.DbConnectionBase.Open()
   at Devart.Data.Oracle.OracleConnection.Open()
   at Vicrea.ApplicationBlocks.Data.CoreLab.CLSerializerBase.get_Connection()
   at Vicrea.GVR.Core.Data.CheckDatabase.CheckSchema.CheckConnection()
   at Vicrea.GVR.Core.Data.CheckDatabase.CheckModule(EnumModuleType module)
   at Vicrea.GVR.UI.Forms.StartForm.InitApplication()
   at Vicrea.GVR.UI.Forms.StartForm..ctor()
   at Vicrea.GVR.UI.Program.Main(String[] args)

Additional data: System.Collections.ListDictionaryInternal

Exception trad op:     woensdag 25 augustus 2010 13:18:53
Gebruikte GVR versie:  6.1.135.28592
The path environment variable is exactly the same for a local admin and a normal user.

The application allows to specifiy part of the connection string, used the following 2; neither of them work for a user without admin rights; both work for a local administrator:

Code: Select all

Password=****;User ID=***;Data Source=****

Code: Select all

Password=****;User ID=***;Data Source=****;HOME=CLIENT10g
Gave the normal user full control on the oracle client folder (recursively), didn't solve anything.
Other applications with an oracle backend work fine for a normal user; except this one that uses some of your components.


Does anyone have a clue what might be causing this problem?
Thanks in advance.