Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] ODBC / M$Access error

From: "Patrick Welche" <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: nhuillard(at)ghs(dot)fr (Nicolas Huillard)
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] ODBC / M$Access error
Date: 1999-10-14 17:06:23
Message-ID: E11boKd-0005sj-00@quartz.newn.cam.ac.uk (view raw or flat)
Thread:
Lists: pgsql-interfaces
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?

pgsql-interfaces by date

Next:From: Lakshmi Anand K.Date: 1999-10-15 00:53:32
Subject: ODBC Problem - Please help
Previous:From: Rajive P. SoodDate: 1999-10-14 12:58:31
Subject: Inquiry

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group