community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Input Tool - ODBC - Error Opening...No Columns Returned

Hello All,

 

I am a new Alteryx user. 

I am trying to fetch data from db by running a simple query i.e. "Select * from tablename" build using "Visual Query Builder" but an error is coming.

The error is :

Error Opening : "Select... " No columns Returned.

 

 

Any idea what can be the issue ?

 

Thanks

Alteryx
Alteryx

Which database are you tryining to connect to?

Which driver/version are you using? 

Is the user allowed to query the data?

Hello William,

 

Database : IBM DB2

Driver : ODBC

Yes the user is allowed to query the data.

Alteryx
Alteryx

Are you able to query your DB2 instance from your computer through ODBC with another querying tool ?

Are you using the latest version of the driver ? 11.1

In 32 or 64 bit ?

 

Labels