I am trying to link my SQL database to the software but failed.
I tried various methods and can’t remember all of them. Here were a few things I tried:
Using crystal reports, I would try to set up a jdbc connection. I needed to install the driver and then add the database connection but every time I did it would say “unable to establish connection” or something to that extent. I would use the IP address provided by the developers and port 3306 to try and create the connection.
Another thing I tried was using the MySQL Workbench to connect to the online database but similar results.
I also tried connecting the database to google data studio and the same error message would pop up saying that they were “unable to establish connection” or “unable to find database” or something like that.
I’m not sure if there is anymore specific step I should follow.
Thank you very much for your help and susggestion