Question
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?
Answer
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 user@test.dom, 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
odbcforcecase=1
Which should resolve the issue.
See Also:
Keywords:Custom ODBC case sensitive