Skip to Content (Press Enter)
2018-02-08 01-43-41
Nasab Salman
575Views
6Comments
Connection String test failed: Unable to connect to any of the specified MySQL hosts.
Question
Database

Whats wrong with this thing?

0
0
09 Feb 2018
Copy Link
2012-03-02 13-17-21
Paulo Ramos
Staff

This simply means the OutSystems front-end can't connect to the BCItems server.

I'm going to assume that you've already tried to connect from your laptop (using a SQL client), and it worked. Just remember that the connection above comes from the OutSystems front-end, not your own machine.

If the OutSystems environment is in the cloud, you probably need to involve the infrastructure team in order to expose the MySQL server (eventually using a VPN). If everything is on-premises, there may be network restrictions as well (again, involve the infra team).

0
0
09 Feb 2018
Copy Link
2018-02-08 01-43-41
Nasab Salman

Paulo Ramos wrote: Same problem as this?

This simply means the OutSystems front-end can't connect to the BCItems server.

I'm going to assume that you've already tried to connect from your laptop (using a SQL client), and it worked. Just remember that the connection above comes from the OutSystems front-end, not your own machine.

If the OutSystems environment is in the cloud, you probably need to involve the infrastructure team in order to expose the MySQL server (eventually using a VPN). If everything is on-premises, there may be network restrictions as well (again, involve the infra team).


0
0
09 Feb 2018
Copy Link
2012-03-02 13-17-21
Paulo Ramos
Staff

Yes, same problem - you'll need to fix the connection string before using the wizard in Integration Studio.

Adding to what I wrote before:

  • From your server's hostname (raven*...) it seems you're using a free Personal Environment - but the built-in VPN is only an option for an Enterprise environment.
  • Thus, you'd need to expose your MySql server to the internet (using a fully qualified hostname or IP) - BCItems won't work.
0
0
11 Feb 2018
Copy Link
2018-02-08 01-43-41
Nasab Salman

Paulo Ramos wrote:

Yes, same problem - you'll need to fix the connection string before using the wizard in Integration Studio.

Adding to what I wrote before:

  • From your server's hostname (raven*...) it seems you're using a free Personal Environment - but the built-in VPN is only an option for an Enterprise environment.
  • Thus, you'd need to expose your MySql server to the internet (using a fully qualified hostname or IP) - BCItems won't work.

What if i do have this thing? Im using Microsoft SQL Server Management Studio Express

0
0
12 Feb 2018
Copy Link
2018-02-08 01-43-41
Nasab Salman

Paulo Ramos wrote:

Yes, same problem - you'll need to fix the connection string before using the wizard in Integration Studio.

Adding to what I wrote before:

  • From your server's hostname (raven*...) it seems you're using a free Personal Environment - but the built-in VPN is only an option for an Enterprise environment.
  • Thus, you'd need to expose your MySql server to the internet (using a fully qualified hostname or IP) - BCItems won't work.

New problem , looks like im going to allow remote connections or something else? 

0
0
12 Feb 2018
Copy Link
2012-03-02 13-17-21
Paulo Ramos
Staff

Hi,

You need to use a qualified hostname or IP address - 102100(...) won't work over the internet. And eventually you may also need to change firewall settings.

0
0
14 Feb 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.