How to connect with an external MS SQL database in OutSystems?

Поделиться
HTML-код
  • Опубликовано: 8 ноя 2024

Комментарии • 14

  • @Nada-dm1ft
    @Nada-dm1ft 2 года назад +4

    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

  • @microsecure2612
    @microsecure2612 Год назад

    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

  • @k.kalairaja5351
    @k.kalairaja5351 Год назад

    How can we deploy Stored Procedure in Outsystems?

  • @beautyboobear
    @beautyboobear 2 года назад

    Question: So, external database can only be used as READ ONLY? Can application be made entirely with external data sources? Thanks.

    • @OutSystemsHowTos
      @OutSystemsHowTos  2 года назад +1

      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.

    • @beautyboobear
      @beautyboobear 2 года назад

      @@OutSystemsHowTos Sounds good. Thanks.

  • @katyayanisahu9811
    @katyayanisahu9811 Год назад

    I didn't got Extension option after connecting to Environment .Please tell me

  • @VMTechnologies
    @VMTechnologies Год назад

    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?

    • @OutSystemsHowTos
      @OutSystemsHowTos  Год назад

      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.

  • @coolcarlatv2944
    @coolcarlatv2944 2 года назад

    Is this going to be offline. Without using internet data... Just access using local host..

    • @jonsullivan7721
      @jonsullivan7721 2 года назад

      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.

    • @giovannidelorenzo2596
      @giovannidelorenzo2596 Год назад +1

      @@jonsullivan7721 how can i connect to localserve SQL Server Database?

  • @njd4572
    @njd4572 2 года назад

    how can i get the server ?

    • @Cordycep1
      @Cordycep1 2 года назад

      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.