Re: Postgresql with Access 97

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Postgresql with Access 97
Дата
Msg-id bf54be870604092228h528ff87re2169efe8d1c3eb5@mail.gmail.com
обсуждение исходный текст
Ответ на Postgresql with Access 97  ("zagman" <daveh@allheller.net>)
Список pgsql-general
Дерево обсуждения
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@allheller.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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Is difference between PostgreSQL and mySQL licences
Следующее
От: felix@crowfix.com
Дата:
Сообщение: Asking advice on speeding up a big table