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

Issue



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

Environment



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



Cause



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".


Solution



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.

Attachments

SecurityExpressions-4.0-hf1.zip (6.5 MBytes)

Legacy ID



34853


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


Terms of use for this information are found in Legal Notices