Document Actions

Database & OS Support

Multiple database connectivity with one database access layer

However many RDBMSs you may use, due to the unique Querix Dynamic SQL and Data Type translator, you only need one version of your data access layer, which means reduced maintenance and less administration.

“Querix makes migration across different database engines as easy as child’s play. Its speed and reliability are really amazing. Querix is the best option for making our legacy systems attractive and it has increased the life-cycle of our programs.” Daniel Rubino, Information Systems Manager, Drogueria Uruguay S.A.

'Hydra4GL' supports 18 of the major platforms and operating systems, as well as most of the major database vendors. It provides dynamic translation from Informix-style SQL and datatypes to the target database vendor's style. The following databases are currently supported:

Informix IDS/SE/OnLine
Oracle 8i/9i/10g
Microsoft SQL Server
IBM DB2
Pervasive
MySQL (via ODBC and generic Dynamic SQL translation)
PostgreSQL (via ODBC and generic Dynamic SQL translation)
Other databases accessed via ODBC without Dynamic SQL translation

Querix is currently woing to provide native connectivity and dynamic SQL & datatype translation for a number of other databases. These are currently supported without dynamic SQL translation:

MAX-DB (SAP-DB)
Adabas
Sybase
Xbase

'Hydra4GL' can also switch databases at runtime. This completely new feature allows a single 4GL application to connect to any supported database without the need for recompilation.

Database and OS Versions Supported in 'Hydra4GL' 4.3


Linux 32/64bit	8i+	8	8.5	ODBC	ODBC	Y	Y	N	Redhat 7.3+, SuSe 7.2+, Mandrake 8+
Windows 32/64bit	8i+	8	8	ODBC	ODBC	Y	Y	2000+	NT 4/2000/2003/ XP/Vista
Sun (64)	8i+	8+	N	ODBC	ODBC	Y	Y	N	Solaris 8+
Sun (32)	8i+	8+	N	ODBC	ODBC	Y	Y	N	Solaris 7+
Sun (Intel)	8i+	N	N	ODBC	ODBC	Y	Y	N	Solaris 8+
UnixWare	<8.1.5>	N	N	ODBC	ODBC	Y	Y	N	7.1.x
OpenServer	N	N	N	ODBC	ODBC	Y	Y	N	5.0.x
DEC	8i+	N	N	ODBC	ODBC	Y	Y	N
AIX (64)	8i+	8+	N	ODBC	ODBC	Y	Y	N	5L
AIX (32)	8i+	8+	N	ODBC	ODBC	Y	Y	N	4.3.3+
HP (64)	8i+	8+	N	ODBC	ODBC	Y	Y	N	11.x+
HP (32)	8i+	8+	N	ODBC	ODBC	Y	Y	N	10.20+
HP (Itanium)	9i+	8+	N	ODBC	ODBC	Y	Y	N	11iv2+
NCR	N	N	N	ODBC	ODBC	Y	Y	N