Articles Search Results

Datafile Software SQL In The SQL In parameters ask: Optimise Records – this asks the number of entries processed in one loop. IP Address – enter the IP Address of the SQL server Database – enter the database name on the SQL... Read More

Datafile Software SQL Out The SQL Configuration has two schedules – one for SQL updates TO the Datafile system, and one for SQL Updates FROM the Datafile System. (SQL Updates to the Datafile system are outside the purview of this manual.... Read More

Datafile Software SQLDET Database Structure Two new data items can be added to the SQLDET.DFD file that will record the program and the parameter number which generated, together with the existing (Premier only) options to record the user-id,... Read More

Datafile Software Configuring the Datafile System Adding the DFSQL User In operation the Datafile SQL Driver accesses the Datafile System with a DFSQL user-id and this user-id needs to be added to the list of user-ids within Datafile as... Read More

SQL Replicator   Connection to SQL Server via ODBC   The Datafile SQL Replicator connects directly to a MySQL or MsSQL Server.  Where the server is on a remote connection you may want to use SSL.   The existing connection... Read More

A new Datafile add-in is available with additional features in the links between Datafile and Microsoft Office. The add-in, available for use for users on Datafile 2018 with the Datafile Excel RTD Add-In, allows for links back from Excel... Read More

Datafile Software Suspend SQL Mirroring During Night / Weekends The SQLMGR program, once started, reads the SQLDET database continually for new records to process and can mean – when your business operates on a set opening times basis ... Read More

Datafile Software Update Individual Records to SQL on Nominal Update When updating from sales/purchase ledgers to nominal ledger then if any databases involved are set to mirror to a SQL database then the system will generate a refresh of these... Read More

Datafile Software Datafile SQL Monitor The Datafile SQL Monitor oversees the SQLMgr program checking for memory usage and time responses. The monitor checks on a set time period (configurable) and if a condition is triggered such as high... Read More

Datafile Software Running the SQL Manager Once you have databases set to mirror / import you are ready to run the SQL Manager – run this from the desktop and/or the menu on start-up menu. When run a small ‘grey’ form will... Read More