How to Shrink an Oracle Tablespace

[fa icon="calendar'] Feb 24, 2008 3:22:00 PM / by Mertech Data Systems, Inc. posted in Databases

My disk was full because the USERS Tablespace was bigger than 17Gb. Here are the steps to shrink an Oracle Tablespace:

Read More [fa icon="long-arrow-right"]

External Connections for a PostgreSQL Server

[fa icon="calendar'] Feb 24, 2008 2:08:00 PM / by Mertech Data Systems, Inc. posted in Databases

By default, a PostgreSQL server doesn't allows external connections.

Read More [fa icon="long-arrow-right"]

Creating a Migration Trace from Within Flex2SQL

[fa icon="calendar'] Feb 24, 2008 1:58:00 PM / by Mertech Data Systems, Inc. posted in DataFlex

In this article we will explain how to create a migration trace to troubleshot problems:

Read More [fa icon="long-arrow-right"]

Configuring PostgreSQL

[fa icon="calendar'] Feb 24, 2008 12:48:00 PM / by Mertech Data Systems, Inc. posted in Databases

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.

Read More [fa icon="long-arrow-right"]

How to Login to Server and Call a DataFlex Program

[fa icon="calendar'] Feb 24, 2008 11:22:00 AM / by Mertech Data Systems, Inc. posted in DataFlex

SQL Server databases has its own date format.

Read More [fa icon="long-arrow-right"]

Using INNODB in MySQL

[fa icon="calendar'] Feb 24, 2008 11:06:00 AM / by Mertech Data Systems, Inc. posted in Databases

While configuring MySQL for using innodb table handler, the following settings (in the my.ini file) have impact on performance:

Read More [fa icon="long-arrow-right"]

Client Authentication in PostgreSQL

[fa icon="calendar'] Feb 24, 2008 10:24:00 AM / by Mertech Data Systems, Inc. posted in Databases

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.

Read More [fa icon="long-arrow-right"]

Reasons a Magic eDeveloper App Can't be Multi-DBMS

[fa icon="calendar'] Feb 20, 2008 2:47:00 PM / by Mertech Data Systems, Inc. posted in Btrieve

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.

Read More [fa icon="long-arrow-right"]

Login Button is Grey for BTR2SQL Oracle Evaluation

[fa icon="calendar'] Feb 20, 2008 2:24:00 PM / by Mertech Data Systems, Inc. posted in Btrieve

This happens if you do not have the MS SQL Server binn directory or the Btrievebin directories in your path.

Read More [fa icon="long-arrow-right"]

Cannot Open Flex2SQL at the Second Time

[fa icon="calendar'] Feb 19, 2008 11:16:00 AM / by Mertech Data Systems, Inc. posted in DataFlex

After downloading the setup and installing it, you can open and migrate tables properly using Flex2SQL. But if closing it and trying to open it again you receive the message below and can't more open the Flex2SQL:

Read More [fa icon="long-arrow-right"]

Subscribe to Email Updates