MD5 in vb6 hash password

Question

How to write md5 hash in vb6 ?

I wrote this syntax but it gives me error in SQL MariaDB:

check the manual that corresponds your MariaDB version for the right syntax to use near'(32),HashBytes ('MD5','Text2'),2

INSERT INTO student (Student_id,password,firstname)VALUES ('" & Text1.Text &" ' , CONVERT( NVARCHAR (32),HashBytes ('MD5' ,'"&Text2.Text&"'        ),2),'"&Text3.Text&"')"

Answer 1

Here are three resources for you:

Listing of MD5 Class for Visual Basic

cMD5.cls

MD5 Hash Calculator for VB6