configure maria db to create crystal report (to get values from phpmyadmin to make crystal reports)
'MUST' download version 2 of maria db connector (if it is 32 bit it will be helpful even your laptop supports 64bit) from https://mariadb.com/downloads/?showall=1&tab=connectors&group=mariadbconnectors&product=ODBC%20connector#connectors go to control pannel > Administrative tools >ODBC Data Sources (32-bit) then go to System DSN add new select mariodb odbc 2.0 driver give a custom name like test or what ever you want add your server name add the user name and password of PHPMyAdmin login then select your database next, all the rest of the interfaces then finish now go to the visual studio create a crystal report then go to field explorer select database explorer right-click and select the database expert then create new connection select OLE DB (ADO) now add Microsoft OLE DB ODBC provider for ODBC driver now select the name of your created System DNS name (ex: test) give your User name and password of PHPMyAdmin login then finish keep in mind to download t