i have this error "Connection String test failed: Unable to connect to any of the specified MySQL hosts." so i think i am using a wrong server name so thats why i have this error could you tell me which server i should provied in the server section ? im using mysql
thanks for this tutorial, i did create simple mobile app which is contain: ID, Name, Phone number...i need to connect this data entry to our external SQL server ? thx
Hi! I tried to set the Database Connection and i receive the following error: "Connection String test failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)". I used my SQL Servername and Authentication. Any tips how to solve this?
Seems like its a connection/network error. is your database server available over internet? It has to be for what you're trying since your outsystems servers are on the cloud.
Hello Yoshi, from your app in OutSystems, you're able to read and write in the external database but you're not able to change the structure example adding a new column in an existing table from an external database. For your second question, yes, you can make an entire app using external data source only.
This example is connecting to a hosted database from the OutSystems application server. You can connect to databases anywhere (localhost, through vpn, or other publicly accessible hosted db's) via direct connection. Speaking of offline, the ability to create mobile apps in OutSystems allows for an offline storage database for your mobile apps as well, so you can work with data offline on native devices if you wish to create mobile apps.
goto azure to create free account. In order to work one login for admin for spl server -what you use to login azure-, then the admin would craete a user to connect to the database. The admin login will not work to connect to database.
i have this error "Connection String test failed: Unable to connect to any of the specified MySQL hosts."
so i think i am using a wrong server name so thats why i have this error could you tell me which server i should provied in the server section ? im using mysql
I didn't got Extension option after connecting to Environment .Please tell me
thanks for this tutorial,
i did create simple mobile app which is contain: ID, Name, Phone number...i need to connect this data entry to our external SQL server ?
thx
How can we deploy Stored Procedure in Outsystems?
Hi! I tried to set the Database Connection and i receive the following error: "Connection String test failed: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)". I used my SQL Servername and Authentication. Any tips how to solve this?
Seems like its a connection/network error. is your database server available over internet? It has to be for what you're trying since your outsystems servers are on the cloud.
Question: So, external database can only be used as READ ONLY? Can application be made entirely with external data sources? Thanks.
Hello Yoshi, from your app in OutSystems, you're able to read and write in the external database but you're not able to change the structure example adding a new column in an existing table from an external database. For your second question, yes, you can make an entire app using external data source only.
@@OutSystemsHowTos Sounds good. Thanks.
Is this going to be offline. Without using internet data... Just access using local host..
This example is connecting to a hosted database from the OutSystems application server. You can connect to databases anywhere (localhost, through vpn, or other publicly accessible hosted db's) via direct connection. Speaking of offline, the ability to create mobile apps in OutSystems allows for an offline storage database for your mobile apps as well, so you can work with data offline on native devices if you wish to create mobile apps.
@@jonsullivan7721 how can i connect to localserve SQL Server Database?
how can i get the server ?
goto azure to create free account. In order to work one login for admin for spl server -what you use to login azure-, then the admin would craete a user to connect to the database. The admin login will not work to connect to database.