QPR Knowledge Base 2017.1

Supported Databases

Supported Databases

Previous topic Next topic No directory for this topic  

Supported Databases

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this 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 2008

Express
Workgroup
Standard
Web
Developer
Enterprise

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

Microsoft Windows

 

Microsoft SQL Server 2008 R2

Express
Workgroup
Standard
Web
Developer
Enterprise

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

Microsoft Windows

 

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

 

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