Home » Categories » Multiple Categories

Connection to SQL Server via ODBC and SQL Log Housekeeping

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 options don’t allow this but you can now connect via ODBC – with ODBC set to use SSL.

 

To enable connection via ODBC you need to setup your ODBC connection to the SQL Server and apply your required security settings.  Once in place you then need to enable the Datafile SQL Replicator to use the ODBC connection.  

 

To this you need to manually enable two Registry settings.  The relevant entries to enable ODBC are in the registry key

 

HKLM\SOFTWARE\WOW6432NODE\Datafile Software Solutions Limited

 

within here you’ll have nodes for Datafile Replication\DF2SQL\SQLConnections\SQLConnectionnn

 

 

ODBC DSN – modify to include the name of your System DSN connection.

Use ODBC DSN – modify to set to ‘1’ to use the ODBC DSN connection.

 

 

Note

 

If you are adding ODBC connectivity to an existing SQL Connection you may find that the two ODBC registry values are not in place.  Open the SQL Monitor and then close – this will automatically add the new registry keys.

 

 

 

SQL Log Housekeeping

 

As part of replicating the Datafile tables to MsSQL or MySQL the system maintains an activity log within a table DF2SQLLog.  This log file expands over time and may need to be periodically cleared down to keep the SQL Database size down.  This new feature allows the SQL Replicator to perform this housekeeping – retaining a set number of days.

 

As part of the SQL Configuration for the Replication Stream a new option allows you to set the retention period.

 

 

Time – set the time to perform the cleardown of the DF2SQLLog table – the time set should not be within the ‘excluded times’ for processing.

 

Log Days to Retain– set the number of days to retain when cleardown the log table.

 

 

Note

 

Once set, to enable the Replicator to clear down you will need to stop and restart the service.

 

 

 

 

 

 

 

 

Custom Fields
  • Release ID: 7.0
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Extra 160 Items per Database
Viewed 1874 times since Wed, Jun 13, 2012
Document Reprint - Select Multiple Documents
Viewed 2130 times since Mon, Nov 25, 2013
Ledger Enquiry Links to Discount and Supplier Matrix
Viewed 1782 times since Fri, May 20, 2016
Report Generator - Application Reports
Viewed 1814 times since Wed, Jun 13, 2012
SMB2, SMB3 and Opportunistic Locking
Viewed 24137 times since Tue, Apr 8, 2014
Reprint Options when Report to Screen
Viewed 1848 times since Fri, Jun 8, 2012
Microsoft Office Links
Viewed 372 times since Thu, Sep 4, 2014
Pick Lists – Saved Selection Criteria
Viewed 605 times since Thu, Jun 18, 2020
Ledger Enquiry – Update Sales / Purchase Accounts
Viewed 1709 times since Wed, Jun 13, 2012
Document Design Manager - Inserting New Items
Viewed 2466 times since Wed, Jun 13, 2012