Re: ODBC & Access [Try 2]

Two recommendations.
1) Try the snapshot dll from http://www.geocities.jp/inocchichichi/psqlodbc/.
2) Uncheck the box for updatable cursors.

On Thursday 24 April 2003 12:24 pm, David Olbersen wrote:
> > -----Original Message-----
> > From: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com]
> > Sent: Thursday, April 24, 2003 12:08 PM
> > To: David Olbersen; pgsql-novice(at)postgresql(dot)org
> > Cc: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] ODBC & Access [Try 2]
> >
> > <guess>
> > Make sure driver option "row versioning" is checked.
> > Also, make sure that the offending table has a primary
> > key that Access is recognizing as such.
> > </guess>
> > If both of those conditions are met, and you still
> > have a problem, please post your driver settings.
>
> Turned on row versioning, no change.
>
> When I link the table, Access doesn't ask me to chose the primary key. When
> I look at the Design View for that table it's chosen a primary key. The
> field it's chosen doesn't have any NULL values and all the rows for that
> field are unique, so it should be OK, right? The column that it chose is
> NOT a numeric field, but text. Would that cause a problem?
>
> Driver settings:
> ================
> This is a System DSN.
>
> Datasource options (page 1)
> Disable Genetic Optimizer = Checked
> KSQO = Checked
> Recognize Unique Indexes = Checked
> Use Declare/Fetch = Checked
> CommLog = Checked
> Parse Statements = UNchecked
> Cancel as FreeStmt = UNchecked
> MyLog = Checked
> Unknown Sizes = Maximum
> Data Type Options:
> Text as LongVarChar = Checked
> Unknowns as LongVarChar = UNchecked
> Bools as Char = Checked
> Miscellanous:
> Max Varchar = 254
> Max LongVarChar = 8190
> Cache Size = 100
> SysTable Prefixes = dd_;
>
> Datasource options (page 2)
> Read Only = UNchecked
> Show System Tables = UNchecked
> LF <-> CR/LF conversion = Checked
> Updatable Cursors = Checked
> Row Versioning = Checked (now, wasn't before)
> Disallow Premature = UNchecked
> True is -1 = UNchecked
> Int8 as = default
> Protocol = 7.x,6.4+
> OID Options:
> Show Column = UNchecked
> Connect Settings = <blank>
>
>
> --------------------------
> David Olbersen
> iGuard Engineer
> 11415 West Bernardo Court
> San Diego, CA 92127
> 1-858-676-2277 x2152
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org