topic Re: Qlikview ODBC error Teradata in QlikView

Qlikview ODBC error Teradata

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview ODBC error Teradata

Anil_Babu_Samineni — Wed, 03 May 2017 12:47:24 GMT

Can you set this before load statement and then run

SET ErrorMode = 0;

Re: Qlikview ODBC error Teradata

Wed, 03 May 2017 14:29:00 GMT

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.