Why are my database queries failing in GMS Communication Server when I have configured everything correctly?
I have configured a custom ODBC list in GMS Communication Server, and I can see in the WWW server log that my SQL queries are executed, but a result is not returned. Why might this be?
When GMS Communication Server queries an external database, it will perform a case sensitive search. This would mean that if your query is for an address User@Test.dom but the database contains email@example.com, the result would be that no match was found.
To resolve this, GMS Communication Server can be forced to perform case insensitive searches. To do this, you need to set a user level variable of
Which should resolve the issue.
Keywords:Custom ODBC case sensitive