QPR Knowledge Base 2019.1

Supported Databases

Supported Databases

Previous topic Next topic  

Supported Databases

Previous topic Next topic  

The following databases are supported by the QPR applications:

 

1. Generic Database Requirements

 

MDAC version 2.7 or later
Support for the following data types:
Oracle: NUMBER, NVARCHAR2, RAW, NCLOB, BLOB, DATE
SQL Server: INT, FLOAT, NVARCHAR, NTEXT, VARBINARY, IMAGE, DATETIME
Support for Unicode character set.

 

2. Version and Driver Requirements

 

Note that only Windows versions of multi-platform databases are supported. However, non-Windows versions may also work, but the functionality cannot be guaranteed and you must verify the functionality by yourself in such cases.

 

Your database must meet both the generic database requirements and the DBMS/edition requirements listed below. Database compatibility can be tested with the QPR Configuration Manager and it should be done every time a new database is taken into use.

 

Make sure that the database is using a Unicode character set.

 

Only Windows versions of the databases listed below have been verified and are officially supported by QPR. Database vendors may provide compatibility for alternative operating systems like Linux, UNIX, AIX, and HP9000. Contact your Database vendor and QPR to learn more about alternative operating systems.

 

 

Database Management System

Edition

Architecture

Platform

Additional Notes

Microsoft SQL Server 2012

Express
Standard
Web
Developer
Enterprise

32-bit (x86)
64-bit (x64)

Microsoft Windows

 

Microsoft SQL Server 2014

Express

Standard

Web

Developer

Enterprise

32-bit (x86)

64-bit (x64)

Microsoft Windows

 

Microsoft SQL Server 2016

Express

Standard

Web

Enterprise

Developer

64-bit (x64)

Microsoft Windows

 

Microsoft SQL Server 2017

Express

Standard

Enterprise

Developer

64-bit (x64)

Microsoft Windows

 

Oracle Database 11g

Personal Edition

Standard Edition One
Standard Edition
Enterprise Edition

32-bit (x86)
64-bit (x64)

Microsoft Windows

Verify platform-specific installation, supported drivers, supported patch sets, and supported clients with QPR Customer Care