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.|
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
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:
- Unzip the file.
- For SecurityExpressions Server:
- Stop IIS.
- Copy seserver4.dll to C:\Inetpub\wwwroot\seserver\bin.
- Restart IIS.
- If the installation directory is different from default, change directory above accordingly.
Article URL http://www.symantec.com/docs/TECH29767