🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #374

ADO Connection / Query to Oracle 10g crashes BCB

#374
From: Heinz Ketchup
Date: Thu, 21 Sep 2006 19:27
51 lines
3063 bytes
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
Technical Details
Message-ID: <4512e7bc$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,cbfa410b8e87c6b0,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Heinz Ketchup" <heinz_like_the_ketchup@no_spam.h0tmail.no_spam.c0m>
Sender: "Heinz Ketchup" <heinz_like_the_ketchup@no_spam.h0tmail.no_spam.c0m>
Reply-To: "Heinz Ketchup" <heinz_like_the_ketchup@no_spam.h0tmail.no_spam.c0m>
Subject: ADO Connection / Query to Oracle 10g crashes BCB
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 146.131.120.2     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4512e7bc$1@newsgroups.borland.com>
Date: 21 Sep 2006 12:27:56 -0700
X-Trace: newsgroups.borland.com 1158866876 207.105.83.66 (21 Sep 2006 12:27:56 -0700)
Lines: 51
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news3.google.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail