Re: Postgresql with Access 97

You can try SQL_ASCII encoding in the following way in PostgreSQL:

CREATE DATABASE test
WITH ENCODING='SQL_ASCII';

In the past I have used this good tool for conversion between Access and
PostgreSQL. You can give it a try as well

http://www.data-conversions.net/access-to-postgresql-pro-converter.html

/Shoaib

On 8 Apr 2006 17:04:41 -0700, zagman <daveh(at)allheller(dot)net> wrote:
>
>
> Hi all,
>
> I'm trying to migrate to a postgresql server backend with an existing
> Access 97 application. However Access 97 crashes all the time if I
> update any records The error I see says something about "SQL_ASCI"
> encoding when I look at the error report that Access generates to send
> to Microsoft.
> What encoding should I use? I'm using postgresql 8.0.7 with pgsqlodbc
> 8.00.01.03.
>
> Thanks,
>
> Dave
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>