BorlandTalk.com

Alan Olson · Guest

i'm attempting to hook up a borland data provider to an oracle database.
i'm running into what appears to be some basic problems. let me outline.

1) new empty ASP.NET project with Delphi 8.0 (latest update patch)
2) From the data explore, i drag/drop an oracle table onto the form/designer
3) This adds a bdpConnection component and a bpdDataAdapter component
properly configured.

at this point, i can run the project and i get a blank page in IE w/ no
errors. this is fine.

4) I use the dataAdapter's 'Configure Data Adapter..' wizard thing to fill
in teh SQL text and to add in a dataset.
5) From teh dataset, i verify that the table name and columns are properly
added, once i set the Active to try in teh adapter.

At this point, i run again, and i get an 'Oracle Provider initialization
failed' page in the browser (IE).

Here is the text. Any help would be appreciated.

Alan

----------------------------------------------------------------------

Server Error in '/productionweb' Application.
----------------------------------------------------------------------------
----

Oracle provider initialization failed.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: Borland.Data.Common.BdpException: Oracle provider
initialization failed.

Source Error:

Line 276: Self.bdpUpdateCommand1.UpdatedRowSource :=
System.Data.UpdateRowSource.None;
Line 277: Include(Self.Load, Self.Page_Load);
Line 278:
(System.ComponentModel.ISupportInitialize(Self.BdpDataAdapter1)).EndInit;
Line 279:
(System.ComponentModel.ISupportInitialize(Self.OracleNYTDataset)).EndInit;
Line 280:
(System.ComponentModel.ISupportInitialize(Self.MainNYTTable)).EndInit;

Source File: C:Inetpubwwwrootmiller.netproduction.netWebForm1.pas
Line: 278

Stack Trace:

[BdpException: Oracle provider initialization failed.]
Borland.Data.Provider.BdpDataAdapter.e() +656
Borland.Data.Provider.BdpDataAdapter.EndInit() +60
WebForm1.TWebForm1.InitializeComponent() in
C:Inetpubwwwrootmiller.netproduction.netWebForm1.pas:278
WebForm1.TWebForm1.OnInit(EventArgs e) in
C:Inetpubwwwrootmiller.netproduction.netWebForm1.pas:294
System.Web.UI.Control.InitRecursive(Control namingContainer) +240
System.Web.UI.Page.ProcessRequestMain() +174

----------------------------------------------------------------------------
----
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET
Version:1.1.4322.573