[SOLVED] Can database auto-connected in fcl-web applications?

[egsuh]

I put an TIBConnection, TSQLTransaction, and TSQLQuery and wrote a simple CGI application just returning the content of a table. This runs well, even though I myself do not set TIBConnection.Connected := True. This this possible?

In HTTPServer it does not.

[lucamar]

It should be possible if you set IBDatabase.Connected and SQLTransaction.Active to True at design-time, though that is not generally recommended: if the database doesn't exist at run-time, having those set will make the up barf up a couple of exceptions when launched, which is not really a nice thing, specially for a CGI

[Sieben]

If you Open a TSQLQuery it's TXYZConnection will be implicitly set Connected, and a TSQLTransaction wired to it will be set Active as well.

[egsuh]

if you set IBDatabase.Connected and SQLTransaction.Active to True at design-time,

No. If I did set connected and active true, then it's natural. But both were false.

If you Open a TSQLQuery it's TXYZConnection will be implicitly set Connected, and a TSQLTransaction wired to it will be set Active as well.

I see. That's why it acted in that way. Interesting thing is setting transaction wired to an unconnected database raises exception.