Show/Hide Toolbars

DBA Help

Before you install the software, carefully review our system requirements to make sure your hardware and network meet our minimum standards.  

Firebird™ SQL Database

The DBA system includes the Firebird™ relational SQL database.  Firebird only works properly under these conditions:

The Firebird database must be installed on the same file server as the DBA software.  

Only use DBA with the version of Firebird supplied with the system (Firebird 3.0.4)

Firewall Exception TCP port 3050

The Firebird database uses TCP port 3050 for communications between the Server and Client Workstations.   We recommend setting a firewall exception for TCP port 3050 for both outbound and inbound traffic on the Server and each Client Workstation.

Internet Access

Your company must be equipped with high speed internet access to use the DBA system.  Our software registration keys, product updates, documentation, training videos, and online support are all delivered over the Internet.

Power Protection System (UPS)

An abrupt power loss or crash from unclean power is the most common cause of data corruption.  Your file server requires clean and continuous power to function properly.  Factories are especially subject to power fluctuations.  It is imperative that you protect your server with a power protection system that includes surge suppression, power conditioning, and battery backup.  

Database Backups

Your data is your most valuable asset and must be protected from day one.  Accordingly, you must devise a database backup strategy and have the storage devices and backup plan in place.  You must use the DBA Backup Manager to backup your Firebird database daily. When the Backup Manager makes a database backup, it creates a special FBK file that can be safely backed up with a generic software program or service.  

Tab   Backup Manager

Network Type

DBA can be installed on most any Windows-based client/server or peer-to-peer network.

Network Server

Operating System: Windows Server 2022, Windows Server 2019, Windows Server 2016, Windows Server 2012/2012 R2, Windows 2008/2008 R2.   Essentials, Small Business Server, Standard, and Datacenter editions supported on all versions listed.

RAM: as required by the operating system

Free Disk Space: At least 2 Gigabytes (GB)

Solid State Drive (SSD) recommended for optimal performance

Microsoft .NET Framework 4.5.2 or greater

Wired Ethernet Connection

Static IP Address  

Screen_Help Email Domain Authentication

Hosting (Cloud)

DBA can be installed on a hosted server.  Workstation access is provided via Microsoft Remote Desktop Services (RDS - formerly Terminal Services).  Microsoft RDS CALs (client access licenses) are required.  

Tab   Hosting

Client Workstations

Client workstations access DBA through your local area network.  A DBA Manufacturing Client gets installed on each client workstation to provide start menu access, desktop icons, a database engine, and online help.  

Operating System: Windows 11 Pro, Windows 10 Pro, Windows 8 Pro, Windows 7 (Pro or Ultimate)

RAM: as required by the operating system

Microsoft .NET Framework 4.5.2 or greater

Wired Ethernet Connection

WARNING: Do not use wireless connections

Do not use wireless connections because client workstation will experience disconnections, access violation errors, and potential data corruption.  

NOTE: If you wish to furnish a PC with a wireless connection, it must be set up as a remote desktop workstation (see next).  

Tab   Shop Floor Access

Remote Desktop Workstations

Remote desktop workstations access DBA remotely by accessing the server's desktop (using Microsoft Remote Desktop Services) or a client workstation's desktop (using Microsoft Remote Desktop Connection).

Operating System: Windows 11 Pro, Windows 10 Pro, Windows 8 Pro, Windows 7 (Pro or Ultimate)

RAM: as required by the operating system

Use Microsoft Remote Desktop Connection (RDC) for remote access to a wired client workstation's desktop.  

Use Microsoft Remote Desktop Services (RDS - formerly Terminal Services) for remote access to the server's desktop.   A Microsoft RDS CAL (client access license) is required.  (NOTE: RDS is not available with Microsoft Small Business Server).  

SERVER SETUP: Provide users with access to the server desktop.  Do not publish DBA as an App.

Tab   Shop Floor Access

Tablets, Mobile Devices, and Notebooks

Mobile devices are useful for shop floor processes such as stock counts, material issues, job labor updating, and job receipts.

The device can access DBA via Microsoft Remote Desktop App (Android, iOS, and Windows).

Use Microsoft Remote Desktop Connection (RDC) for remote access to a wired client workstation's desktop.  

Use Microsoft Remote Desktop Services (RDS - formerly Terminal Services) for remote access to the server's desktop.   A Microsoft RDS CAL (client access license) is required. (NOTE: RDS is not available with Microsoft Small Business Server).

SERVER SETUP: Provide users with access to the server desktop.  Do not publish DBA as an App.  

Tab   Shop Floor Access

Printers

All reports and forms print in graphical format on any Windows-compatible laser or ink jet printer.

The standard labels supplied with the system are designed to print on a continuous roll label printer with 4 inch wide labels.  The default label sizes are 4 x 2 and 4 x 4.