Application Server source ?

[Steven Pringels 3]

Hi,

Did anyone of you ever write some kind of application server to connect
using TCP/IP to *any* database system (preferrable using ADO).
The server should be multithreaded of course...

It should only do INSERT, UPDATE, DELETE, SELECT in transaction mode
(meaning failed DML could be rolled-back). Plus give table information about
the columns.

If so... any observations or idea's on how to proceed. I reckon that i could
use the rserver from Don Dickinson as a starting point.

Cheers
Steven

[Paul Franks]

There's a very basic tcp/ip server for SQLite here:

http://www.powerbasic.com/support/pbforums/showthread.php?t=29808

It's query only, but the framework is very simple (I borrowed it from someone else on the forums).

ADO is very easy to use via the COM interface. There are several examples on the formus.

[Joe Byrne]

Steven,

I've written a couple of applications that run over the Internet. All of them use the Tsunami database and Don's TTDS (Tsunami (something) Data Server).

Its the best option I've found short of setting up a dedicated SQL server or programming the client apps in HTML/CGI code.

Rumor has it that a new version of Tsunami is on the horizon but no real hard core news has surfaced on the subject