Script Error database

[master_student]

Hello Community,

I am trying to execute a very simple query in qlik view

here's my script :

OLEDB CONNECT32 TO [xxx] (XPassword is xxx);

SELECT  *

from RECHARGE_PM.DUMP_RETAILER;

here's the error script I get : (without any explanation)

As a remark, the connexion and the query work fine on Toad . In QV, the connexion work but the query no.

Any idea about the cause of this issue please.

Thanks

[marcus_sommer]

Have you built the statement with the wizard (connect and select button)?

- Marcus

[migueldelval]

Hi Master Student,

Try this:

SELECT  *

from "RECHARGE_PM.DUMP_RETAILER";

Regards

Miguel del Valle

[ramasaisaksoft]

Hi Master,

1)First u can OLEDB connect the Database, and reload application(Don't write any load statement)

if it is not throwing any error no issue else ur OLEDB issue.

2)If your connection sucess

select the table through database (Don't write code manually by hand).

i hope it will close ur issue.