Re: ODBC & Access [Try 2]
От | Dennis Gearon |
---|---|
Тема | Re: ODBC & Access [Try 2] |
Дата | |
Msg-id | 3EA84AEA.40504@cvc.net обсуждение исходный текст |
Ответ на | Re: ODBC & Access [Try 2] ("David Olbersen" <DOlbersen@stbernard.com>) |
Список | 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 >
В списке pgsql-general по дате отправления: