topic Re: Script Error database in QlikView

Script Error database

master_student — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 08 Jun 2016 12:22:52 GMT

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

- Marcus

migueldelval — Wed, 08 Jun 2016 12:47:42 GMT

Hi Master Student,

Try this:

SELECT *

from "RECHARGE_PM.DUMP_RETAILER";

Regards

Miguel del Valle

ramasaisaksoft — Wed, 08 Jun 2016 12:56:25 GMT

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.