Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

Connecting elastic search ODBC files in Alteryx - esODBC parsing_exception line mismatched

APIUserOpsGiri
7 - Meteor

I'm able to establish a connection but when I test a simple select * query , I get this error as below 

 

Giridharan_0-1671474775178.png

 

I tried the most common solution to switch oleodbc and changing the byte count.. in my case nothing seems to be working.

 

4 REPLIES 4
PanPP
Alteryx Alumni (Retired)

Hi @APIUserOpsGiri 

 

1) Are you using the generic ODBC connection method to connect to your data?

 

2) Are you able to select the tables directly from the Visual Query Builder, and then test the query in the SQL Editor tab?

 

 

 

 

APIUserOpsGiri
7 - Meteor

1) yes, I'm using generic ODBC connection

2) no I can't.. I can see the table names on "Tables" but only the database name on "Visual Query Builder".

When I run any basic query on sql editor..is when I receive the error above

 

APIUserOpsGiri
7 - Meteor

The solution was simple, as I did not have access to some tables. Otherwise it works great.

PanPP
Alteryx Alumni (Retired)

@APIUserOpsGiri 

 

Glad you were able to resolve the issue.