My disk was full because the USERS Tablespace was bigger than 17Gb. Here are the steps to shrink an Oracle Tablespace:
By default, a PostgreSQL server doesn't allows external connections.
In this article we will explain how to create a migration trace to troubleshot problems:
The Windows parameters for configuring PostgreSQL server are located in two configuration files. A few parameters in these files have to be adjusted before the server can be used in production.
Pg_hba.conf a.k.a. PostgreSQL Client Authentication Configuration File:
The purpose for this file is to identify all of the machines that are able to access PostgreSQL remotely.
SQL Server databases has its own date format.
While configuring MySQL for using innodb table handler, the following settings (in the my.ini file) have impact on performance:
If we choose the default installation for PostgreSQL, the client authentications are created as trust connection. So if we trying to connect to database by using a wrong password the connection will be established. To avoid this we can edit the pg_hba.conf and change the column METHOD from 'trust' to 'password'. After changing we must restart Database Server.
Magic eDeveloper advertises multi-dbms support through “gateways”. You design the app once and simply configure the backend gateway to one of many. However, if the application is designed for ISAM (Btrieve), then getting it to run against a SQL backend has many challenges.
This happens if you do not have the MS SQL Server binn directory or the Btrievebin directories in your path.