Request SQL statement and other data functions remotely

• Project ID:

  778883

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Background
a) We have a database with multiple tables in one location.
We would like to access (Read and Write ) from other programs (Delphi) to that files over the internet.


Plan
a) Have a service running on the server side that would take a requests from clients
send as a XML Packet or other method and return results as a XML.

b) One of the ways a request could be send is a simple SQL commend (select, update, sum etc ) and a record set returned.

c) some more complex requests could be send like “card number”, “Card date “ , Funcution(Check_Balance) and Check_balance would be a rule on the server side knowing how to get this data or to what files on the server it has to update

d) We should be able to write the functions / Rules in a DLL in Delphi (the server should recognize if the DLL is updated with out a need to restart the server)

e) Part of handling the request should be to validate user name and password right of the client (Username and passwords)

f) Option to send request and answer encrypted

g) all requests should be logged on server

h) server should be multi threading

The database we are using is advantage database server form Sybase (local and server)

Skills required:

Delphi, Software Architecture, SQL, XML