Tech Bulletins 2016

Connecting a RS-485 Reader

Issue: Connecting a RS-485 Reader

Applies to: DNA Fusion version 6.0 and above

Summary: Instructions on how to connect and utilizing a reader via RS-485 instead of Wiegand.

Download PDF w/images: 

First, wire the reader correctly and configure the reader for OSDP in DNA Fusion.  For a reader to communicate via RS-485 mode rather than Wiegand, the wires for RS-485 connection (per the reader schematics) need to be wired to the CLK/D1 and DAT/D0 points on the reader port of the sub-controller.

For example, on an AptiQ reader, the schematic shows that the Pink A/Y wire needs to be connected to the CLK/D1 port and the Tan B/Z wire needs to be connected to the DAT/D0 port.

Once the reader is wired, the reader properties in DNA Fusion will need to be configured to reflect the OSDP interface.

To set the reader properties in DNA Fusion:

  1. Open DNA Fusion and log in.
  2. Open the Hardware Browser and expand the Door to locate the desired Reader.
  3. Right click on the reader and select Properties from the resulting menu.
    **The Reader Properties dialog opens**
  4. Select the Reader Properties option from the menu on the left of the dialog.
  5. Check the Open Options website for more Technical Bulletins
  6. Select the Reader/LED Config: drop down and select the OSDP Reader option from the list.
  7. From the Keypad Mode drop down, select 0 No Keypad Decoding Defined option.
  8. Uncheck the Wiegand Pulses option as well as the Trim Zero Bits option.
  9. Click the OK button to save the changes.
    **The DNAFusion download dialog will appear**
  10. Click Yes to download the changes to the controller.

Moving the DNA Fusion Database

Issue: Moving the DNA Fusion database

Applies to: All version of DNA Fusion

Summary: Instructions on how to correctly move the database to a new database server.

Download PDF w/images: 


1. Shut down all DNAFusion clients.

2. Stop the DNA Driver Service (dnadrvr32) on the Application Server.

3. Open SQL Server Management Studio and log in.

4. Expand the Databases option, right-click on the DNAFusion database and select the Tasks / Backup option from the
menu.

**The Back Up Database—DNAFusion dialog appears**

5. If needed, change the Backup settings and click OK.

The database is backed up to the specified location.

6. On the new database server, open SQL Server Management Studio and log in.

7. Right-click on the Databases option and select Restore Database.

8. Select the DNAFusion database.

9. Specify the location of the back up file.

10. Click the OK button.

**The database is restored to the new server**

NOTE: The new database must retain the same name as the old server.

11. From the Control Panel, select Administrative Tools.

**The Administrative Tools dialog will open**

12. Double-click the Data Sources (ODBC) option.

**The ODBC Data Source Administrator appears**

NOTE: For 64-bit systems the DSNs may be accessed by running: C:\windows\syswow64\odbcad32.exe

13. Select the System DSN tab.

14. Select the DNA Reports item and click the Configure button.

**The Microsoft SQL Server DSN Configuration dialog appears**

15. Select the new database server from the Server drop down list.

16. Click the Finish button.

17. Repeat 13 through 15 for the following DSN’s:

  • DNAENTRIES
  • NPowerAMT
  • NPowerDNAAudits
  • NPowerDNAH
  • NPowerDNAP

18. Verify the database permissions for the following:

  • Account running the COM+ Objects and the DNADrvr32 service has access in the User Mapping to the datareader, datawriter and ddladmin options in SQL Server Management Studio.
  • User accounts for Fusion operators has access in the User Mapping to datareader option in the SQL Server Management Studio.
  • If a database administrator will be responsible for future upgrades, they will need access in the User Mapping to the datareader, datawriter and ddladmin options in SQL Server Management Studio.

19. On each Fusion client workstation, open the Data Sources (ODBC) dialog and select the System DSN tab.
The ODBC Data Source Administrator appears.

20. Select the DNA Reports item and click the Configure button.

**The Microsoft SQL Server DSN Configuration dialog appears**

21. Select the new database server from the Server drop down list.

22. Click the Finish button.