How to create App.server

[fule12]

Hi all,

I would like to create a 3 tiered application (Client, Application Server & DB Server - SQL 2000 ), so how to connect App.server with MS SQL Server and App.Server with Application.
For Interbase connection I use :
-- Server --
Add Module ,add component
- IBDatabase
- IBTransaction
and for each form in Client app I create
- Query
- Data
- Provider

For Application again I create Module and in module i insert

- Dcom connection
- Client Data Set
- Data Source

So how i can create something like this but connected to MS SQL 2000 server ?

Thanks

Fule

 

[fruNNik]

Its not a real answer but, I have used the ADO components to connect to MSSql server.

The setup is sort of the same you mentioned with a
TADoConnection and TDatasource, which can be tables, queries
or stored procs, and viewing components like TDBGrid etc.

I dont know which Delphi version include the ADO stuff,
if i remmeber correctly think its an add on for Delphi5...

hth
- fruNNik