ODBC offers an info type allowing the client application to query the driver on what catalog separator to use. ES uses : with the . having a special semantic with JSON (nested) docs.
Nevertheless, some applications either don't bother making the proper info call (ex. Alteryx) or disregard the response if they do (ex Crystal Reports).
A workaround could consist of:
no longer advertising support for catalogs; and/or
rewrite the query to correct the use of the wrong character.
ODBC offers an info type allowing the client application to query the driver on what catalog separator to use. ES uses
:with the.having a special semantic with JSON (nested) docs. Nevertheless, some applications either don't bother making the proper info call (ex. Alteryx) or disregard the response if they do (ex Crystal Reports).A workaround could consist of: