Delphi 2010 x64 development and ODAC

kurtbilde · Post by **kurtbilde** » Fri 23 Apr 2010 20:07

Hi,

I use the 11.2.0.1 64-bit Oracle Client on a Windows 7 64-bit os with Delphi 2010 all Service packs installed.

When using ODAC I get several OCI.DLL errors... Do I have to install the 32-bit driver in order to be able to use ODAC for development?

If yes, do ODAC deal with the 32-bit client not being the standard one (64-bit will be...)

-Kurt

kurtbilde · Post by **kurtbilde** » Sat 24 Apr 2010 08:59

It doesn't help to change HomeName in TOraSession....

So kinda stuck with the designtime errors.... Here is the details:

[0AFBE01E]{odac140.bpl } Oracall.VersionStrToWord + $B3A
[0AFBE4E7]{odac140.bpl } Oracall.DetectOCI + $463
[0AFBEB67]{odac140.bpl } Oracall.LoadOCI + $17
[0AFC2600]{odac140.bpl } Oracall.InitOCI + $34
[0AFFC517]{odac140.bpl } Oraclasses.OCIInit + $3
[0AFFF30B]{odac140.bpl } Oraclasses.TOCIConnection.Connect + $133
[502C5D78]{vcl140.bpl } Forms.TScreen.SetCursor (Line 7987, "Forms.pas" + 18) + $B
[50009F92]{rtl140.bpl } System.@IsClass (Line 9738, "System.pas" + 1) + $8
[0AD2F99F]{dac140.bpl } Craccess.TCRConnection.SetServer + $B
[0AD0BE11]{dac140.bpl } Dbaccess.TCustomDAConnection.DoConnect + $C1
[0B042696]{odac140.bpl } Ora.TOraSession.DoConnect + $136
[0AD0C127]{dac140.bpl } Dbaccess.TCustomDAConnection.PerformConnect + $37
[0AD0E1E6]{dac140.bpl } Dbaccess.TCustomDAConnection.SetConnected + $2A2
[0B043BB0]{odac140.bpl } Ora.TOraSession.SetConnected + $44
[0AD0C0E4]{dac140.bpl } Dbaccess.TCustomDAConnection.Connect + $4
[0AD0C007]{dac140.bpl } Dbaccess.TCustomDAConnection.InternalConnect + $6B
[0AD2213F]{dac140.bpl } Dbaccess.TDAMetaData.BeginConnection + $63
[0AD223A2]{dac140.bpl } Dbaccess.TDAMetaData.OpenCursor + $52
[50690C79]{dbrtl140.bpl} DB.TDataSet.SetActive (Line 11310, "DB.pas" + 12) + $7
[50690AC0]{dbrtl140.bpl} DB.TDataSet.Open (Line 11266, "DB.pas" + 0) + $4
[0AD0C91B]{dac140.bpl } Dbaccess.TCustomDAConnection.GetTableNames + $67
[0AC82E01]{dcldac140.bpl} Dadesign.TDATableNameEditor.GetValues + $B1
[20EC4B8F]{vclide140.bpl} IDEInspListBox.TInspListBox.ListDropDown (Line 1276, "IDEInspListBox.pas" + 9) + $12
[20EBAC6C]{vclide140.bpl} IDEListBtns.TListButton.DropDown (Line 674, "IDEListBtns.pas" + 5) + $A
[20EBA6DA]{vclide140.bpl} IDEListBtns.TListButton.DefaultHandler (Line 494, "IDEListBtns.pas" + 13) + $4
[20EBA76E]{vclide140.bpl} IDEListBtns.TListButton.WMLButtonDown (Line 527, "IDEListBtns.pas" + 7) + $2
[50076408]{rtl140.bpl } Classes.StdWndProc (Line 13015, "Classes.pas" +

+ $0
[5000A187]{rtl140.bpl } System.TObject.Dispatch (Line 10010, "System.pas" +

+ $0
[50295E70]{vcl140.bpl } Controls.TControl.WndProc (Line 7062, "Controls.pas" + 91) + $6
[5029A738]{vcl140.bpl } Controls.TWinControl.WndProc (Line 9819, "Controls.pas" + 144) + $6
[20D8C74E]{designide140.bpl} DeskUtil.SetFocusHook (Line 454, "DeskUtil.pas" + 4) + $C
[501D2A86]{vcl140.bpl } Graphics.FreeMemoryContexts (Line 6935, "Graphics.pas" + 12) + $F
[50299DD8]{vcl140.bpl } Controls.TWinControl.MainWndProc (Line 9540, "Controls.pas" + 3) + $6
[50299DED]{vcl140.bpl } Controls.TWinControl.MainWndProc (Line 9543, "Controls.pas" + 6) + $0
[50076408]{rtl140.bpl } Classes.StdWndProc (Line 13015, "Classes.pas" +

+ $0
[5029A018]{vcl140.bpl } Controls.TWinControl.IsControlMouseMsg (Line 9604, "Controls.pas" + 9) + $25
[5029A738]{vcl140.bpl } Controls.TWinControl.WndProc (Line 9819, "Controls.pas" + 144) + $6
[50299DD8]{vcl140.bpl } Controls.TWinControl.MainWndProc (Line 9540, "Controls.pas" + 3) + $6
[50076408]{rtl140.bpl } Classes.StdWndProc (Line 13015, "Classes.pas" +

+ $0
[5029098A]{vcl140.bpl } Controls.FindControl (Line 3377, "Controls.pas" + 6) + $9
[502C8775]{vcl140.bpl } Forms.TApplication.ProcessMessage (Line 9760, "Forms.pas" + 30) + $1
[502C87BA]{vcl140.bpl } Forms.TApplication.HandleMessage (Line 9790, "Forms.pas" + 1) + $4
[502C8AE5]{vcl140.bpl } Forms.TApplication.Run (Line 9927, "Forms.pas" + 26) + $3
[004369AE]{bds.exe } bds.bds (Line 200, "" +

+ $FFFB

-Kurt

bork · Post by **bork** » Tue 27 Apr 2010 07:09

Hello

Delphi can generate 32-bit applications only and 32-bit applications can use only x32 DLL's. If you want to use Oracle client by 32-bit applications then you should install 32-bit Oracle client.

kurtbilde · Post by **kurtbilde** » Tue 27 Apr 2010 14:51

As posted to the support I have both the 32 bit oracle 11.2 driver and the 64 bit 11.2 driver on my system - both "homes" reports the OCI.dll error!!!

THIS IS A TOTAL SHOWSTOPPER!!!

bork · Post by **bork** » Wed 28 Apr 2010 13:29

I sent answer by E-mail.