| View previous topic :: View next topic |
| Author |
Message |
Tony M
Guest
|
 Posted: Sat May 12, 2007 1:44 pm Post subject: D2007 Oracle 9i dbGo connection problem |
 |
|
Thought I would try my hand at connecting to an Oracle db at work. using
dbGo.
Dropped a TADO table onto a form and set the connection string using build.
hit the 'Test Connect' and receive *succeeded*.
Try to open a table using the TADOTable and get the message:
"Data provider or Other Service returned an 'E_Fail' status."
Detail descrition is:
[207BF300]{adortl100.bpl} ADODB.TCustomADODataSet.InternalGetRecord + $104
[2000A455]{rtl100.bpl } System.@CheckAutoResult + $11
[207BF300]{adortl100.bpl} ADODB.TCustomADODataSet.InternalGetRecord + $104
[207BF608]{adortl100.bpl} ADODB.TCustomADODataSet.GetRecord + $124
[204412B4]{dbrtl100.bpl} DB.TDataSet.GetNextRecord + $78
[20441A57]{dbrtl100.bpl} DB.TDataSet.MoveBy + $B3
[20441B32]{dbrtl100.bpl} DB.TDataSet.MoveBy + $18E
[20441B68]{dbrtl100.bpl} DB.TDataSet.Next + $1C
[207B88D7]{adortl100.bpl} ADODB.TADOConnection.GetTableNames + $F7
[225E44DB]{dclado100.bpl} ADOReg.TCommandTextProperty.GetValueList + $47
[22619176]{dcldb100.bpl} DBReg.TDBWideStringProperty.GetValues + $42
[20E90590]{vclide100.bpl} IDEInspListBox.TInspListBox.ListDropDown + $98
[20E8BC80]{vclide100.bpl} IDEListBtns.TListButton.DropDown + $30
[20E8B6F2]{vclide100.bpl} IDEListBtns.TListButton.DefaultHandler + $82
[20E8B786]{vclide100.bpl} IDEListBtns.TListButton.WMLButtonDown + $32
[20006A3F]{rtl100.bpl } System.TObject.Dispatch + $13
[2013F6A7]{vcl100.bpl } Controls.TControl.WndProc + $2BB
[201431E8]{vcl100.bpl } Controls.TWinControl.IsControlMouseMsg + $60
[20143736]{vcl100.bpl } Controls.TWinControl.WndProc + $4FA
[0E7A66DD]{cxLibraryD11.bpl} Cxcontainer.TcxCustomInnerListBox.CNDrawItem +
$695
[20142E60]{vcl100.bpl } Controls.TWinControl.MainWndProc + $2C
[20040DE4]{rtl100.bpl } Classes.StdWndProc + $14
[2013A7BA]{vcl100.bpl } Controls.FindControl + $42
[20160EF0]{vcl100.bpl } Forms.TApplication.ProcessMessage + $F4
[20160F32]{vcl100.bpl } Forms.TApplication.HandleMessage + $A
[20161188]{vcl100.bpl } Forms.TApplication.Run + $CC
[00422971]{bds.exe } bds.bds (Line 196, "" + 7) + $2
This is the first time I've tried dbGo technology so am a little lost
(although tried last night at home using Jet on a local Access table without
problems).
Any suggestions? |
|
| Back to top |
|
 |
mhb
Guest
|
| Posted: Sun May 13, 2007 7:24 pm Post subject: Re: D2007 Oracle 9i dbGo connection problem |
|
|
use 'Oracle Provider for OLE DB' not 'Microsoft OLE DB Provider for
Oracle'. |
|
| Back to top |
|
|
Tony M
Guest
|
| Posted: Mon May 14, 2007 8:10 am Post subject: Re: D2007 Oracle 9i dbGo connection problem |
|
|
Thanks for the tip MHB.
Found that entering a table name directly in the table name edit box in the
TADOTable works however it would have been nice to get a list of tables ala
the 'standard' ttable components.
"mhb" <mhb_shrf (AT) hotmail (DOT) com> wrote in message
news:46471f96$1 (AT) newsgroups (DOT) borland.com...
| Quote: |
Any suggestions?
use 'Oracle Provider for OLE DB' not 'Microsoft OLE DB Provider for
Oracle'.
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
