Why are my database queries failing in GMS Communication Server when I have configured everything correctly?

  1. Home
  2. Knowledge Base
  3. GMS
  4. Why are my database queries failing in GMS Communication Server when I have configured everything correctly?

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

Was this article helpful?

Related Articles