Cannot load OCI DLL

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
morphocr
Posts: 3
Joined: Thu 03 Sep 2009 18:44
Location: Costa Rica

Cannot load OCI DLL

Post by morphocr » Fri 01 Aug 2014 22:02

Hello Devart Team,

got the follow pc setup :


-Windows 8 64 bits
-Oracle Client 11g for windows 64 bits
-Embarcadero® RAD Studio XE6 Version 20.0.15596.9843
and application with target platforms 64-bit with ODAC 9.3.10 Professional Edition

If I try direct connect it works without problem but if i try to use the ora drivers i got the follow :
Cannot load OCI DLL

[0F8F8C0C]{odac200.bpl } Oracall.TOracleHome.LoadOCI + $DC
[0F8F9075]{odac200.bpl } Oracall.TOracleHome.Init + $3C5
[500BF66F]{rtl200.bpl } System.Variants.@VarToUStr (Line 3125, "System.Variants.pas" + 85) + $38
[0F79BFC0]{dac200.bpl } Craccess.TCRConnection.SetProp + $F8
[0F79C09A]{dac200.bpl } Craccess.TCRConnection.SetProp + $1D2
[500B9DA1]{rtl200.bpl } System.Variants.@VarClear (Line 880, "System.Variants.pas" + 3) + $4
[50063231]{rtl200.bpl } System.@VarClr (Line 31252, "System.pas" + 1) + $0
[500632E1]{rtl200.bpl } System.@FinalizeArray (Line 31439, "System.pas" + 90) + $0
[0F94BE77]{odac200.bpl } Oraclasses.TOCIConnection.SetProp + $7AF
[500B9D03]{rtl200.bpl } System.Variants.VarClearDeep (Line 828, "System.Variants.pas" + 2) + $6
[500B9D08]{rtl200.bpl } System.Variants.VarClearDeep (Line 829, "System.Variants.pas" + 3) + $2
[500B9D99]{rtl200.bpl } System.Variants.@VarClear (Line 878, "System.Variants.pas" + 1) + $2
[500B9DA1]{rtl200.bpl } System.Variants.@VarClear (Line 880, "System.Variants.pas" + 3) + $4
[50063231]{rtl200.bpl } System.@VarClr (Line 31252, "System.pas" + 1) + $0
[500632E1]{rtl200.bpl } System.@FinalizeArray (Line 31439, "System.pas" + 90) + $0
[0F98D9E1]{odac200.bpl } Ora.TOraSession.GetOCIConnection + $7C1
[500BF66F]{rtl200.bpl } System.Variants.@VarToUStr (Line 3125, "System.Variants.pas" + 85) + $38
[500D1167]{rtl200.bpl } System.SyncObjs.TCriticalSection.Release (Line 1023, "System.SyncObjs.pas" + 1) + $6
[500D1192]{rtl200.bpl } System.SyncObjs.TCriticalSection.Enter (Line 1034, "System.SyncObjs.pas" + 1) + $2
[0F8FA838]{odac200.bpl } Oracall.TOracleHomes.Init + $2A4
[500604A8]{rtl200.bpl } System.@TryFinallyExit (Line 21792, "System.pas" + 8) + $0
[0F8FA5D2]{odac200.bpl } Oracall.TOracleHomes.Init + $3E
[0F8FA855]{odac200.bpl } Oracall.TOracleHomes.Init + $2C1
[0F8F97A4]{odac200.bpl } Oracall.TOracleHomes.GetDefault + $C
[0F8F8AB8]{odac200.bpl } Oracall.TOracleHome.CreateEnvironment + $14
[0F8F92C8]{odac200.bpl } Oracall.TOracleHome.AllocEnvironment + $6C
[0F947B0D]{odac200.bpl } Oraclasses.TOCIConnection.Connect + $99
[0F79BCD7]{dac200.bpl } Craccess.TCRConnection.SetServer + $B
[0F766AEE]{dac200.bpl } Dbaccess.TCustomDAConnection.DoConnect + $DE
[0F98DC21]{odac200.bpl } Ora.TOraSession.DoConnect + $F1
[0F766E77]{dac200.bpl } Dbaccess.TCustomDAConnection.PerformConnect + $37
[0F87179F]{dcldac200.bpl} Daconnectioneditor.TDAConnectionEditorForm.PerformConnect + $B
[0F87155F]{dcldac200.bpl} Daconnectioneditor.TDAConnectionEditorForm.btConnectClick + $3F
[504F314B]{vcl200.bpl } Vcl.Controls.TControl.Click (Line 7348, "Vcl.Controls.pas" + 9) + $8
[50517D0A]{vcl200.bpl } Vcl.StdCtrls.TCustomButton.Click (Line 5320, "Vcl.StdCtrls.pas" + 3) + $2
[50518810]{vcl200.bpl } Vcl.StdCtrls.TCustomButton.CNCommand (Line 5781, "Vcl.StdCtrls.pas" + 1) + $D
[504F2BF5]{vcl200.bpl } Vcl.Controls.TControl.WndProc (Line 7232, "Vcl.Controls.pas" + 91) + $6
[504F7739]{vcl200.bpl } Vcl.Controls.TWinControl.WndProc (Line 10047, "Vcl.Controls.pas" + 153) + $6
[505179B4]{vcl200.bpl } Vcl.StdCtrls.TButtonControl.WndProc (Line 5157, "Vcl.StdCtrls.pas" + 13) + $4
[504F2830]{vcl200.bpl } Vcl.Controls.TControl.Perform (Line 7010, "Vcl.Controls.pas" + 10) + $8
[504F789F]{vcl200.bpl } Vcl.Controls.DoControlMsg (Line 10116, "Vcl.Controls.pas" + 12) + $11
[504F8327]{vcl200.bpl } Vcl.Controls.TWinControl.WMCommand (Line 10391, "Vcl.Controls.pas" + 1) + $5
[504F2BF5]{vcl200.bpl } Vcl.Controls.TControl.WndProc (Line 7232, "Vcl.Controls.pas" + 91) + $6
[504F784A]{vcl200.bpl } Vcl.Controls.TWinControl.DefaultHandler (Line 10088, "Vcl.Controls.pas" + 30) + $19
[504F2BF5]{vcl200.bpl } Vcl.Controls.TControl.WndProc (Line 7232, "Vcl.Controls.pas" + 91) + $6
[504F7739]{vcl200.bpl } Vcl.Controls.TWinControl.WndProc (Line 10047, "Vcl.Controls.pas" + 153) + $6
[011B2002]{designide200.bpl} DeskUtil.SetFocusHook (Line 463, "DeskUtil.pas" + 4) + $C
[504F6D80]{vcl200.bpl } Vcl.Controls.TWinControl.MainWndProc (Line 9759, "Vcl.Controls.pas" + 3) + $6
[50177B88]{rtl200.bpl } System.Classes.StdWndProc (Line 17064, "System.Classes.pas" + 6) + $1
[504F7739]{vcl200.bpl } Vcl.Controls.TWinControl.WndProc (Line 10047, "Vcl.Controls.pas" + 153) + $6
[504F2830]{vcl200.bpl } Vcl.Controls.TControl.Perform (Line 7010, "Vcl.Controls.pas" + 10) + $8
[504F784A]{vcl200.bpl } Vcl.Controls.TWinControl.DefaultHandler (Line 10088, "Vcl.Controls.pas" + 30) + $19
[504F35A0]{vcl200.bpl } Vcl.Controls.TControl.WMLButtonUp (Line 7481, "Vcl.Controls.pas" + 1) + $6
[504F2BF5]{vcl200.bpl } Vcl.Controls.TControl.WndProc (Line 7232, "Vcl.Controls.pas" + 91) + $6
[504F6F6F]{vcl200.bpl } Vcl.Controls.TWinControl.IsControlMouseMsg (Line 9815, "Vcl.Controls.pas" + 1) + $9
[504F7739]{vcl200.bpl } Vcl.Controls.TWinControl.WndProc (Line 10047, "Vcl.Controls.pas" + 153) + $6
[505179B4]{vcl200.bpl } Vcl.StdCtrls.TButtonControl.WndProc (Line 5157, "Vcl.StdCtrls.pas" + 13) + $4
[504F6D80]{vcl200.bpl } Vcl.Controls.TWinControl.MainWndProc (Line 9759, "Vcl.Controls.pas" + 3) + $6
[50177B88]{rtl200.bpl } System.Classes.StdWndProc (Line 17064, "System.Classes.pas" + 6) + $1
[506430DF]{vcl200.bpl } Vcl.Forms.TApplication.ProcessMessage (Line 10351, "Vcl.Forms.pas" + 23) + $1
[50643122]{vcl200.bpl } Vcl.Forms.TApplication.HandleMessage (Line 10381, "Vcl.Forms.pas" + 1) + $4
[5063E5A6]{vcl200.bpl } Vcl.Forms.TCustomForm.ShowModal (Line 7147, "Vcl.Forms.pas" + 33) + $5
[0F870F0A]{dcldac200.bpl} Daconnectioneditor.TDAConnectionEditorForm.SetComponent + $E
[0F85E83C]{dcldac200.bpl} Crdesign.TCRComponentEditor.ShowEditorEx + $8C
[0F85E78A]{dcldac200.bpl} Crdesign.TCRComponentEditor.ShowEditor + $32
[0F85EB53]{dcldac200.bpl} Crdesign.TCRComponentEditor.Edit + $B
[011FFB55]{designide200.bpl} ComponentDesigner.TInternalItem.Edit (Line 7555, "ComponentDesigner.pas" + 1) + $F
[011C2794]{designide200.bpl} Designer.TDesigner.Edit (Line 1011, "Designer.pas" + 0) + $4
[011C4A6F]{designide200.bpl} Designer.TDesigner.MouseDown (Line 1712, "Designer.pas" + 50) + $6
[51FBB4E5]{vcldesigner200.bpl} VCLSurface.TComponentToolWindow.WndProc (Line 1600, "VCLSurface.pas" + 16) + $32
[51FBBF87]{vcldesigner200.bpl} VCLSurface.TContainer.WndProc (Line 1900, "VCLSurface.pas" + 39) + $6
[51FBB307]{vcldesigner200.bpl} VCLSurface.TDesignerToolWindow.MainWndProc (Line 1535, "VCLSurface.pas" + 2) + $7
[50177B88]{rtl200.bpl } System.Classes.StdWndProc (Line 17064, "System.Classes.pas" + 6) + $1
[51FBB307]{vcldesigner200.bpl} VCLSurface.TDesignerToolWindow.MainWndProc (Line 1535, "VCLSurface.pas" + 2) + $7
[50177B88]{rtl200.bpl } System.Classes.StdWndProc (Line 17064, "System.Classes.pas" + 6) + $1
[506430DF]{vcl200.bpl } Vcl.Forms.TApplication.ProcessMessage (Line 10351, "Vcl.Forms.pas" + 23) + $1
[50643122]{vcl200.bpl } Vcl.Forms.TApplication.HandleMessage (Line 10381, "Vcl.Forms.pas" + 1) + $4
[50643455]{vcl200.bpl } Vcl.Forms.TApplication.Run (Line 10519, "Vcl.Forms.pas" + 26) + $3

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Cannot load OCI DLL

Post by AlexP » Mon 04 Aug 2014 06:57

Hello,

Delphi is a 32-bit application, therefore, when running a project from Delphi, you can use only 32-bit libraries; if you run your application from an *.Exe file, ODAC will correctly load the 64-bit oci.dll. If you are going to connect to Oracle in design-time from Delphi, you should also install a 32-bit Oracle client.

morphocr
Posts: 3
Joined: Thu 03 Sep 2009 18:44
Location: Costa Rica

Re: Cannot load OCI DLL

Post by morphocr » Mon 04 Aug 2014 21:03

Thanks, it work fine !

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Cannot load OCI DLL

Post by AlexP » Tue 05 Aug 2014 08:12

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

Post Reply