for my culture

[damianodec]

Hi,
what kind of database used for your FWH application (DBF,SQL, ADS...) ?
how many users are connected to the database (about) ?
thank to all

[damianodec]

Nobody helps me?

[Rick Lipkin]

damianodec

There is no good answer to your question .. Things to consider for the type of database to use depends on your audience and their infrastructure.

My personal opinion is this :

1) .dbf\cdx is great for local applications to be run on a single computer or shared on a network for a small group of people. If your audience grows to multiple locations over a wide area network Advantage Database server would be the next logical step.

My personal favorite is to use ADO to be able to manipulate Sql Client\Server databases such as Ms Access, MS Sql Server, Oracle, etc. Generally you code once and only change the 'connection string' for the different RDMS. As a bonus Microsoft gives you the ADO connectivity client for Ms Access and MS Sql Server on every Desktop from WinXP thru Windows 8... Oracle, dB2 and MySql will need clients to be loaded on each desktop running your application. I chose to use Ms Access and Ms Sql Server.

Here is a good write up on how ADO works with FiveWin :
http://wiki.fivetechsoft.com/doku.php?i ... uffs&s=ado

Rick Lipkin

[Rimantas]

My personal favorite is to use ADO to be able to manipulate Sql Client\Server databases such as Ms Access, MS Sql Server, Oracle, etc. Generally you code once and only change the 'connection string' for the different RDMS. As a bonus Microsoft gives you the ADO connectivity client for Ms Access and MS Sql Server on every Desktop from WinXP thru Windows 8... Oracle, dB2 and MySql will need clients to be loaded on each desktop running your application. I chose to use Ms Access and Ms Sql Server.

Rick Lipkin

Not so true , Rick ... . Simply MySql , with which I'm working , only needs connection string . Native lib works perfect and with a good speed in Harbour + Fwh app. Also I'm using the same MySql database from Internet ( JavaScript + PhP app ) . So need only did all work in client server ( install Wamp and install mine Harbour + Fwh app ) and all enterprise local network clients can work with mine program . Also through Internet too . Nothing requires for clients PC . Only create desktop link from server to Harbour app or save Internet address as Favorite in browser ...

[Rick Lipkin]

Rimantas

Thank you for your correction ..

Rick

[damianodec]

Thanks,
So, do you think that FWH & mysql is a very good choice?

[Rick Lipkin]

damianodec

There is nothing wrong with MySql+Fwh .. many successful friends here use MySql and Daniel Garcia-Gil's TDolphan Library

http://tdolphin.blogspot.com/

Rick Lipkin

[ADutheil]

I followed the MySQL path an never looked back. TDolphin helps a lot.

[Daniel Garcia-Gil]

Hello

if you plan is use more than one database engine (postgres, oracle, mysql server, etc), the best way is ADO, the big difference between ADO and Mysql API (used by TDolphin) with Mysql API you dont need install any ODBC client, not need create DSN, only need a dll and link a library

[MarcoBoschi]

LAN
DBFCDX
twenty users
an average of 50,000 records modified every day
about a hundred touched tables every day in about 900 tables
bye

[damianodec]

ciao Marco,
in una LAN con tre sedi distaccate pensi sia una buona scelta?
grazie per l'eventuale risposta.