QPR Knowledge Base

Supported Databases

Hide Navigation Pane

Supported Databases

Previous topic Next topic No expanding text in this topic  

Supported Databases

Previous topic Next topic JavaScript is required for expanding text Mail us feedback on this topic!  

Comments (...)

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.

 

Note that only 32-bit ODBC drivers are supported with all supported databases.

 

Database Management System

Edition

Architecture

Platform

Additional Notes

Microsoft Access 2003

 

32-bit (x86)

Microsoft Windows

For standalone use only.

Microsoft Access 2007

 

32-bit (x86)

Microsoft Windows

For standalone use only.

Microsoft SQL Server 2005

Express
Workgroup
Standard
Enterprise

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

Microsoft Windows

 

Microsoft SQL Server 2008

Express
Workgroup
Standard
Web
Developer
Enterprise

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

Microsoft Windows

 

Oracle Database 10g

Express Edition
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

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.

 

 

Comments (...)