🚀 go-pugleaf

Hi Heinz,

First, install the Oracle client and use the Oracle 10g OLEDB 
provider.  The MS Oracle OLEDB driver was effectively obsolete as 
of Oracle 6.5 or 7.

I don't know if your list below reflects the order you're doing 
things or not.  If it does, then you should hook the query object 
to the connection (6) before setting the SQL statement.

By "(BCB Crash)" do you mean the IDE crashes or the application 
crashes when it is run?  What version of BCB?

- Arnie

"Heinz Ketchup" 
<heinz_like_the_ketchup@no_spam.h0tmail.no_spam.c0m> wrote in 
message news:4512e7bc$1@newsgroups.borland.com...
>
> To whom ever may help... Thank you v. much!
>
> Setup:
> 1. TADOConnection with MS OLE DB Provider for Oracle
> 2. USER ID / PASSWORD Setup Correctly
> 3. Test Connection to Oracle DB Successful
> 4. TDataSource with TDataSet Bound to TADOQuery
> 5. TADOQuery with SQL statement
>   (SELECT * FROM tableowner.tablename)
> 6. TADOQuery with connection to "1. Above... TADOConnection"
> 7. TADOQuery change "Active" property from false to true...
>   (BCB Crash)
>
> I'm using the madshi collection, which is a freeware tool that
> catches exceptions. It's call stack shows the crash:
>
> main thread ($15c):
> 4064d157 +0b7 adortl60.bpl    Adodb 
> TCustomADODataSet.OpenCursor
> 4032bd41 +055 dbrtl60.bpl     Db             TDataSet.SetActive
> 4002386e +036 rtl60.bpl       TypInfo        SetOrdProp
> 007ddde3 +03f designide60.bpl Designeditors 
> TPropertyEditor.SetOrdValue
> 007de806 +062 designide60.bpl Designeditors 
> TEnumProperty.SetValue
> 007dd948 +0cc designide60.bpl Designeditors 
> TPropertyEditor.Edit
> 00610a32 +096 coreide60.bpl   PropInsp 
> TPropertyInspector.PropListEditDblClick
> 00344c35 +015 vclide60.bpl    Ideinsplistbox 
> TInspListBox.EditDblClick
> 401079a1 +015 vcl60.bpl       Controls       TControl.DblClick
> 40107b04 +034 vcl60.bpl       Controls 
> TControl.WMLButtonDblClk
> 401077ec +188 vcl60.bpl       Controls       TControl.WndProc
> 4010a9a3 +157 vcl60.bpl       Controls 
> TWinControl.WndProc
> 00342cab +037 vclide60.bpl    Ideinsplistbox 
> TPropInspEdit.WndProc
> 4010a620 +02c vcl60.bpl       Controls 
> TWinControl.MainWndProc
> 40039478 +014 rtl60.bpl       Classes        StdWndProc
> 77d496c2 +00a user32.dll                     DispatchMessageA
> 400f582f +083 vcl60.bpl       Forms 
> TApplication.ProcessMessage
> 400f5866 +00a vcl60.bpl       Forms 
> TApplication.HandleMessage
> 400f5a86 +096 vcl60.bpl       Forms          TApplication.Run
>
> If you could tell me how to fix it, that'd be super kind of 
> you.
> Or
> Give me a different direction to setup up an Oracle Connection
> and Query
>
> All feedback is extremely well appreciated.
>
> Thank You,
> Heinz
>
> PS:
> I have the latest update 4.0 to the Borland C++ Builder 6.0.
> Compiler