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. |
Problem
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:
- 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.
Attachments
|
|
Legacy ID
34853
Article URL http://www.symantec.com/docs/TECH29767
Terms of use for this information are found in Legal Notices
Thank you.