Apache DSO (in Kylix) won't connect using dbExpress

Hi, I found this tutorial very useful:

http://bdn.borland.com/article/images/28556/apache_development.pdf

regards,
Kate

Thanks.  So did I.  But, unfortunately, no answer.

Have you (or anyone) gotten a DSO to access a Firebird db using dbExpress?

Yeah, I for sure I did..but I got it at work
(configuration of apache) so I have to get
there first :)

But basically I had no problem:

1) installing apache
2) installing firebird
3) adding firebird functionality into httpd.conf
4) running both
5) compiling Web Service under the Kylix
6) adding it as LoadModule into httpd.conf
7) restarting apache

regards,
Kate

Hi,

I think you misunderstood.  The DSO works fine without the dbExpress components.  It's just when I execute the SQLConnection1.Open statement that it doesn't.  The error is something like "connection lost" from Konqueror.

The program also works fine as a standalone GUI exe.  I haven't tried it yet as a CGI.

I think that Apache can't find one of the "support" SO's, like /usr/lib/libgds.so or /home/phil/kylix3/bin/libsqlib.so and libmidas.so.  Although it's strange that the code fails when the Open statement is executed, not when the module is loaded.

http.conf contains:
LoadModule aftest_module       /home/phil/Projects/aftest/bin/libaftest.so
<Location /aftest>
  SetHandler aftest-handler
</Location>
SetEnv LD_LIBRARY_PATH /home/phil/kylix3/bin
SetEnv LANG en_US

but it does not contain anything referencing /usr/lib.  Should it?

Regards,
Phil

I have "remade" the app as a CGI app.

The call to SQLConnection1.Open is in a try..except block.

I am receiving the exception:
Access violation at address 080B275C, accessing address 000000A4

Hmmmm.

The CGI app now works.  The DSO still does not with "Connection to host <host> is broken."  On top, it says "An error occurred while loading" although the error actually happens when the page containing the SQLConnection.Open statement is executed.

Re the CGI app: I had built both the CGI & DSO versions from a previous standalone GUI version.  In doing so, I moved the dbExpress calls to a new unit but neglected to add "DBXpress, FMTBcd, SqlExpr" to the main "uses" clause.  Adding them (to both) makes the CGI version work.  The DSO still does not work.
 

Wow, this is wierd....

I "misspoke" myself earlier.  The CGI app did not work.  Somebody must have spiked my coffee. :-)

So, I set about to make the CGI app work.  What was the difference between my app and the demo app from http://bdn.borland.com/article/images/28556/apache_development.pdf which works?  

The (condensed) code from the demo is:
procedure TWebModule1.WebModule1WebActionItem2Action(Sender: TObject;
  Request: TWebRequest; Response: TWebResponse; var Handled: Boolean);
begin
  SQLConnection1.Open;
  SQLQuery1.SQL.Text := 'select emp_no, first_name, last_name from employee '+
                        'where first_name like '+'"'+Request.ContentFields.Values['empname']+'"';
  SQLQuery1.Open;
  DataSetTableProducer1.DataSet := SQLQuery1;
  Response.Content := DataSetTableProducer1.Content;
  SQLQuery1.Close;
  SQLConnection1.Close;
end;

All of the dbExpress statements were within the WebModule Action OnAction event.  Mine were called by the OnAction event but lived in a totally different unit.  So I moved some of the dbExpress code to new paragraphs within the the Web Module itself.  Same problem.  So I moved the SQLConnection1.Open statement within the OnAction event itself.  It connected!  So I moved a sample query into the OnAction event itself.  It worked!

Right now I'm of the opinion that all of the dbExpress statements must live in the WebModule Action OnAction event.  This makes for some very, very bad code.

Does any of this make any sense?  

Regards,
Phil

I contend that it is "not possible" in an Apache CGI or DSO written in Kylix.

Can anyone show me where I'm wrong?

Regards,
Phil