Re: ODBC & Access [Try 2]

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(at)attbi(dot)com]
> Sent: Thursday, April 24, 2003 7:40 PM
> To: pgsql-general(at)postgresql(dot)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(at)yahoo(dot)com]
> > > Sent: Thursday, April 24, 2003 12:08 PM
> > > To: David Olbersen; pgsql-novice(at)postgresql(dot)org
> > > Cc: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>