CODEWITHSUNDEEP
postgresqlodbcms-access-2007datasource
Blueice
Blueice

Reputation: 143

ODBC Call failure from Microsoft Access to PostgreSQL -Client Encoding Mismatch

i tried to create a linked table from Microsoft Access (2007) to PostgreSQL (9.0) in Windows 7. When I tried to linked table as follows:

1)Select link to the data source by creating a linked table

2)Machine Data Source in 'Selectr Data Source' pop up.

3)Select the PostgreSQL DB visible which ends in error:

ODBC call failed
Clientencoding mismatch(#214).

Could you please help?

Upvotes: 0

Views: 2038

Answers (1)

ta.speot.is
ta.speot.is

Reputation: 27214

I used Google to find this.

It seems that there is some problem with PostgreSQL 8.1 and the encoding names: see this post or google. It looks that UTF8 used by default with the new Postgres is not compatible with old ODBC drivers. I am not sure where the problem really is, but a quick fix is to change default encoding for the user connecting to the database:

alter user <user> SET client_encoding to LATIN1;

Upvotes: 1

Related Questions