Detailed Description and Symptoms
You encounter one of the following errors when attempting to start a WP or CP:
U0029104 Invalid CODESET Parameter in SQLDRIVERCONNECT string.
orU0003531 Error while checking data source (e.g. code conversion or driver problem, see log file).
Check the NLS Character Set of the Oracle database and of the Oracle Client.
This message indicates that the database and client are using two different NLS Character Sets. Confirm that the following match in the log file:
U0003535 DB INFO: 'OCI_NLS_CHARACTER_SET = WE8ISO8859P15'
U0003535 DB INFO: 'NLS_CHARACTERSET = WE8ISO8859P15'
*) The NLS_CHARACTERSET must be either WE8ISO8859P15 or WE8ISO8859P1. If it is not, have your DBA set it to one of those.
*) Your Client will need to use the same NLS Characterset as your Database. This can be specified in the your SQLDRIVERCONNECT= setting in ucsrv.ini by adding the following after your SQLDRIVERCONNECT= setting and being sure that CODESET= is either WE8ISO8859P15 or WE8ISO8859P1 and matches your database characterset. Below is an example of this: