🚀 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 

Thank you Arnie,

All Excellent Suggestions! I do have the Oracle client, but 
don't seem to have the provider? The company uses 
tnsnames.ora, which would explain why the connections can be, 
I'm probably using the wrong terminology... referenced by
alias / name of the database.

And yes, below is the sequence of what is happening.
And yes, I do mean BCB completely crashes into a BCB error,
then dies.

I was using BCB C++ 6.0 with update 4.0

I found a product that seems to work...
ODAC (I think it stands for Oracle Database Access Component)
It's a 3rd party VCL, but the demo version seems to be able to
do the job. We'll probably purchase it...

I've tried the net version, and I can connect via TCP/IP.
So I can get away from using the install of the Oracle Client
on a user PC.

Thank you for your help!
Gave some great ideas I looked into.

Have a nice day,
Heinz


"Arnie" <none> wrote:
>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 
>
>