Endpoint Protection Small Business Edition

 View Only
  • 1.  Endpoint Protection appears to break Visual FoxPro OLE DB connectivity.

    Posted May 19, 2016 06:19 AM

    Over the past few weeks we have started having problems with applications that connect to a Visual FoxPro database.

    The following test VBA script will only run through successfully when Symantec.cloud Endpoint Protection (SEP) is unistalled from the client PC...

    Sub test()

    Dim objConn As ADODB.Connection
    Dim rst As ADODB.Recordset

    Set objConn = CreateObject("ADODB.Connection")
    objConn.Provider = "vfpoledb.1"
    objConn.ConnectionString = "data source=C:\####\####.DBC"
    objConn.Open


    End Sub

    Also Excel's Data Connection Wizard will not connect to a Visual FoxPro database whilst SEP is installed.

    No alerts or events appear to be noted in the SEP logs and disabling all SEP protection services on the client does not appear to fix the problem - our only resolution to date has been to uninstall SEP.

    SEP version is NIS-22.5.4.24 

    Has anyone experienced similar problems and is there a solution?

     

     



  • 2.  RE: Endpoint Protection appears to break Visual FoxPro OLE DB connectivity.

    Posted May 19, 2016 08:01 AM

    So disabling doesn't work but removing does? Am I understanding that correctly?

    Have you tried adding the script as an exclusion?



  • 3.  RE: Endpoint Protection appears to break Visual FoxPro OLE DB connectivity.

    Posted May 19, 2016 09:21 AM

    Via the hostedendpoint.spn.com console we set up a protection policy where all protection features were disabled apart from Anti Virus (AV) - and we gave the user the option to disable Anti Virus. When the policy was applied to the client PC and when the user disabled AV the problem with DB connectivity still remained.

    No we have not tried adding any exlusions - the problem manifests itself when running MS Access and Excel based applications - the VBA script was written to test the OLE connectivity to the FoxPro DB.