Re: middleware for mysql

Bob D. wrote:
Hello,

I have a server application that connects to a mysql server and a client software that connects to server and exchange data using TCP/IP.

what I want is to directly execute mysql queries like

SELECT * FROM ....

from client. Means:


CLIENT -> connects -> SERVER -> connects -> MYSQL
instead of
CLIENT -> connects -> MYSQL

I'm using CrLab MyDac components.

Does anyone done something similar? Or any idea how can I create such thing?

Thanks!


I own 4 component sets that would do what you want...

Asta: I wouldn't recommend this anymore. It's kind of the grandfather of middleware in the Delphi space. They've branched off into a bunch of other technologies and, imo, the core Asta middleware product hasn't kept up with the competition (understatement). www.astatech.com.

RTC (Real Thin Client): Author is very active in the forums and developing the RTC components. Good remoting capabilities and now offers support for a data access tier through a third party (which I haven't tried). Very good component set... but not my first choice for what you want to do. www.realthinclient.com.

kbmMW: You should get a lot of good feedback from users recommending this one. It's another very good product with active support. Focuses on middleware data servers. It's good enough (and has a stellar reputation) that I've kept my license current since the very first beta. Still not my first choice... but you wouldn't go wrong selecting it. Very flexible pricing to fit a variety of needs (including, I believe, no-cost licenses). Extensive database and platform support (definitely one of it's strong points), including .net. www.components4developers.com.

RemObjects: Far and away my favorite tools for n-tiered development in Delphi. Excellent object model that works exactly how I think. I think this is the most Delphi-like implementation available. This is another one that I've been with since before the first release. It's an outstanding product that's not only very accessible for beginners, but offers superb enterprise-level functionality as well. I use it all the time with MySQL and MyDAC (native support for MyDAC). The downside is it's pricier than the others. In my case, it's worth it. Imo, hands down, the best Delphi middle-tier implementation. Extensive database support and excellent .net support. www.remobjects.com.


Hope this helps,

Matt Harward
.

Relevant Pages

  • NFS problems with through 2.5.x to 2.6.0-test9
    ... When the server is running the ... kernel, as a client the 2.6 series seem to work perfectly, excluding ... Interesting problem arose when I attempted switch the server's kernel to ... with and without nfsv4 support compiled in (was considering testing it at ...
    (Linux-Kernel)
  • Re: middleware for mysql
    ... I have a server application that connects to a mysql server and a client ... It's another very good product with active support. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: FileCopy vs. Read & Write or CopyFile API
    ... client is copying the file in 5 or 10 seconds is to big. ... Dim errNum as Integer ... synchronize a document in server to its client with VB FileCopy function. ... Microsoft Online Community Support ...
    (microsoft.public.vb.general.discussion)
  • Re: FileCopy vs. Read & Write or CopyFile API
    ... client is copying the file in 5 or 10 seconds is to big. ... Dim errNum as Integer ... synchronize a document in server to its client with VB FileCopy function. ... Microsoft Online Community Support ...
    (microsoft.public.vb.general.discussion)
  • RE: HP officejet 5610
    ... As far as I know none support ... Microsoft MVP - Terminal Server ... Virtual Client Solutions ... printers, assuming the client is Vista SP1 or XP SP3 with RDP Client 6.1. ...
    (microsoft.public.windows.terminal_services)