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

> -----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'schosen 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