I can load data using SQL SELECT for both databases . For infobright , I change as suggested , it isn't ok . For SQLserver , the first time is ok . I reopened it that error message . What is missing in using DD ? For SQLSERVER I must set connection again .
Now I change to another computer . It is same for SQLServer . It seems this file have gone wrong .I must rebuild a new .qvw file and copy all script to it , after that ,It is ok. I think the setdirect have some problems.
SQL##f - SqlState: 37000, ErrorCode: 1064, ErrorMsg: [MySQL][ODBC 5.2(a) Driver][mysqld-5.1.40]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"bi_psidw.dim_stockproerty"' at line 1
---- I reload the same .qvw file in another computer . It is ok . In this computer I find