Board index » cppbuilder » ADO Connection / Query to Oracle 10g crashes BCB

ADO Connection / Query to Oracle 10g crashes BCB


2006-09-22 03:27:56 AM
cppbuilder42
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
 
 

Re:ADO Connection / Query to Oracle 10g crashes BCB

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"
< XXXX@XXXXX.COM >wrote in
message news:4512e7bc$ XXXX@XXXXX.COM ...
Quote

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
 

Re:ADO Connection / Query to Oracle 10g crashes BCB

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:
Quote
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"
< XXXX@XXXXX.COM >wrote in
message news:4512e7bc$ XXXX@XXXXX.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


 

{smallsort}