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

You said it was the **ONE** table that had a text field for an index right?

David Olbersen wrote:
> Maybe, but I REALLY doubt it.
>
> Like I said, these other tables with very similar structures and very similar data display just fine. It's just this
one.
>
> --------------------------
> David Olbersen
> iGuard Engineer
> 11415 West Bernardo Court
> San Diego, CA 92127
> 1-858-676-2277 x2152
>
>
>
>>-----Original Message-----
>>From: Dennis Gearon [mailto:gearond@cvc.net]
>>Sent: Thursday, April 24, 2003 12:38 PM
>>To: David Olbersen
>>Cc: pgsql-general@postgresql.org
>>Subject: Re: [GENERAL] ODBC & Access [Try 2]
>>
>>
>>maybe it's related to sorting in your environment, the
>>client's environment, or the server's environment? Case
>>sensitive vs. not? (PS, I can't wait till UTF-8 gets totally
>>ubiquitous.)
>>
>>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
>>
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>