Web service cannot send notifications when database is case sensitive

Article:TECH29767  |  Created: 2007-05-10  |  Updated: 2007-08-17  |  Article URL http://www.symantec.com/docs/TECH29767
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Using a case-sensitive SQL database, I run a Web services audit with a notificaton enabled.


Build: 4.0 Build 416
Application: SecurityExpressions Console
SecurityExpressions Server Host: Windows* 2003
Database: SQL 2005


The audit results in the following error:

Database connection error
Error[42s22] [Microsoft] [ODBC SQL Server Driver][SQL Server] Invalid column
Name 'NotificationName'

The actual column name is "notificationName".


A hotfix has been created to correct this problem. The hotfix file, SecurityExpressions-4.0-hf1.zip, is located to the right of this article. To install this hotfix:
  1. Unzip the file.
  2. For SecurityExpressions Server:
    1. Stop IIS.
    2. Copy seserver4.dll to C:\Inetpub\wwwroot\seserver\bin.
    3. Restart IIS.
  3. If the installation directory is different from default, change directory above accordingly.


SecurityExpressions-4.0-hf1.zip (6.5 MBytes)

Legacy ID


Article URL http://www.symantec.com/docs/TECH29767

Terms of use for this information are found in Legal Notices