Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » Elevate Web Builder Technical Support » Support Forums » Elevate Web Builder General » View Thread |
Messages 1 to 8 of 8 total |
Windows Application Retrieving/Updating DBISAM Data From/To A Windows VPS? |
Mon, Mar 5 2018 2:42 AM | Permanent Link |
Frederick Chin | Is it possible for a Delphi 7 Windows application to retrieve/update DBISAM data from/to a Windows VPS directly?
-- Frederick |
Mon, Mar 5 2018 3:53 AM | Permanent Link |
Matthew Jones | Frederick Chin wrote:
> Is it possible for a Delphi 7 Windows application to retrieve/update DBISAM data from/to a Windows VPS directly? If you have the DBISAM server running on any computer, then any other can connect to it, so "yes". It is generally a very unwise thing to do though, as any other computer can also connect to it and do whatever it wants. Fine if this is in your local network, quite risky if it is on the internet somewhere. -- Matthew Jones |
Mon, Mar 5 2018 4:04 AM | Permanent Link |
Uli Becker | > Is it possible for a Delphi 7 Windows application to retrieve/update DBISAM data from/to a Windows VPS directly?
Sure, using C/S. Uli |
Mon, Mar 5 2018 8:49 AM | Permanent Link |
Frederick Chin | "Matthew Jones" wrote:
/* If you have the DBISAM server running on any computer, then any other can connect to it, so "yes". It is generally a very unwise thing to do though, as any other computer can also connect to it and do whatever it wants. Fine if this is in your local network, quite risky if it is on the internet somewhere. */ Even with DBISAM's server security, it would still be risky? -- Frederick |
Mon, Mar 5 2018 8:54 AM | Permanent Link |
Frederick Chin | Uli Becker wrote:
/* Sure, using C/S. */ I suppose the speed of data retrieval by the Windows application would not be fast. Will the EWB application and Windows application play nice with each other in terms of table locking and transaction processing? -- Frederick |
Mon, Mar 5 2018 10:06 AM | Permanent Link |
Matthew Jones | Frederick Chin wrote:
> Even with DBISAM's server security, it would still be risky? If someone can get a login, they have all your data, or can delete it. And if you forget to remove a standard account, or it gets re-installed, then you are wide open. See all the MongoDB security issues as example. And SQL Server. And you can get the source to DBISAM, and see the flaws, so I could know how to break in too. Bypass the security. Three attempts and then a blank password works (see Apple!). Does it matter? Is it likely? Depends on your data. If it is your record collection, doesn't matter. Medical records, definitely not. The usual way around it is a service that performs operations on the data, and never allows SQL to pass. -- Matthew Jones |
Mon, Mar 5 2018 10:11 AM | Permanent Link |
Raul Team Elevate | On 3/5/2018 8:54 AM, Frederick Chin wrote:
> I suppose the speed of data retrieval by the Windows application would not be fast. C/S is actually very fast - depending on what speed you mean but we have our app running just fine over internet with remote users. Main enemy in this case is internet latency and to lesser degree available bandwidth. Also application design might come into play - for example form with lot of databound controls each of which requires a trip to the server to load data might appear slow (but that's just due to the number of separate trips needed to server and the latency mentioned above). You also might want to read the C/S sections of manual and look at things like remotereadsize settings for further optimization. > Will the EWB application and Windows application play nice with each other in terms of table locking and transaction processing? > Yes - they will be fine as DBISAM handles locking and such for you already. it will basically "look" like an normal multi-user system so normal rules of change detection etc apply and of course your app has to deal with things like loss of connection and re-connecting etc Raul |
Mon, Mar 5 2018 4:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Frederick,
<< Even with DBISAM's server security, it would still be risky? >> Anything exposed to the Internet is risky. Having said that, we use DBISAM Database Servers exposed to the Internet, but: 1) We only allow encrypted connections with a very strong password. 2) If you can, set up the list of authorized IP addresses in the DBISAM Database Server configuration so that only permitted IP addresses can connect to the database server. Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |