Qlikview ODBC error Teradata

[#1]

Hi Experts,

I am getting below ODBC error while trying to reload data from Teradata connection:

"SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Teradata][ODBC Teradata Driver] Major Status=0xd0000 Minor Status=0x80090303-Failure ODBC CONNECT TO TD1"

ODBC driver is working fine if I do just select. Only during reload I am getting this error.

Any help will on this please? I did some google but didnt get any resolution. I tried OLE DB as well, but that has its own set off issues which I think better to avoid for the scope of this discussion.

Thanks,

Debi

[Anil_Babu_Samineni]

Can you set this before load statement and then run

SET ErrorMode = 0;

[#3]

Thanks Anil,

I added that in script and now my script looks like below:

SET ErrorMode = 0;

ODBC CONNECT TO TD1;

SQL SELECT * FROM "PDL_BASE_VIEWS"."ADDRESS_D";

But now there is no error, but no output as well.