client encoding mismatch

["Brian J. Erickson" <ericksbr@xxxxxxxxxxxxxxx>]

Hello,

I am getting the following error:
    client encoding mismatch
    State:22003,Native:214,Origin:

Using the function "SQLDriverConnect"
with the connection string
"DSN=PostgreSQL;Servername=server;UID=user;Password=xxxxxx;Database=database
;"

OS: Windows 2000
Postgresql Server 8.1.3
ODBC: 7.03.01.14 'PostgreSQL' driver
(Want to retain, because I am also accessing a 7.x database)

I have done the following:
SET CLIENT_ENCODING TO 'SQL_ASCII';

but the encoding keeps coming back as "UTF8" or "WIN1251"

Please help.

Brian


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly