Posts

Connecting to SQL Server

Image
How to connect Nios4 to SQL database The Windows version of Nios4 usually uses Access databases because it allows you to perform simple installations without additional software. After all, Access is a database system created to manage a few data with reduced performance . In case you need to handle several records , especially on your local network, you can switch to SQL Server : the main Microsoft database system . In this article, you will learn how to do it. Nios4 always first creates the Access database to connect. This means that your SQL Server database will be connected after a standard installation . How to do it First, from the Database Manager press the Add button. Select the Advanced Connection item ( Connessione Avanzata , in the screenshot above), so you can define the database connection string. Remember that the database must already be present in SQL Server as an instance. It is fundamental that you have already created it because, during the first connect

Sending emails through external assemblies

Image
New components to send emails with Nios4 Since version 1.0.1.12 for Windows , a process of modifying the system has started to allow other programmers to interact with the software through external assemblies or OLE technology . One of the first “links” is the ability to intercept the request to send emails , replacing it. Nios4 for Windows normally delegates the task of sending the actual electronic mailbox program installed on the computer but, for several reasons, this communication may not be possible. To fix the problem, dll components have been created to insert inside the program folder to allow their loading, and that replaces the standard system. The system permits only one element, which must necessarily be called mailnios4.dll . In the Download section of the developer.nios4.com website, you can find the features for connecting specific inbox systems or the direct send from the program. This component is not an actual messenger program because it only offers a

How to make a time marking machine with Rasberry and Nios4 (second part)

Image
Cloud database creation and first sync In this second article , we will install the Python programs to read the RFID data, check their validity , and send them to your cloud database for storage and sharing . If you missed the first part of the guide about how to make an attendance marking device with Raspberry and Nios4 , click here to make it up. Steps After checking that all components work and have access to the Raspberry , create an account on the website web.nios4.com . Once you sign in, the site will ask you to choose a template to create the first database. In the GitHub project that you downloaded in the previous article, there is a package for creating the database to use. By choosing a custom template or using the Install Package command inside the Help menu of all the open repositories, select and install the attendance_makers.nios4 file . This directory will create the databank with all the fields and tables you need to use in this example. After insta

How to make a time marking machine with Raspeberry and Nios4 (first part)

Image
Let’s make the circuit of an attendance marking machine with Raspberry In this article, you will learn how to make a time marking machine by using Raspberry Zero as a hardware base and Nios4 as a system for data collection . You can also realize an outdoor attendance marking machine by using a waterproof box and including a battery . This way, it will be either independent and placeable anywhere. However, this article will explain how to make the without-battery version by powering the Raspberry using its Micro-USB port to make it easier. In the cover photo , you can see the one that we realized for the office : the device is fixed to the wall and powered directly. Components 1 Raspberry Pi Zero 1 RFID-RC522 1 IIC/I2C 20x4 LCD or IIC/I2C 20x2 LCD version Assembling Connect the RFID reader and the LCD headset to the Raspberry , as you can see in the diagram below. In the example with the battery , I used a TP4056 to charge the battery and leave the Raspberry Micro-USB p