Issue: COM+ Network Access not enabled in Windows Server 2016 - Preventing client connections
Applies to: All versions of DNA Fusion
Summary: Instructions on how to Enable COM+ network access in Windows firewall and/or registry settings manually. By default, COM+ remote access is disabled in Windows Server 2016. To resolve client connectivity issues the operator must manually edit one of the registry settings. It is also possible that some of the firewall settings will need to be changed.
NOTE: Future versions of DNA Fusion (starting with 220.127.116.11) will detect this issue and enable the COM+ Network Access automatically.
https://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.png00Brent Dohertyhttps://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.pngBrent Doherty2017-09-13 16:27:582017-09-13 16:27:58Client Connectivity on Windows Server 2016 (COM+ Firewall Settings)
Using Microsoft Excel, follow the steps below to convert an Excel file to a flat file CSV with text fields in quotes:
Open the Excel file to be imported.
Press Alt+F11 to open the Microsoft Visual Basic for Applications dialog.
SelectInsert/Module from the main menu of Visual Basic for Applications dialog to show script editor.
Copy and Paste the following code into the script editor.
Sub CSVFile() Dim SrcRg As Range Dim CurrRow As Range Dim CurrCell As Range Dim CurrTextStr As String Dim ListSep As String Dim FName As Variant FName = Application.GetSaveAsFilename(“”, “CSV File (*.csv), *.csv”) ListSep = Application.International(xlListSeparator) If Selection.Cells.Count > 1 Then Set SrcRg = Selection Else Set SrcRg = ActiveSheet.UsedRange End If Open FName For Output As #1 For Each CurrRow In SrcRg.Rows CurrTextStr = ìî For Each CurrCell In CurrRow.Cells CurrTextStr = CurrTextStr & “””” & CurrCell.Value & “””” & ListSep Next While Right(CurrTextStr, 1) = ListSep CurrTextStr = Left(CurrTextStr, Len(CurrTextStr) - 1) Wend Print #1, CurrTextStr Next Close #1 End Sub
Close the script editor.
SelectRun/Run Macros from the main menu of Visual Basic for Applications dialog.
Click Run to open the Save As dialog.
Browse to the desired location and clickSave.
The file is now saved in the proper format and can be imported via the DNAImport tool.
https://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.png00Brent Dohertyhttps://www.ooaccess.com/wp-content/uploads/2019/01/OOLogo_H-01-2-300x100.pngBrent Doherty2017-09-13 11:15:432017-09-13 11:36:35Formatting Data for DNA Import