Discussion Board for collaboration related to QlikView App Development.
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:
SQL SELECT *
The same problem with ODBC connect.
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
View solution in original post