Re: ODBC & Access [Try 2]
От | David Olbersen |
---|---|
Тема | Re: ODBC & Access [Try 2] |
Дата | |
Msg-id | E7E213858379814A9AE48CA6754F5ECB0D6D82@mail01.stbernard.com обсуждение исходный текст |
Ответ на | ODBC & Access [Try 2] ("David Olbersen" <DOlbersen@stbernard.com>) |
Список | pgsql-general |
Thanks for the suggestion, but that didn't do it either. I installed that dll in C:\Windows\System32, created a new DSN using that driver and the problem still exists. -------------------------- David Olbersen iGuard Engineer 11415 West Bernardo Court San Diego, CA 92127 1-858-676-2277 x2152 > -----Original Message----- > From: Adrian Klaver [mailto:aklaver@attbi.com] > Sent: Thursday, April 24, 2003 7:40 PM > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] 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@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 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
В списке pgsql-general по дате отправления: