- What is RemoteSQL? Hide
RemoteSQL is a set of high speed data access components for Delphi database applications. It provides connectivity to different database systems like MSSQL, ORACLE, PostgreSQL, Firebird and Interbase. RemoteSQL architecture consists of two components – the Client (a Delphi component) and the Server (a Windows service). This architecture and its underlying transport layer enable it to have a high speed performance on networks with high latency.
- How does RemoteSQL work? Hide
When you connect to a database using RemoteSQL, the Client application will no longer communicate directly with the database server, and all data manipulation will be handled through the RemoteSQL Server.
RemoteSQL combines two approaches to reduce latency:
- Batch execution – It groups both the requests and the responses and sends them together in a single batch. This significantly reduces network communication and practically diminishes the negative effects of network latency.
- Data reduction – All TCP/IP communication between RemoteSQL Server and Client is compressed. Less traffic results in fewer handshakes and a lower latency impact.
- Can I run RemoteSQL Server on a virtual server? Hide
Yes, you can run RemoteSQL Server on a virtual machine.
- When trying to uninstall the Server, I get the message: “Server license is still activated. Please deactivate the license using the RemoteSQL Manager before uninstalling”. Hide
License deactivation is necessary in order for our licensing server to have the correct information about your licenses. Without this step your license can not be activated on a different machine.
If your machine has internet access, the license will be deactivated as soon as you click the Deactivate button.
In case your server doesn’t have internet access, a file for license deactivation will be created and you will need to send it to us via our support mail. Upon receiving the file, we will update the information about your license and notify you when it is ready to be used again.
- While trying to install the client I got the message: “Delphi is currently running”. Hide
In order to install the RemoteSQL Client components, you must close all RAD/Delphi instances.
- Can I have more than one RemoteSQL Server on a single machine? Hide
Yes, in order to add a RemoteSQL Server you just need to run the installation. Note that the TCP port and server name must be unique.
- Are there different installers for the Client and the Server? Hide
Yes, each of them has their own installer.
- Can I move my license from one computer to another? Hide
Yes, first deactivate the license from the Server where it is currently activated, and then activate it on the new computer.
- Can I modify the RemoteSQL Server name and/or TCP port after installation? Hide
You can modify the TCP port to any unused TCP port at any time, however, you will not be able to change the server’s name once the installation is completed. If you want to change server’s name, you need to deactivate its license (if it’s activated), uninstall RemoteSQL, and then re install it.
- My activity log is constantly filling up. I do not want to keep all the data, but I also don’t want to be deleting it manually every once in a while. Hide
Go to RemoteSQL Manager Setup and modify the Delete statistics log after option – your logs will be kept for the desired numbers of days – afterwards they will be deleted automatically.
- Export logs to Excel doesn’t work. Hide
In order to use the Export feature, you must have MS Excel installed.
- My RemoteSQL Manager Activity Log shows that some errors have occurred. How can I find more details about these errors? Hide
Please see Using RemoteSQL > Remote SQL Manager > Activity Log in http://www.gofastsoft.com/developers-guide.
- I have tried to create a Firebird demo database with CreateDemoDatabases.exe, but something is not working properly. Hide
For Firebird, the database needs to be created with iSQL (http://www.firebirdsql.org/manual/qsg10-creating.html) before it can be altered and filled with data with CreateDemoDatabases.exe.
- I cannot connect to RemoteSQL Server. Hide
First, check your
TRemoteSQL_Handlerparameters (Server, Port).
Also, make sure your RemoteSQL Server is installed on the right address and port, and you have an access to it (check the Firewall).
If you have turned SSL communication on your client on, please make sure that it is turned on at the server side as well.
- The parameters are correct, but my Client still won’t connect to the database. Hide
Make sure you have entered valid database login parameters for DBMS_DatabaseName, DBMS_ServerName, DBMS_Type, Login and Password.
Also, make sure your RemoteSQL Server is able to access DBMS_ServerName and you have entered the correct credentials (login, password).
RemoteSQL Server requires some additional libraries (dlls) for various DBMSs. Please check Getting Started > Installing/Updating/Uninstalling > Additional requirements in Developers Guide.
- I have problems creating the demo database. Hide
Check whether the user credentials you entered have the necessary permissions to create a database on the DBMS. Also check whether a database with the same name already exists – if so, choose a different name for the database.
- I have an AD/FDQuery. Can I use it with RemoteSQL? Hide
No. AD/FDQuery is designed to work with AnyDac/Firedac connection only. You should use AD/FDMemTable instead.
I have an Anydac/Firedac
MemTabledataset. After I call
ApplyUpdates, nothing is saved in the database. Hide
Make sure that AnyDac/Firedac is configured to track changes:
For detailed information, please see the chapter Using RemoteSQL > Updating Data > AnyDac/Firedac.
I am using the
OnConnectionLostevent, and I have programmed my own event. My RemoteSQL Server is available, but it doesn’t reconnect. Hide
Make sure that
AcheckConnis called inside your custom event – the method that will check the TCP connection and trigger reconnection if possible. For more information check the chapter Using RemoteSQL > OnConnectionLost event in Developers Guide.
- Is registration free? Hide
Yes, signers are never required to register or pay.
- Do I need to register an account? Hide
Yes you will need to register an email which will be used as your account registration and login details. This will be used to store your documents and track its associated usage for billing purposes.
- How can I find out which version of dlls I need to use for SSL and various DMBSs, the 32-bit or 64-bit? Hide
On 64-bit operating systems you should use 64-bit dlls and on 32-bit systems you should use 32-bit dlls.
- I am trying to connect with SSL turned on, but it is not working. Hide
First, make sure that SSL communication is activated both on the Server and the Client.
The Server and the Client require additional libraries (dlls) to be installed in order to communicate via SSL. For more information, check the chapter Getting Started > Installing/Updating/Uninstalling > Additional requirements in Developers Guide.
The Server side needs valid certificates and must have the correct path to the certificates.
See if demo certificates that we provided with installation work. They are located on “%RemoteSQL%\Examples\_DemoSSLCertificates\” with %RemoteSLQ being.
If you are trying to use SSL communication on mobile platforms (iOS, Android), make sure you have all the required libraries installed.
- What type of encryption is provided? Hide
RemoteSQL provides two types of traffic encryption:
SSL – SSL certificate, a private key and a root certificate are needed on the server side.
AES – Rijndael encryption, using auto-generated symmetric keys.
- Do I need a license for the Client? Hide
No, a license is not required for client components installation. A license is required for the Server installation only.
- What is the difference between Basic and Enterprise RemoteSQL Server? Hide
The Basic Server is limited to 20 simultaneous connections and does not provide data encryption. The Enterprise Server has no such limitations.