pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: Standalone driver for Unix
2+ messages / 2 participants
[nested] [flat]
* Re: Standalone driver for Unix
@ 1998-10-29 14:46 Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-10-29 15:01 ` Re: Standalone driver for Unix Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 1 reply; 2+ messages in thread
From: Thomas G. Lockhart @ 1998-10-29 14:46 UTC (permalink / raw)
To: scampbell@lear.com, "Cary O'Brien" <cobrien@access.digex.net>; Byron Nikolaidis <byronn@insightdist.com>; +Cc: pgsql-interfaces
scampbell@lear.com wrote:
>
> I had one other interesting thing with the Postgresql ODBC driver.
I don't know much of the internal's of ODBC but here's what I'm
wondering...
>
> When I use an extended datatype (let's say one for ipaddress for
instance) and then use MS Access to open the table via ODBC it
complains that the 'ipaddress' is an unknown type. I have clicked a
box in creation of the ODBC ini file (or the .DSN file actually in the
case of MS) that says (something similar to) 'Treat unknown datatypes
as LongVarChar' but it seems to have no effect turned on or off. Does
our drive not support this? Is MS just show it normal 'excellence in
programming'? Any ideas?
>
> (Feel free to cross post this if the you think the question/answer
might be of interest to others).
I have no idea. But others are likely to. Usually best to hit the lists
directly to get a better mix of ideas early on.
Someone else?
- Tom
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Standalone driver for Unix
1998-10-29 14:46 Re: Standalone driver for Unix Thomas G. Lockhart <lockhart@alumni.caltech.edu>
@ 1998-10-29 15:01 ` Byron Nikolaidis <byronn@insightdist.com>
0 siblings, 0 replies; 2+ messages in thread
From: Byron Nikolaidis @ 1998-10-29 15:01 UTC (permalink / raw)
To: Thomas G. Lockhart <lockhart@alumni.caltech.edu>; +Cc: scampbell@lear.com, "Cary O'Brien" <cobrien@access.digex.net>; pgsql-interfaces
Thomas G. Lockhart wrote:
> scampbell@lear.com wrote:
> >
> > I had one other interesting thing with the Postgresql ODBC driver.
> I don't know much of the internal's of ODBC but here's what I'm
> wondering...
> >
> > When I use an extended datatype (let's say one for ipaddress for
> instance) and then use MS Access to open the table via ODBC it
> complains that the 'ipaddress' is an unknown type. I have clicked a
> box in creation of the ODBC ini file (or the .DSN file actually in the
> case of MS) that says (something similar to) 'Treat unknown datatypes
> as LongVarChar' but it seems to have no effect turned on or off. Does
> our drive not support this? Is MS just show it normal 'excellence in
> programming'? Any ideas?
> >
Are you trying to use this 'ipaddress' field as a key field? If so, you
must NOT check the Treat unknown datatypes as LongVarChar. The reason is
Access can't have a unique index on a field that is over 255 characters,
which is the default max length for a longvarchar.
Try unchecking the option, then you *must* re-link the table in Access to
see if it worked. Also, Make sure the size for "Max Varchar" is set to
the default of 254.
Byron
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-10-29 15:01 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-10-29 14:46 Re: Standalone driver for Unix Thomas G. Lockhart <lockhart@alumni.caltech.edu>
1998-10-29 15:01 ` Byron Nikolaidis <byronn@insightdist.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox