RE: ODBC and COPY

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Fork <mfork(at)toledolink(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: RE: ODBC and COPY
Date: 2001-01-16 08:25:36
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2884@woody.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 16 January 2001 06:27
> To: Michael Fork
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] ODBC and COPY
>
>
> Michael Fork <mfork(at)toledolink(dot)com> writes:
> > I have been attempting to use the COPY command in an ADO connection,
> > but receive the following error:
> > Error while executing the query;
> > Unexpected protocol character from backend (send_query)
> >
> > This is PostgreSQL 7.0.2 on i386-unknown-openbsd2.8,
> compiled by cc with
> > the 6.5 version of the PostgresSQL ODBC driver.
>
> Now that I look at it, it looks like the ODBC code only
> *thinks* it can
> cope with the 6.4-and-later FE-to-BE protocol. It doesn't
> seem to know
> how to do copy in or out under the latest protocol. Try setting it to
> use 6.3 protocol ... the backend should still accept that ...

This may be a stupid question, but how do you direct data to stdin when you
are using ADO?

Regards

Dave.

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter T Mount 2001-01-16 09:12:46 Re: Deleting a list of external xinv/xinx files using JDBC
Previous Message Tom Lane 2001-01-16 06:27:09 Re: ODBC and COPY