|
||
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 |
32-bit (x86) |
Microsoft Windows |
|
Microsoft SQL Server 2008 R2 |
Express |
32-bit (x86) |
Microsoft Windows |
|
Microsoft SQL Server 2012 |
Express |
32-bit (x86) |
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 |
32-bit (x86) |
Microsoft Windows |
Verify platform-specific installation, supported drivers, supported patch sets, and supported clients with QPR Customer Care |