Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
9
Erster Beitrag:
vor 2 Jahren, 4 Monaten
Letzter Beitrag:
vor 2 Jahren, 4 Monaten
Beteiligte Autoren:
Marijan Tomasic, Michael Drechsel, steve erts, CCC2, DW

Accessing HFSQL through the internet

Startbeitrag von Marijan Tomasic am 29.01.2016 12:10

Greeting,

I need to plan a new project, with a database of approximately 100 tables, most with a small number of records (

Antworten:

Hi Marijan,

direct access to HFSQL works so far. We use it for years with middle and large databases for hundred of users.
It´s fast and stable.

The only disadvantage is that the users must open the HFSQL Port (for example 4900) outgoing which is not allowed in many companies.

von Michael Drechsel - am 29.01.2016 12:22
Michael,

Thanks for reply.
HFSQL Port is not a problem.

What about virtual servers & HFSQL? Did you tested this?
(I know that is not recomended by PCSoft, but if server is not loaded...)

von Marijan Tomasic - am 29.01.2016 15:38
Hi,

if possible don't use "direct access over the Internet" . it's matter of lucky and unlucky . just because you lucky for few years , doesn't mean you will lucky tomorrow . at least use VPN.

if you need connect from windows application , web application , mobile application . you might as well create a webservice

von CCC2 - am 29.01.2016 16:03
Hi,

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.

von Michael Drechsel - am 29.01.2016 17:12
I 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 is the fastest way, hFilter on a table very slow with a lot of records.

Dw

von DW - am 30.01.2016 22:53
I distribute my windev app (SQL Server DB) over the internet using Windows RemoteApp. The advantage of this vs merely access DB over the internet is that you only have to distribute a RDP connection to the user and when you update the application you only have to update the exe in a single location. From the user perspective it looks like they are running the app directly on their desktop. The only downside is that drag and drop is not supported from client to host. (copy and paste does work)

von steve erts - am 31.01.2016 02:25
Thank you very much for your answers!
Your experiences are very helpful.

Steve:
For this kind of solutions I forgot, though met with such applications.
I'm interested in how the reports and printouts work in such an environment,
as well as whether there is any licensing restriction regarding the
simultaneous connections on windows server?

Can a solution designed in that way also replace the web application part?
(web application was the first idea for the sole reason to avoid the need
for installation on external associates)

von Marijan Tomasic - am 01.02.2016 20:25
Quote
Marijan Tomasic
Thank you very much for your answers!
Your experiences are very helpful.

Steve:
For this kind of solutions I forgot, though met with such applications.
I'm interested in how the reports and printouts work in such an environment,
as well as whether there is any licensing restriction regarding the
simultaneous connections on windows server?

Can a solution designed in that way also replace the web application part?
(web application was the first idea for the sole reason to avoid the need
for installation on external associates)


Reports and printing work fine. You can configure your RDP connections to use local resources. You do need to have Terminal Service licenses for this method.

von steve erts - am 02.02.2016 02:36
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.