Windows Authentication on SQL server

Hi All, I would like to know if there’s any 4D plug-in that is available for 4Dv11 through to v13, that will facilitate logging in to a SAP SQL server. My client’s IT has unilaterally decided to replace the SQL server and decided that this set up will be a non-mixed Windows-only authentication

Re: 4D Database Server Hardware recommendation

Hi, I’m interested to learn more about the nuances of this too. Say if the client were to go for Windows Server 2012 + 8GB or 16GB RAM + a database of say 5GB data file with an average of 30 concurrent logins, how would we decide on the memory allocation in order to best utilise the hardware

Server Specs for 4Dv15/16 under Windows Server 2016

Hi, I’ve been requested to provide the optimal server specifications for running 4Dv15 or 16 with regards to the CPU, memory and disk requirements for a new VM running Windows Server 2016. Other than the hard disk requirements which is dependent on the data size and the projected rate of

Re: Server Specs for 4Dv15/16 under Windows Server 2016

users +/- at any one time, what would you recommend by way of hardware specs for the server and the amount of RAM to allocate? Regards, Ronnie > On 1 Aug 2017, at 10:08 pm, 4d_tech-requ...@lists.4d.com wrote: > >> >> On Aug 1, 2017, at 05:19, Ronnie Teo via 4D_Tech <

4D Server v11 License

Hi, For a variety of reasons, I have a user who is looking for a 4D Server v11 license. Does anyone have a spare copy to sell? Regards, Ronnie Tarawerkz ** 4D Internet Users Group (4D iNUG) FAQ:

Re: 4D Server v11 License

Hi, thanks for your replies. The reason why the customer needs v11 server is this These are new users from a not so resource-rich hospital. They were given a small v11 app to use for free but do not have the resource to have the app upgraded. They want to be legit, hence the intention to

Primary Key in 4Dv15

Hi All, Need to seek some advice in converting a client’s database from v11 to v15. For one of the tables, 4D reported that the primary key contains NULL values upon conversion or that the primary key contains duplicate values. The primary key was defined to be a UUID-type value. So if some

Re: Primary Key in 4Dv15

Hi Magnus, Thanks for your reply and your sample code. Am outstation this week but will test it at the first opportunity. Regards, Ronnie Tarawerkz > On 25 Oct 2017, at 10:27 pm, 4d_tech-requ...@lists.4d.com wrote: > > From: Magnus Torell > >

Re: Primary Key in 4Dv15

m>> > Subject: Re: Primary Key in 4Dv15 > Message-ID: <a6d2a1a5-cc53-444d-98f4-e26a501eb...@init5.fr > <mailto:a6d2a1a5-cc53-444d-98f4-e26a501eb...@init5.fr>> > Content-Type: text/plain; charset=utf-8 > > >> Le 24 oct. 2017 à 11:49, Ronnie Teo via

HTTPS Connection for Web Module

Hi, I’ve written earlier about a 4Dv11 application with a web module. The client's IT now wants all access to be secured and only allow https connections. According to the manual, we would need to place 2 files alongside the structure files in the database folder, namely the cert.pea dn

Re: Web Service Call in 4Dv15

Hi Tim, Thanks for your heads up. FWIW, I have also tested the Web Service Call command at any another site (call this SiteB) using the same version 4Dv15.5 running on Windows 2012r2. The test at Site B was successful and the only difference appears to be that the soapURL for Site B is a

Re: Web Service Call in 4Dv15

Hi All, I raised this question almost a month ago now and am still stuck on the same problem. I have raised a case with 4D but the reply ahas been very generic, with references to the web services section of the manual (of which I have read numerous times). A quick refresh, I am unable to

Graphing in 4Dv15

Hi, With 4Dv15 on Windows, does anyone have recommendations as to their favourite graphing/charting plugin currently available? It is preferably a plugin where the plugin license is purchased outright rather than on a yearly subscription… Thanks. Regards, Ronnie Tarawerkz

HTTPS Connection for Web Module

Hi All, I have a 4Dv11 application with a web module. The client's IT now wants all access to be secured and only allow https connections and I'm a bit lost as to what to do. I think I’ve managed to create a cert.pem file, put the key.pem and the cert.pem files together with the structure.

Working 4Dv15 Windows

Hi All, I am in the midst of converting 4D Windows-based application from v11 to v15 and encountered a strange issue. When editing a method under v15, all the text are jumbled up. I tested with creating a new method, not just methods carried over from the past and the effect is the same. For

Combine pictures in v15

