Oops, sorry forgot a little bit of script for the backend:
create function int4eq(xid,int4)
create operator = (
This should give a suitable a suitable operator. I think theres an MS Access
FAQ on odbc.postgresql.org and on techdocs.postgresql.org which may also
> -----Original Message-----
> From: Maryann F Stopha [SMTP:stopha(at)geneseo(dot)edu]
> Sent: Friday, July 20, 2001 3:16 PM
> To: Pgsql-Odbc(at)postgresql(dot)org
> Subject: Re: Access 2000 and ODBC driver Data changed by another
> user, Cop y to Clipboard or Drop changes
> Hi Stuart, thank you for your reply.
> I turned on row versioning, relinked the tables, and I'm now getting ODBC
> --update on a linked table 'organizations' failed.
> Error while exectuing the query;
> ERROR: Unable to identify an operator '=' for types 'xid' and 'int4'
> You will have to retype this query using an explicit cast (#7)
> Anyone have any ideas on this one?
> On 7/20/01 5:32 AM, "Henshall, Stuart - WCP"
> <SHenshall(at)westcountrypublications(dot)co(dot)uk> wrote:
> > Are you using row versioning? If not give it a go (you'll need to relink
> > tables after enabling)
> > - Stuart
> >> -----Original Message-----
> >> From: Maryann F Stopha [SMTP:stopha(at)geneseo(dot)edu]
> >> Sent: Thursday, July 19, 2001 4:22 PM
> >> To: Pgsql-Odbc(at)postgresql(dot)org
> >> Subject: Access 2000 and ODBC driver Data changed by another user,
> >> Copy to Clipboard or Drop changes
> >> Hi,
> >> I'm working on a machine that was upgraded to office 2000.
> >> I updated the odbc driver to the most recent, and I'm getting the -Data
> >> changed by another user, Copy to Clipboard or Drop changes message
> >> is
> >> being accessed by another)- error. We can't modify or add any data in
> >> database from Access because of this error.
> >> This does not happen in Access 97. Does anyone have any ideas as to
> >> Access 2000 will gives error? There's no numeric data in the database,
> >> it's
> >> all text.
> >> Thanks,
> >> Maryann Stopha
> >> --
> >> Web Development Professional
> >> Computing & Information Technology
> >> SUNY Geneseo
> >> 716.245.5577
> >> stopha(at)geneseo(dot)edu
pgsql-odbc by date
|Next:||From: Henshall, Stuart - WCP||Date: 2001-07-23 08:21:56|
|Subject: RE: Access 97 - problems with the result set|
|Previous:||From: Joachim Andree||Date: 2001-07-23 07:15:53|
|Subject: No permission to set nextval of sequence|