Hi guys
I have something trouble in qlikview. I use qlikview10 student version for practise and connect it to mysql database in other PC that I use as a database server. for information,totaly I put more than 600.000 row data in my database. after I finish do some chart in qlikview, I try to distribute the file to other PC that have connection to the same database with my database mysql server. but when I run my file on other PC there is an error show from that application. massage error said that my database is not recognize. eventhough i've set the DNS MYSQL connection in that PC.
this is my sample script. 2 select query sample from 5 query that I have.
ODBC CONNECT32 TO qlickview (XUserId is FRNBXQJOEbbCP, XPassword is bWIESQRNBTbSGYdNHbbGHGB);
LOAD Activity,
`Daily_Actual`,
Location,
`District_Code`,
Period;
SQL SELECT *
FROM `qv-bdms-ma`.coalsummary;
LOAD Activity,
`Daily_Plan`,
Mtd,
Ytd,
Location,
Period,
`District_Code`;
SQL SELECT *
FROM `qv-bdms-ma`.coalsummaryplan;
CAN YOU GUYS HELP ME?
thank before....
basslaboriel