Hi All, I have a query regarding combining 2 pictures in v15. I have a function in a v11 application whereby the user drags a picture onto a base picture. A new merged picture is created using the 4D picture operator | ……. Picture1 := Picture1 | Picture2 Now the app is in the process of being

Re: Working 4Dv15 Windows

Hi Jim, Thanks for your reply. I managed to solve my issue following advice from Armin Deeg. I did the following : • Change the font for the method editor • Deleted the 4D folder files inside c:\users\USERNAME\Appdata\Roaming\4D\4D Preferencesv15.4dpreferences and 4D Window Bounds v15 The

Re: Working 4Dv15 Windows

.html> > > etc. > >> 2017/10/19 22:51、Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com >> <mailto:4d_tech@lists.4d.com>> のメール： >> Does anyone know what is the cause and how to rectify this. Thanks. > **

Re: Combine pictures in v15

vely you could explicitly replace the "white" pixels with > "transparent". > > http://doc.4d.com/4Dv15/4D/15.4/TRANSFORM-PICTURE.301-3274515.en.html > <http://doc.4d.com/4Dv15/4D/15.4/TRANSFORM-PICTURE.301-3274515.en.html> > >> 2017/10/19 22:56、Ronn

Re: 4Dv15 applications as a Service in Windows Server 2012

Hi Paul, Thanks for the reply. Running v15 on 2012 is not a problem. I’m only having issues running it as a service. When the service is launched, it doesn’t appear under the Available tab. Even when I specify the IP address directly, it is not able to connect. When launched directly from

Re: 4Dv15 applications as a Service in Windows Server 2012

Hi Jim, I’m testing both under the same account. Double-clicking works while running under Service does not. FWIW, under the same account, running under service and direct app works for v13 apps. Regards, Ronnie > On 7 Sep 2018, at 3:00 AM, 4d_tech-requ...@lists.4d.com wrote: > > From:

Re: 4Dv15 applications as a Service in Windows Server 2012

Hi Jim & Paul, This is my finding after testing over the weekend with Windows Server 2012 and 4Dv15.5. Running a v15 app with 4Dv15.5 (64bit) as a Windows service does NOT work. Running the same app with 4Dv15.5 (32bit) as a Windows DOES work. In the latter scenario, the database name appears

Re: 4Dv15 applications as a Service in Windows Server 2012

: +1-408-557-4600 > Fax : +1-408-271-5080 > Email : vvillanu...@4d.com <mailto:vvillanu...@4d.com> > Web : www.4D.com <http://www.4d.com/> > > > > > > -Original Message----- > From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.c

Re: 4Dv15 applications as a Service in Windows Server 2012

hone : +1-408-557-4600 > Standard : +1-408-557-4600 > Fax : +1-408-271-5080 > Email : vvillanu...@4d.com <mailto:vvillanu...@4d.com> > Web : www.4D.com <http://www.4d.com/> > > > > > > -Original Message- > From: 4D_Tech

Web

Hi All, I would like to seek some help/advise on an XML issue in 4Dv15 on Windows. I have an app that is currently running in v11. XML transmission via the consumption of a hosted web service is working well. User decides to upgrade their server from Windows Server 2008r2 to 2012 and from v11

Web Service Call in 4Dv15

Hi All, I would like to seek some help/advise on an XML issue in 4Dv15 on Windows. I have an app that is currently running in v11. XML transmission via the consumption of a hosted web service is working well. User decides to upgrade their server from Windows Server 2008r2 to 2012 and from v11

Re: Web Service Call in 4Dv15

Thanks Patrick, I’ll check it out. > Did you check preference in 4D about security. There is some improvement on > it. It may be the cause. > For that, there is an article on the 4D Blog (blog.4d.com > ) > > Patrick Julio, the web service is not hosted by 4D, so a 4D

Re: Web Service Call in 4Dv15

Hi All, I raised this question a week ago and am still stuck on the same problem. A quick refresh, I am unable to consume a web service from a 4Dv15.5 application (converted from 4Dv11). The v15 application is running on a Windows 2012 server, say Server1. The 4D v11 application running on the

Cross-platform Migration v15 App

Hi, I have a client who has been running a pure-Mac environment for years. The current iteration is a v15 database application. Going forward, their IT is toying with the idea of moving the 4D Server to a Windows Server. The client users will all remain on the Mac. Are there are any gotchas to

Re: Cross-platform Migration v15 App

ere were places in > the database where files were being saved with file names generated from the > user data, so the code was only checking for path naming issues relevant to > the Mac OS. > >> On Oct 30, 2018, at 2:55 AM, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> >> wrote: &

