QPR Knowledge Base 2014.1

Supported Databases

Supported Databases

Previous topic Next topic  

Supported Databases

Previous topic Next topic JavaScript is required for the print function  

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

Access: INT, FLOAT, VARCHAR, TEXT, MEMO, 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 Access 2007

 

32-bit (x86)

Microsoft Windows

For standalone use only.

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

 

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

 

Note about Oracle character sets: The national character set in Oracle must always be AL16UTF16, and the database character set must be AL32UTF8.