I have used (ssms) SQL server management studio to create a remote server(Local server)for integrating with external database . I was able to create a database connection using Service center but while accessing it in Integration Studio, im unable to find the schema and none of my databasess are present. I have attached the error below.
Hi Infanta,
If you are running your external database on a local server, and assuming you are running OutSystems hosted in the cloud, OutSystems can not find your 'localhost' as it is not accessible through the internet.
You said you were able to create the database connection in Service Center but did you also press the "Test connection" button, and was the result successful?
Regards,
Daniel
Hi Daniel,
I have created remote server using SSMS (MySQL server management studio), while I'm testing my connection , I'm getting this error "Connection String test failed: Unable to connect to any of the specified MySQL hosts. "
1) Are you using OutSystems in the cloud?
2) Is your external database accessible in the cloud?
If both questions can be answered with yes, then either you have firewall issues or an incorrect connection string.
If your answer to question 2 is no, then that is the reason you cannot connect.
I am a newcomber at Outsystems.
So, do I understand than it is possible to setup Service Studio with a localhost external DB using MySQL or others. I've read so for far, that you need a public external URL to make it happen.
For now MySQL connection test in SC is negative!!
Is there a best pratice to do this, in regards to the public domain URL setup?
Thanks!!
The NumÉricGuy
Just wondering did you solve your problem?