Unicode Database Upgrade (SQL Financial Accounting 5): Difference between revisions
From eStream Software
Line 95: | Line 95: | ||
===3. Access violation at address....in module msxml6.dll | ===3. Access violation at address....in module msxml6.dll=== | ||
::[[File:Core-Unicode_22.jpg]] | ::[[File:Core-Unicode_22.jpg]] | ||
<br /> | <br /> | ||
:<big>'''Solution:''' | :<big>'''Solution:''' | ||
:Retry to upgrade the database again.</big> | :Retry to upgrade the database again.</big> | ||
<br /> | |||
===4. The following error(s) have occured invalid class typecast=== | |||
::[[File:Core-Unicode_24.jpg]] | |||
<br /> | |||
:<big>'''Solution:''' | |||
:Download the correct setup-x86 file (32 bits).</big> | |||
<br /> | <br /> | ||
Revision as of 03:27, 11 November 2016
Must Do List
- 1. Backup all the databases before upgrade.
- 2. Remove/Uninstall the previous Firebird version installed, ie. 1.5, 2.0, 2.5.
- 3. Install Firebird 3.0.1.
- 4. SQL Financial Accounting 5 (Version: 5.2016.790.737).
- 5. Check the System Locale in Regional setting.
Important: To ensure the encoding conversion correctly, please ask the user the following questions: 1. Do you key-in any Chinese or other than English words in the database?. 2. What type of language input using? Simplified or Traditional Chinese?
- 6. Check Local C drive free spaces (follow the Windows drive). Recommended 25GB free space or more.
- 7. Restore the database from the backup file.
Unicode Database Upgrade Steps
- 1. Execute the SQL Financial Accounting 5 (Version: 5.2016.790.737).
- 2. Restore the database from the backup file.
- 3. Login the database restored.
- 4. Click on Yes to confirm proceed the database upgrade.
- 5. Choose an appropriate encoding. Select Default - Windows 1252 ANSI if your server current language for non-Unicode programs is "English (United States)".
- 6. For more info about choosing a correct encoding, see the check list table below.
No. SQL encoding Regional setting (non-Unicode language) 1. Defaul-Windows 1252 ANSI All English, ie. English (United Kingdom), English (Malaysia), English (Singapore), etc. 2. Simplified Chinese 简体中文 Chinese Simplified ONLY, ie. Chinese (Simplified, China), Chinese (Simplified, Singapore) 3. Traditional Chinese 繁体中文 Chinese Traditional ONLY, ie. Chinese (Traditional, Hong Kong SAR), Chinese (Traditional, Taiwan) 4. Firebird NONE character set NONE encoding (Not recommended to use). For Firebird programmer use. 5. Database Encoding Diagnosis (For Chinese only To analyse the encoding (for Chinese character) able to read by your eyes.
Note: If you have click on No, you will get prompt an operation aborted. Press Ok to exit the message.![]()
- 11. Database upgrade successfully, Old Database link will be DROP and New Database link will be ADD (new database file created automatically).
- 12. Re-login with New Database. Usually you can identify the new database at the remark, eg. Unicode from Old Database filename.
Example: OLD database filename: ACC-0003.FDB (DROP) NEW database filename: ACC-0001.FDB (ADD)
At the new database file (ACC-0001), you will see a remark displayed as Unicode from ACC-0003.
Possible Error and Solution
1. Unsupported on-disk structure for file (found 11.2, support 12.0)
- Solution:
- Restore the database from the backup file.
2. Unable to find vendor library of database with ODS version 11.2
- Solution:
- Restore the database from the backup file.
3. Access violation at address....in module msxml6.dll
- Solution:
- Retry to upgrade the database again.
4. The following error(s) have occured invalid class typecast
- Solution:
- Download the correct setup-x86 file (32 bits).
Advantages of Unicode Database
1. No longer need to set your system locale
- You able to read, key-in and store the Chinese Simplified characters without change the system locale.
2. Multi-Language Support in Single Database
- 2.1 Capable to store different language characters (ie. English, Simplified Chinese, Traditional Chinese, Vietnamese, Japanese, Arabic, etc...) in a database.
3. Free to search any characters in single database
Optional: Database Encoding Diagnosis (For Chinese only)
- If the database has failed to upgrade, then you have to use this option to diagnose the database. Reason fail to upgrade, it could be due to contains UTF-8 coding which is copy from others source eg. internet webpage.