BorlandTalk.com

DaveH · Guest

I just tried to convert a simple BDE ISAPI app to IB Objects.

Replaced the Session, Database and Query component with the equivalent IB
component. Made sure that the Session was declared first. Connected to the
database and ran a simple query while in design mode. Everything worked Ok.

When I run it, the Database connects but when I open the Query, I get an
error saying that the Username and Password are not set in Interbase.

I simple connected the Query to the Database through the IB_Connection
property at design time and added new SQL lines at run time.

MyQuery.Close;
MyQuery.Sql.Clear;
MyQuery.Sql.Add('select * from Users');
MyQuery.Open;

Shouldn't it use the Database connection? It has the Username and password
and is already connected by the time the Query runs (I do that in the
OnCreate method). Has anyone else experienced this? Has anyone worked with
IBO under ISAPI?

Thanks for any insight.
DaveH

Shiv Kumar · Guest

Dave,

There is a demo in the IBO stuff for an ISAPI (I wrote is a while back). The
ISAPI that drives my web site uses IBO as well. So I know IBO works in an
ISAPI :)

What is the DatabaseName (I forget the name of the property) property of
your IB_Connection component?

You need to use a value such as this

machineName:C:PathToDatabaseDatabase.gdb

It is important that you use this style (machineName:) when using InterBase
with an ISAPI.
--
Shiv R. Kumar
The Delphi Apostle
http://www.matlus.com

DaveH · Guest

Do you remember the name of the demo? I went through the list of demos and
nothing jumped out at me as an ISAPI example.

I found the problem however. I was using the Username and Password
properties of the IB_Connection. When you fill these in, it adds the
entries to the Params property - or so I thought. It turns out that the
Username goes in there but the password does not. Editing the Params
property myself and adding the password entry fixed the problem.

I had forgotten about the DatabaseName rule. Thanks for the reminder.

DaveH

"Shiv Kumar" <shivk (AT) erols (DOT) com> wrote

Shiv Kumar · Guest

Dave,

I don't remember the name of the demo. It was a long time ago. At the same
time, it was a really simply demo :)

--
Shiv R. Kumar
The Delphi Apostle
http://www.matlus.com