Re: Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ?

From: "Philippe Lang" <philippe(dot)lang(at)attiksystem(dot)ch>
To: "Andreas" <maps(dot)on(at)gmx(dot)net>, <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ?
Date: 2009-08-13 11:36:54
Message-ID: E6A0649F1FBFA3408A37F505400E7AC21F8625@email.attiksystem.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

pgsql-odbc-owner(at)postgresql(dot)org wrote:
> Hi,
>
> I've got an Access-App using PG 8.4 in a LAN.
> The systems dude said he updated to odbc 8.400 on all clients.
> Though the same issue appeared with PG 8.3.7 and odbc 8.2.5 before.
>
> Among others, there are 2 tables sitting in a schema.
> Their primary keys are sequences.
> I link those tables into access and the keys are shown as autovalue
> as expected.
>
> When Access tries to add a record, it complains that the relation
> "versandinfos_versandinfo_id_seq" wouldn't exist and throws an error
> #7.

Hi,

Have you checked if your ODBC user has enough rights on your sequence
"versandinfos_versandinfo_id_seq"? You can use pgAdmin to check that.

Regards,

-----------------------------------------------------------------------
Philippe Lang Web : www.attiksystem.ch
Attik System Email : philippe(dot)lang(at)attiksystem(dot)ch
rte de la Fonderie 2 Phone : +41 26 422 13 75
1700 Fribourg Mobile : +41 79 351 49 94
Switzerland Fax : +41 26 422 13 76

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andreas 2009-08-13 15:54:51 Re: Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ?
Previous Message Andreas 2009-08-13 09:34:28 Is there a mysthical problem with psqlODBC + MSAccess + sequences IN SCHEMAS ?