Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

oledb or odbc connect to mysql (with qlikview 12)

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

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

Re: oledb or odbc connect to mysql (with qlikview 12)

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

1 Reply
Highlighted
Employee
Employee

Re: oledb or odbc connect to mysql (with qlikview 12)

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