Re: ODBC & Access [Try 2] - Mailing list pgsql-general

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@yahoo.com]
> > Sent: Thursday, April 24, 2003 12:08 PM
> > To: David Olbersen; pgsql-novice@postgresql.org
> > Cc: pgsql-general@postgresql.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@postgresql.org