Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

ErrorCode 7 when connecting to data source

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

7 Replies
Emmanuelle-Bustos
Valued Contributor

Re: ErrorCode 7 when connecting to data source

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

Emmanuelle-Bustos
Valued Contributor

Re: ErrorCode 7 when connecting to data source

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

Not applicable

Re: ErrorCode 7 when connecting to data source

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

Emmanuelle-Bustos
Valued Contributor

Re: ErrorCode 7 when connecting to data source

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

Not applicable

Re: ErrorCode 7 when connecting to data source

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!

Emmanuelle-Bustos
Valued Contributor

Re: ErrorCode 7 when connecting to data source

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.

Not applicable

Re: ErrorCode 7 when connecting to data source

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!

Community Browser