Hi,
I'm looking for a product that permits to me modify a program written by me from the
typical file/server to client/server architecture.
I'm looking for a low cost solution.
Client pc are connected to server through several vpn.
Any advice?
Best regards
marco
I'm looking for a low cost solution.
Anser,
please show me some links to read informations
Many thanks
marco
Marco:
The solutions are
ADS, tDolphing (MySql, de Daniel), Eagle1 (MySql,de Manu), and Apollo.
Nobody speak about Apollo and I don't know why.
http://www.vistasoftware.com/apollo_server.asp
Sorry for my bad English
Regards
Ruben Fernandez
Hi Marco
You can actually do client server with [x}Harbour code alone. It doesn't give you all the features you may get with an SQL based product but it is very fast and easy to understand.
I did exactly that when faced with the exact same situation that you seem to be facing. I used IP sockets as my transport layer and arrays serialized using HB_Serialize() and HB_Deserialize() to wrap up query details and returned data and error codes.
Some other nice features of this approach are:
you can use existing tables unaltered
if your code is OO you can directly update object properties
it is a cross platform solution ( clients and servers can be run on any OS that supports [x}Harbour and its TIP library.
This isn't the solution for everyone but if you are interested I can provide you with some working code. When I wrote this I took the opportunity to restructure how my queries worked (so that they are now basically parameterized objects) but that isn't necessary.
If you have a relatively large number of clients you may need to implement threads - I may do that at some point inn the future - currently I effectively have a series of servers (on the one physical PC) listening on different ports and different clients use different ports (read form a local config file). It arguably isn't the prettiest way but it is very effective and reliable.
Regards
Doug
PS I originally coded this in xHarbour but then switched to Harbour but it will work in either.
xProgrammer wrote:Hi Marco
You can actually do client server with [x}Harbour code alone. It doesn't give you all the features you may get with an SQL based product but it is very fast and easy to understand.
I did exactly that when faced with the exact same situation that you seem to be facing. I used IP sockets as my transport layer and arrays serialized using HB_Serialize() and HB_Deserialize() to wrap up query details and returned data and error codes.
Some other nice features of this approach are:
you can use existing tables unaltered
if your code is OO you can directly update object properties
it is a cross platform solution ( clients and servers can be run on any OS that supports [x}Harbour and its TIP library.
This isn't the solution for everyone but if you are interested I can provide you with some working code. When I wrote this I took the opportunity to restructure how my queries worked (so that they are now basically parameterized objects) but that isn't necessary.
If you have a relatively large number of clients you may need to implement threads - I may do that at some point inn the future - currently I effectively have a series of servers (on the one physical PC) listening on different ports and different clients use different ports (read form a local config file). It arguably isn't the prettiest way but it is very effective and reliable.
Regards
Doug
PS I originally coded this in xHarbour but then switched to Harbour but it will work in either.
Thanks guys
Hi Randal, Marco
Bear with me for a day or two and I'll post my solution. It's late at night and I have to get Mum out of hospital and settled back home tomorrow after her fall.
Regards
Doug
My best wishes for a fast recovery to your Mum.
EMG
Enrico Maria Giordano wrote:My best wishes for a fast recovery to your Mum.
EMG
>Marco:
>Nobody speak about Apollo and I don't know why.
>Ruben Fernandez
Do you think is the right product for a Fivewin/xHarbour programmer?
Where can I find some pieces of code to better understand the problem?
Hi Enrico, Massimo
Thanks for your kind thoughts. Mum is now home and so far coping quite well. Will post code tomorrow time permitting. It probably needs some explanation with it. Like so many projects it grew out of a simple "proof of concept" but as the project has dvelkoped the simple beginning is probably hard to see.
Regards
Doug
I think Apollo should be a good option as it currently sells for $ 149.00, one-stop shopping for multiple implementations. ADS is much more expensive and only for a specific client.
currently only has an RDD xHarbour developed, but I think only for the local version and not client / server, harbour began to develop the RDD but does not go far
sorry traslate with google
salu2
carlos vargas
Marco:
I don't know if it's the right choice, but it's cheaper than other and I think it's esasy.
There's no code and. I dont't know If FWH could go well together.
Very Sorry for my bad English.
Best regards
Ruben Fernandez
