Skip site navigation (1) Skip section navigation (2)

Re: ODBC & Access [Try 2]

From: "David Olbersen" <DOlbersen(at)stbernard(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: ODBC & Access [Try 2]
Date: 2003-04-25 14:34:14
Message-ID: E7E213858379814A9AE48CA6754F5ECB0D6D83@mail01.stbernard.com (view raw or flat)
Thread:
Lists: pgsql-novice
Josh,

> My guess is that the table definition has changed since you 
> attached it from access.   I'd suggest dropping the linked table 
> and re-linking it.

I assure you that isn't the case for two reasons:
1) I'd be the one changing the table definition, and I haven't been
2) I've been linking & unlinking so much it's HIGHLY unlikely.

> For further help, I suggest joining the pgsql-odbc mailing 
> list and/or the pgodbc project's mailing list.

Good suggestion, thanks!

--------------------------
David Olbersen 
iGuard Engineer
11415 West Bernardo Court 
San Diego, CA 92127 
1-858-676-2277 x2152


> -----Original Message-----
> From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
> Sent: Thursday, April 24, 2003 4:29 PM
> To: David Olbersen; pgsql-novice(at)postgresql(dot)org
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [NOVICE] ODBC & Access [Try 2]
> 
> 
> David,
> 
> > 7 of them work just fine and I can see all the data in them. 
> > The last one though, only displays '#DELETED' for each column 
> > of each row. I checked the permissions on all the tables and 
> > they're the same -- I have read access (all I need for now, right?)
> > 
> > Any idea what's going on? This is PostgreSQL 7.3.2 on 
> FreeBSD with the 
> PostgreSQL ODBC driver version 7.02.00.05 on Win XP.
> 
> My guess is that the table definition has changed since you 
> attached it from 
> access.   I'd suggest dropping the linked table and re-linking it.
> 
> For further help, I suggest joining the pgsql-odbc mailing 
> list and/or the 
> pgodbc project's mailing list.
> 
> -- 
> -Josh Berkus
>  Aglio Database Solutions
>  San Francisco
> 
> 


pgsql-novice by date

Next:From: Tom LaneDate: 2003-04-25 14:40:48
Subject: Re: large objects in 7.3
Previous:From: Dick WielandDate: 2003-04-25 14:29:47
Subject: large objects in 7.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group