pcsoft.us.windevCopyright 2026, PC SOFT2 Feb 2016 03:36:00 Z29 Jan 2016 13:10:00 ZGreeting, I need to plan a new project, with a database of approximately 100 tables, most with a small number of records (<1000) and approximately 10 table with a large number of records generally numeric data, the total estimated size of the database is <100MB. The database must be on the user's private remote hosts and users access it from different locations via the Internet, to enter data and print reports. It must be Windev windows applications for 30 employees. At the same database should also be made a small web application with 5-10 web forms and tables into which data are entered by external clients of the company. It is expected a maximum of 60 simultaneous connections. I'm thinking about using HFSQL server which could be accessed directly over the Internet, due to the need for the classic Windows applications. Web part I thought realized through AWP technology. Can it work? What do you think about direct access HFSQL database over the internet? This seems to me good in theory, but I have not tested enough this setup to terms with multiple connections. What would be better to use: HFSQL or MSSQL express? I'm worried about the direct access over the Internet, whether it works satisfactorily? Are there any obstacles for that? I do not want to mess with web services because of the limited time available for the project. Please advise me if you have experience in similar situations. Thanks!30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56185/read.awp2 Feb 2016 03:36:00 ZQuote Marijan Tomasic Thank you very much for your answers! Your experiences are very helpful. Steve: For this …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56185/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56185/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56183/read.awp1 Feb 2016 21:25:00 ZThank you very much for your answers! Your experiences are very helpful. Steve: For this kind of solutions I forgot, though…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56183/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56183/read.awpAccessing HFSQL through the internetSebastian Arnoldpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56179/read.awp1 Feb 2016 13:05:35 ZWe use a virtual windows server (cheap, about 20 Euro/month) with HFSQL 19 for a couple of programs and apps with about 10 to 10…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56179/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56179/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56165/read.awp31 Jan 2016 03:25:00 ZI distribute my windev app (SQL Server DB) over the internet using Windows RemoteApp. The advantage of this vs merely access DB …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56165/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56165/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56164/read.awp30 Jan 2016 23:53:00 ZI use it with 60 users 100,000 records in many tables works very well. The only advice is use queries only to fill tables it …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56164/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56164/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56154/read.awp29 Jan 2016 18:12:00 ZHi, I have some DB´s on a Microsoft Hyper V, works. You don´t should use dynamic memory, that´s the only thing to avoid.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56154/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56154/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56147/read.awp29 Jan 2016 17:03:00 ZHi, if possible don't use "direct access over the Internet" . it's matter of lucky and unlucky . just because you lucky for f…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56147/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56147/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56144/read.awp29 Jan 2016 16:38:00 ZMichael, Thanks for reply. HFSQL Port is not a problem. What about virtual servers & HFSQL? Did you tested this? (I know…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56144/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56144/read.awpAccessing HFSQL through the internetguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56132/read.awp29 Jan 2016 13:22:00 ZHi Marijan, direct access to HFSQL works so far. We use it for years with middle and large databases for hundred of users. I…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56132/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56129-accessing-hfsql-through-internet-56132/read.awpAccessing HFSQL through the internet