Well the Host has investigated and found no errors logged anywhere, so back to square one again. Really strange that the profile page is the only thing not working. I can get to any other Community Builder link without issue in the front or backend. I have also check to see what other modules were being called on the profile page and turned those off, again no difference.
Interesting point, the error states: Could not connect to the SQL server
Wondering why it would say MYSQL, as I don't use SQL.