Thanks for your help. Sorry it took me so long to get back to you.
I switched to a different hosting company and now able to get a connection to the database, but I get a lot of errors when DataAssist pages. I created a insert page with just 2 fields and even though it worked, I got a lot of errors and I'm unable to modify the page.
I am on Dreamweaver CS6. I also have Dreamweaver 2021 but I haven't tested it yet. PHPMyAdmin ver 5.4
I did use MySQLi for the connection