|
|
Supported Databases |
|
|
|
||
|
Supported Databases |
|
|
|
|
Supported Databases
|
|
|
Supported Databases |
|
|
|
||
|
Supported Databases |
|
|
|
|
|
|
||
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 |
32-bit (x86) |
Microsoft Windows |
|
Microsoft SQL Server 2008 |
Express |
32-bit (x86) |
Microsoft Windows |
|
Oracle Database 10g |
Express Edition |
32-bit (x86) |
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 |
32-bit (x86) |
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.