On Mon, 17 Feb 2003 09:56:02 -0800, Tim Howell wrote: >I'm having a problem with dbiproxy on Win2K. I'm connecting to the >proxy server from perl 5.8 on a linux box in order to access a MS SQL >database on the Win2K box. Everything works fine for one request. >After a single query has been executed dbiproxy will no longer accept >requests until it is restarted. > >I haven't seen any info on this from a google search. I've tried a >couple of different versions of Storable, etc. > >Any ideas?
We had some fun connecting to SQL Server from linux via DBD::Proxy a while back... Initially, we had problems with the PlRPC package; under Win32 "\n" gets written as 0x0a,0x0d to the socket. Fixing this to write a single 0x0a instead resolved this. We also carried out modifications to Net::Daemon. Specifically, using ithreads and "pre-forking" a number of child threads (producing a kind of hybrid threads/fork setup on the DBD::ProxyServer side). (Note: This change replaced the pre-forking code.) Connecting to SQL Server from Linux was then possible for us via DBD::ADO was the possible from Linux, and running multiple queries on the database was possible. However, stability was a major issue; it was *far* too unstable for production use. There were a couple of anomolies we found with DBD::ADO, but those related to DBD::ADO, and not DBD::Proxy. For connecting to SQL Server using DBI, there are a fair number of other alternatives to DBD::Proxy. These mainly consist of ODBC drivers and commercially available ODBC bridging solutions. Unfortunatly, *all* of which had various issues that made them unsuitable for our use... A copy of the changes we made are available on request. The test setup we were using at the time: Win2k: ActiveState Perl v5.8.0 build 804 DBI-1.30.zip Net::Daemon 0.37 PlRPC 0.2016 Linux: Perl v5.6.0 DBD 1.30 Net::Daemon 0.35 PlRPC 0.2016
