I am new to the Qliksense and am getting the error while loading data from MYSQL DB to Qliksense app.
after getting this error i have checked there is no Syntax error in Script but after clicking on Load data its throwing this error and also i have deleted the table from Qlik sense app but still its throwing the same error with same table name after deleting table aslo.
Could you please help me on this issue.
Thank you in advance.
The script what i am using is as follows.
LIB Connect to 'SG_DATASOURCE'
SQL SELECT ID,
while clicking on load data am getting the error:
SQLSTATE:3700,Error code: 1064,ErrorMsg:[MYSQL][ODBC5.3(A) dRIVER][mysql-5.7.19-log]
Here i am loading the table from MYSQL DB to Qliksense.
Colud please check and help me on this issue.
its there in the script but its not working ,its throwing same error.
is there any issue with single quotes i found some posts like we need to use
LIB Connect to `SG_DATASOURCE`
SQL SELECT ID,
is the above script is correct or is there any mistakes.
I'd recommend you to comment that script and select data from the table again.
When you copy script from web-sites, quotes might be changed. You need to replace them with a normal ones, which you can type on your keyboard.
Although, it won't be an issue if you select data from SQL table again. It will also add all necessary semi colons.
Be sure to check your SQL connector log in this case, as it will likely have more detailed information. We are simply returning the message being provided by the SQL driver/connector you are using...