ADS or similar products

[MarcoBoschi]

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

[anserkk]

I'm looking for a low cost solution.

How about MySQL as your database ?

Regards
Anser

[MarcoBoschi]

Anser,
please show me some links to read informations
Many thanks
marco

[Ruben Fernandez]

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

[Armando]

Marco:

Just my five cents, ADO as another one option.

http://sqlcmd.blogspot.com/

Regards

[xProgrammer]

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.

[Randal]

Doug:

I'd like to see some working code if you don't mind.

Thanks,
Randal

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.

[MarcoBoschi]

Thanks guys

[xProgrammer]

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

[Enrico Maria Giordano]

My best wishes for a fast recovery to your Mum.

EMG

[Massimo Linossi]

My best wishes for a fast recovery to your Mum.

EMG

Me too

[MarcoBoschi]

>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?

[xProgrammer]

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

[carlos vargas]

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

[Ruben Fernandez]

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