Re: [INTERFACES] ODBC / M$Access error

Nicolas Huillard wrote:
>
> Could you please tell me what you found. I had the same problem =
> yesterday, and was waiting for an answer to your question... I really =
> have a very little time to check this particular problem.

Quoting from http://www.insightdist.com/psqlodbc/psqlodbc_faq.html :

Until this new type becomes an official part of Postgres, it must be added
into the desired database and looked up for each connection. The type used
in the driver is simply called "lo" and here is the command used to create it:

create type lo (
internallength=4, externallength=10,
input=int4in, output=int4out,
default='', passedbyvalue
);

create table employee (
id integer,
name varchar(30),
picture lo
);

Cheers,

Patrick

> De: Patrick Welche [SMTP:prlw1(at)newn(dot)cam(dot)ac(dot)uk]
> Date: jeudi 14 octobre 1999 13:36
>
> Sorry - found it in the faq.
>
> Patrick Welche wrote:
> >
> > In my first ever attempt to connect to PostgreSQL-current (on
> > NetBSD/i386-current) from M$Access (on NT4 using PostODBC 6.40.0006)
> > I get
> >
> > Unable to locate type name "lo" in catalogue [#17]
> >
> > when trying to export a table. I can import one successfully => I assume
> > pg_hba.conf and co are happy.
> >
> > Any suggestions?