Remote Access System for customers of a bank

Business Challenges

Old remote access system based on FoxPro for MS DOS did not satisfy needs of customer support. The new project aimed to modern bank service, easy technical support and used progressive technologies providing multi-customers online access through TCP-IP sockets.

System Functionality

In the new system a server side application was developed as a Windows NT service and became a 3-d tier component of central bank database based on Oracle 8.i running on Linux OS. The client side SW was designed as a standalone Win32 application and implements an original technology, which strongly simplifies user’s access to nested tables of a high hierarchical relational database.

Used languages & Technologies

The Client-Server system development process involved WinSock and Cryptography API's as well as multithreading technique. XML data format used to reach a data interchange between the server and client sides. And ADO technology also actively used to access the central database at the server side. Output reports at the client side formed by MS Office (Word and/or Excel) OLE objects as a result of client’s application query by running embedded MS VB code.