TCP client / server application

Encerrado Postado Mar 1, 2003 Pago na entrega
Encerrado Pago na entrega

We are wanting a TCP client / server. The server will act as a middle tire between the backend SQL Server and a File Server. The Indy components that come with Delphi should be used. Requirements From the client you need to be able to show a custom open and save dialog which get a list of virtual folders and documents from the TCP/IP server which will find the information from the SQL server. The client needs to cache the data locally and when requesting data from the server it should pass a MD5 hash of the file so the server can check for changes to save bandwidth. The server should support the following commands and be able to be easily extended in the future. GETDATASET (SQLQuery), [MD5HASH] It will run the statement and return the dataset delimited with pipes if the hash is different. If the hash is the same the client will return the local file if no hash was past or the file is different it will send the file as a stream and save it locally. GETSTATICDATASET (VIEWNAME), [MD5HASH] This will look up a table which will contain an sql statement. It will run the statement and return the dataset delimited with pipes if the hash is different. If the hash is the same the client will return the local file if no hash was past or the file is different it will send the file as a stream and save it locally. UpDateSQL (SQLString) Runs the sql statement against the MS SQL Server and returns OK or the error message. GETFile (FileID) Looks up the location of the file in the database and copies the file locally. SAVEFILE ServerPathAndFileName (FileStream) Copies the file from the local PC to the File Server LOGIN user, [passwordhash] Checks the user is allowed access The server should be implemented as an NT service. We also required an admin type monitor to see who is connected. We will provide the MD5 hash unit if needed and a copy of the SQL Server database.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. 4) Well commented code (in english)

## Platform

Server: Windows NT, 2000 Client: Windows 9x, NT, 2000, XP Delphi

Delphi Engenharia MySQL PHP Arquitetura de software Teste de Software SQL

ID do Projeto: #2912072

Sobre o projeto

4 propostas Projeto remoto Ativo em Jul 8, 2003

4 freelancers estão ofertando em média $340 nesse trabalho

miguelkhouri

See private message.

$340 USD in 14 dias
(75 Comentários)
7.4
florinsabau

See private message.

$127.5 USD in 14 dias
(26 Comentários)
4.6
osivw

See private message.

$212.5 USD in 14 dias
(3 Comentários)
2.2
dsavy

See private message.

$680 USD in 14 dias
(0 Comentários)
0.0