4Dv15 applications as a Service in Windows Server 2012

Hi, I have not been able to run v15 applications as a service under Windows Server 2012, using 4Dv15.5 When the service is started, I am unable to connect to the database from a client, the Available tab is also empty. It is not a problem when the same v15 application is launched directly with

Re: 4Dv15 applications as a Service in Windows Server 2012

Hi Gerald, Thanks for your heads. Yes, I had confirmed that the application is registered in the firewall. Regards, Ronnie Tarawerkz > On 3 Sep 2018, at 11:34 PM, 4d_tech-requ...@lists.4d.com wrote: > > Subject: Re: 4Dv15 applications as a Service in Windows Server 2012 > Message-ID:

Re: 4Dv15 applications as a Service in Windows Server 2012

the SQL port to a different value > even you don't use SQL (not only the common C/S ports). > >> -Original Message- >> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Ronnie Teo >> via >> 4D_Tech >> Sent: Monday, September 3, 2018 10:35 A

Tracking Field Data Changes

Hi, I have a client running a 4D application for about 50+ users. A recent audit has thrown up a request to be able to track change made to each field in the database. The audit would encompass the date and time of change, the field changed and the before and after values. Does anyone know if

Re: 4Dv15 applications as a Service in Windows Server 2012

Hi David, Thanks for your tip. I have conducted the test as per your suggestion and from the results of the test, it does not appear to be a firewall problem. a) 4Dv15.5 (32-bit) - server app launched directly - database server appears on Available tab on Client (works OK) b) 4Dv15.5

Re: 4Dv15 applications as a Service in Windows Server 2012

Hi Justin, The SET ABOUT command is not used in this app. When testing David’s suggestion, I had also tested running the service both with and without checking the “Allow Service to interact with desktop” checkbox to no avail. I think I’ll just have to weigh between running v15.5 Server

4D And NTLMv2 & LDAP/SMB Signing

Hi All, My user’s IT is looking into implementing the following: 1. Enforcing NTLMv2 authentication on all servers & PC 2. Enabling LDAP and SMB signing on all servers and PCs They have asked for the following feedback : 1. Does 4D have any compatibility or limitation when the setting

Re: Data Merge from v13 to v15

Hi Chuck, Thanks for your reply. What do you think of the option of converting the v13 structure to v15, synchronise the field order/type, then use Send/receive record? Regards, Ronnie Tarawerkz > On 1 May 2019, at 12:08 AM, 4d_tech-requ...@lists.4d.com wrote: > > Message: 6 > Date: Tue, 30

Re: Data Merge from v13 to v15

Hi Mike, thanks for the reply. Yes, in my scenario, the size of the data file is much smaller, less than 10GB. So I should think an export/import by table would be the approach. The slight complication is that a couple of the main tables have many subtables….one of them alone has 40+ subtable

Data Merge from v13 to v15

Hi All, A client has requested to decommission a v13 database and merge the data into a separate v15 database. The 2 database structures started the same (as in same tables and fields) but has expanded in different directions down the years. It would be fair to say that the fields in the v13

Re: Data Merge from v13 to v15

r to write import methods that > dealt with the data in the context of the new structure. Granted you may > wind up with some pretty slow methods. But they only need to run once. And > the importance of accuracy outweighs the time. At least in my case. > > > On Mon, Apr 29, 2019 at 11:53 PM Ronn

4D Security White Paper

Hi, Does anyone know if 4D have published any white papers relating to security specifically for 4D versions v15 and v17? For example, my client would like to know what is the database encryption strength level like for the above mentioned versions. Regards, Ronnie Tarawerkz

Re: 4D Security White Paper

Thanks for your input, Jody. Regards, Ronnie > On 24 Apr 2019, at 9:29 PM, 4d_tech-requ...@lists.4d.com wrote: > > From: Jody Bevan mailto:jody.be...@gmail.com>> > To: 4D iNug Technical <4d_tech@lists.4d.com > > Subject: Re: 4D Security White Paper > Message-ID:

Subject: Re: 4D Security White Paper

Hi, thanks to all for heads-up. Will catch up on the reading ….. Regards, Ronnie Tarawerkz ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech

Blanket Font/Stylesheet Change

Hi All, I recently upgraded a v11 application to v15 on Windows Server 2012. All works till now when one of their users upgraded their OS to Windows 10. Now when the user logs in, the some fields and objects on the forms show gibberish. The fields and other objects normally render in Arial,