topic Re: ErrorCode 7 when connecting to data source in QlikView

ErrorCode 7 when connecting to data source

Thu, 11 Aug 2011 09:16:07 GMT

Hi, wondering if someone can help we decode the following error when I connect to a PostgressSQL30 datawarehouse... and ideally let me know if there is a solution (I am using ODBC)

SQL##f - SqlState: 22P05, ErrorCode: 7, ErrorMsg: ERROR: character 0xc59e of encoding "UTF8" has no equivalent in "WIN1252";

Error while executing the query

SQL SELECT *

FROM datawarehouse."public".sale

Re: ErrorCode 7 when connecting to data source

Emmanuelle__Bustos — Tue, 08 Jan 2013 18:50:58 GMT

Hi friend did you find a solution for this? I have the same problem but with character 0xefbfbd using Postgre 9.

Re: ErrorCode 7 when connecting to data source

Emmanuelle__Bustos — Tue, 08 Jan 2013 22:31:45 GMT

Hi We fix the problem with a ODBC Driver Unicode x64 for Postgre.

Re: ErrorCode 7 when connecting to data source

Mon, 13 Jan 2014 18:04:10 GMT

what is the EtA on this fix? I am having same issue

Re: ErrorCode 7 when connecting to data source

Emmanuelle__Bustos — Mon, 13 Jan 2014 22:59:54 GMT

Is a old issue the only thing i remember is using ODBC Driver Unicode x64 for Postgre.

Re: ErrorCode 7 when connecting to data source

Mon, 13 Jan 2014 23:02:47 GMT

my issue appears to be bad data in one of the fields in the postgres table. I commented out that field and it worked. Hard part is finding the field causing it. One by one commenting out, reloading. Found it finally.

Debbie Pyykkonen

Archipelago IS, LLC | Director, Business Analytics| www.archipelagois.com

303 S. Broadway, Suite 200-169 | Denver, Colorado 80209

Twitter | LinkedIn | Facebook |

(: 303-304-6425 | *: dpyykkonen@archipelagois.com

Check out our Workshops and Events!

Download QlikView for FREE!

Re: ErrorCode 7 when connecting to data source

Emmanuelle__Bustos — Mon, 13 Jan 2014 23:11:04 GMT

If you look the original issue is related with one specific field as well, i think we had it the same so try using ODBC Driver Unicode x64 for Postgre. It's only thing i know that can help you because this x64 driver does supports the character error.

Re: ErrorCode 7 when connecting to data source

Mon, 13 Jan 2014 23:16:35 GMT

thank you. I will give that a try.

Debbie Pyykkonen

Archipelago IS, LLC | Director, Business Analytics| www.archipelagois.com

303 S. Broadway, Suite 200-169 | Denver, Colorado 80209

Twitter | LinkedIn | Facebook |

(: 303-304-6425 | *: dpyykkonen@archipelagois.com

Check out our Workshops and Events!

Download QlikView for FREE!