I previously submitted the question at the end of this message, seeking how
to make the RPC:PLServer multi-threaded. I received a very helpful response
indicating the need to add a "--childs n" parameter to the call to
DBI::ProxyServer::main such as:
DBI::ProxyServer::main("--localport=118", "--childs=10");
The problem has been that whenever adding the "--childs" parameter, my
ProxyServer returns an error to the client attempting to send a SQL query to
the database. When I remove this new parameter (and only have the
"--localport" parameter, everything works fine again (except that the server
runs single-threaded). In seeking to pursue this suggestion, I've come up
empty on finding any documentation that speaks of the "--childs" parameter.
Has anyone else run into this difficulty, or have a different suggestion on
how to implement a multi-threaded ProxyServer? Are there possibly different
versions of DBI::ProxyServer, with only some having the "--childs"
parameter? In your answer, please keep in mind that I am quite new to Perl
and especially usage of the DBI module. :-)
Below was my original Question to the Forum:
I've installed the DBD::Proxy and RPC::PLServer modules on Windows 2000
accessing SQL Server 2000 (through an ODBC System DSN). I can interface to
the database from one or more Linux boxes just fine, with the exception that
the server is single threaded (i.e., when submitting a query from one script
on the same or different clients, connection to the server does not occur
until the connection from a different script is closed). How can I make the
DBI proxy server
multi-threaded such that many client connections may be open to my SQL
Server database simultaneously?
Thanks,
David
