We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

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

Giridharan
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
Alteryx

Hi @Giridharan 

 

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?

 

 

 

 

Giridharan
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

 

Giridharan
7 - Meteor

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

PanPP
Alteryx
Alteryx

@Giridharan 

 

Glad you were able to resolve the issue.