Article View: borland.public.cppbuilder.database.ado
Article #374ADO Connection / Query to Oracle 10g crashes BCB
From: Heinz Ketchup
Date: Thu, 21 Sep 2006 19:27
Date: Thu, 21 Sep 2006 19:27
51 lines
3063 bytes
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-mailShow 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