Re: ODBC & Access [Try 2] - Mailing list 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
>