Re 2: Memory Issues with DBI proxy on Windows

Thanks for replying.

I have looked into SQL-relay before, but it doesn't quite solve our problem. One of the reasons that we are using DBI proxy is to get away from FreeTDS. DBI proxy allows the use of ODBC to connect to SQL server, which seems to work better. I know it is possible to do ODBC from Linux, but from the research I have done it looks like it would be rather involved to setup and I haven't found a free ODBC driver for Linux. That's why I was hoping that there was a known fix to DBI proxy.

Thanks for your suggestion.

Comment on Re 2: Memory Issues with DBI proxy on Windows

Replies are listed 'Best First'.
Re: Re 2: Memory Issues with DBI proxy on Windows by fmerges (Chaplain) on Jul 15, 2005 at 01:06 UTC
Hi again, If it's really a problem from DBD::proxy and not a thing of your code (something missed...) you could try it from another perspective... program your own proxy. Could be a interesting approach, using POE should not be very complicated, and you can make it using POE::Component::Server::XMLRPC and POE::Component::SimpleDBI That way your clients communicate to your home-made proxy through XMLRPC and you have some methods on the server which wrap around the querys to the DB connected component... back and forth, and, back and forth... But should be more simply approach too. Regards, \|fire\| at irc.freenode.net I like merlyn's disclaimer	[reply]

Replies are listed 'Best First'.

Re: Re 2: Memory Issues with DBI proxy on Windows
by fmerges (Chaplain) on Jul 15, 2005 at 01:06 UTC

Hi again,

If it's really a problem from DBD::proxy and not a thing of your code (something missed...) you could try it from another perspective... program your own proxy.

Could be a interesting approach, using POE should not be very complicated, and you can make it using POE::Component::Server::XMLRPC and POE::Component::SimpleDBI

That way your clients communicate to your home-made proxy through XMLRPC and you have some methods on the server which wrap around the querys to the DB connected component... back and forth, and, back and forth...

But should be more simply approach too.

Regards,

|fire| at irc.freenode.net

I like merlyn's disclaimer

[reply]