oledb or odbc connect to mysql (with qlikview 12)

[federicacci]

Good Morning,

i have a problem with the connection to mysql.

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;User ID=myid;Data Source=ECS_64;Extended Properties="DATABASE=mydatabase;DSN=ECS_64;OPTION=0;PORT=3306;SERVER=srvecs;UID=myuid;"];

In debug, i see that the connection is ok but the Query is in error.

This is the error that i view in debug:

Script Error

SQL SELECT *

FROM tablename;

The same problem with ODBC connect.

Thank you.

Federica

[Clever_Anjos · Accepted solution]

Please use a simple query as a test

SQL SELECT 1;

I´m guessing that your query is returning two columns with same name, that triggers that error