More detail Documentation

[Romero_Parra_Alejandro]

@Wagner R. Landgraf

RemoteDB provides data through HTTP(S) protocol. If you want your data encrypted, use the common approach for HTTP requests which is secure it (HTTPS) using a certificate. You can get free ones these days, here is a blog post about it:

https://www.tmssoftware.com/site/blog.asp?post=454

RemoteDB is a "quick" way to turn your database into the cloud and make the connection abstract through HTTP (instead of connecting directly to the database). But that means the SQL is provided by your client, and anyone who has credentials to your server is able to execute arbitrary SQL statements.

If security is a high concern of you, you should create a server with business logic, with limited access to clients, which then you should be using XData which is a standard REST/JSON server.

With RemoteDB you just code your application as you would be coding a client-server application. The approach is the same. Drop the query component, the connection, write your SQL and execute it.

About XData, there is the documentation and several videos in our Youtube channel and post in our blog about its usage, besides some demos which are installed in the package.

Hello Again Wagner

I saw the link above, I did not follow at all since my Production Server already had the certificate validated with Goddady, so that server is already running IIS7 and it's a Webserver. I used another methods to incorporate the certificate into Windows OS.

What I did only was to configure a new port with the TMSHttpConfig only and change the ServerUrl property in both Client and Server to server the "https" prefix and the new port configured with TMSHttpConfig.

I tested and it works, I don't know yet if data is traveling secure, I assume it does, but I have not use a sniffer tool yet in order to check this point.

Can you please tell me if the BOLD instructions above was enought to migrate my projects [Server and App Client] into https????

Thanks a lot

[wlandgraf (Wagner Landgraf)]

Yes, they are. You can simply try to do a request to your server using HTTPS protocol. If it works, all is fine.

Actually if you changed your ServerUrl from http to https, your HTTP-only server should not be working anymore. You can test it, you probably won't be able to connect using HTTP, just HTTPS. So you're fine.

[Romero_Parra_Alejandro]

@Wagner R. Landgraf

Yes, they are. You can simply try to do a request to your server using HTTPS protocol. If it works, all is fine.
Actually if you changed your ServerUrl from http to https, your HTTP-only server should not be working anymore. You can test it, you probably won't be able to connect using HTTP, just HTTPS. So you're fine.

Thanks for everything Wagner

I will buy the suite at the middle of this week, so I will not say goodbye to you since I will ask another fetaures near at the future

Have a great Weekend, by the way It seems I'am trying to figure out the simplicity of RemoteDB and that's partially what I need for now.

Yesterday I modified slighly the RemoteDB server application in order to change the default "username" and "password". And all I need was a little time to research at forum and the examples.

------------------------------------

procedure TServidorWSF.StartServer;

begin

     // just try to connect in the database before starting the server

     // to make sure the connection string is correct. If not, an exception will be raised

     CreateIDBConnection.Connect;

     FServer := THttpSysServer.Create;

     try

          FModulo := TRemoteDBModule.Create(edServerUrl.Text, TDBConnectionFactory.Create(

               function: IDBConnection

               begin

                    Result := CreateIDBConnection;

               end

               )

          );

          // Establecemos el usuario y la contraseña para el cliente

          FModulo.UserName := '---------------------------';

          FModulo.Password := '--------------';

          // Agregamos el módulo

          FServer.AddModule(FModulo);

          // Iniciamos el servidor

          FServer.Start;

     except

          // Liberamos el servidor

          FreeAndNil(FServer);

     raise;

     end;

end;

------------------------

Regards