Using Adaptive Server Anywhere (ASA) driver version 7 and the ODBC version 3, in a heterogeneous query between Oracle and ASA 7, the concatenate function fails with the following error message:
'[Microsoft][ODBC Microsoft Access Driver] Invalid use of vertical bars in query expression 'Left([Report Pack MPG 400 Main Range Basic View].[PackSeason ID], 1) || [Report Pack MPG 400 Main Range Basic View].[Pack ID]'.'
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center