Firebird Access WIth Delphi .net

SeaCay · Post by **SeaCay** » Tue 03 Jun 2008 02:28

Hello All,

I have create a Firebird database for use with Delphi Win32 applications. Now the customer wants to make parts of the database accessible to .net clients. What Core Lab tools do I need for this using Delphi .net? Are there any demos/examples of similar projects?

regards and thanks

SeaCay

Plash · Post by **Plash** » Tue 03 Jun 2008 06:56

If you are are developing VCL Forms Application with Delphi .Net, you can use IBDAC. IBDAC supports Delphi .Net, and IBDAC has demos for .Net.

SeaCay · Post by **SeaCay** » Tue 03 Jun 2008 07:13

Thanks for your reply.

I was hoping to develop asp.net applications with Delphi .net and Firebird

regards

SeaCay

Plash · Post by **Plash** » Tue 03 Jun 2008 12:35

IBDAC has special adapter component to use with ADO.NET (You will use ADO.NET to connect to the database from ASP.NET application.).

You can find the demo in \Demos\dotNet\Miscellaneous\AspNet.

SeaCay · Post by **SeaCay** » Tue 03 Jun 2008 22:55

Thanks - I will take a look very shortly.
regards

SeaCay · Post by **SeaCay** » Tue 03 Jun 2008 23:30

Hi,

Just to let you know, the project \Demos\dotNet\Miscellaneous\AspNet\Web.bdsproj fails to compile in Delphi .net 2007. The problem seems to stem from the line

Code: Select all

procedure IBCConnectionConnectionLost(Sender: TObject; Component: TComponent;
      ConnLostCause: TConnLostCause; var RetryMode: TRetryMode);

where TConnLostCause is undefined. The compiler returns:

[DCC Error] WebForm.pas(123): E2003 Undeclared identifier: 'TConnLostCause'

TConnLostCause seems to be referenced in many hpp files but I don't know which assembly it is defined in.

regards

SeaCay · Post by **SeaCay** » Tue 03 Jun 2008 23:42

TConnLostCause is defined in MemData.

Adding this module fixes the problem.

Also
In the Project source Web.dpr (dproj) change the line

Code: Select all

WebForm1 in 'WebForm.pas' {WebForm.TWebForm: System.Web.UI.Page};

to read

Code: Select all

WebForm in 'WebForm.pas' {WebForm.TWebForm: System.Web.UI.Page};

(drop the 1 in WebForm1)

The project will now compile.

regards

SeaCay

SeaCay · Post by **SeaCay** » Wed 04 Jun 2008 01:13

The demo works fine.

A nice example - thanks

regards

SeaCay

Plash · Post by **Plash** » Wed 04 Jun 2008 11:33

We'll fix these errors in the demo in the next IBDAC build.