pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC and COPY
3+ messages / 3 participants
[nested] [flat]
* ODBC and COPY
@ 2001-01-16 06:02 Michael Fork <mfork@toledolink.com>
2001-01-16 06:27 ` Re: ODBC and COPY Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Michael Fork @ 2001-01-16 06:02 UTC (permalink / raw)
To: pgsql-interfaces
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ODBC and COPY
2001-01-16 06:02 ODBC and COPY Michael Fork <mfork@toledolink.com>
@ 2001-01-16 06:27 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2001-01-16 06:27 UTC (permalink / raw)
To: Michael Fork <mfork@toledolink.com>; +Cc: pgsql-interfaces
Michael Fork <mfork@toledolink.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 ...
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: ODBC and COPY
@ 2001-01-16 08:25 Dave Page <dpage@vale-housing.co.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Dave Page @ 2001-01-16 08:25 UTC (permalink / raw)
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; Michael Fork <mfork@toledolink.com>; +Cc: pgsql-interfaces
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 16 January 2001 06:27
> To: Michael Fork
> Cc: pgsql-interfaces@postgresql.org
> Subject: Re: [INTERFACES] ODBC and COPY
>
>
> Michael Fork <mfork@toledolink.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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2001-01-16 08:25 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-16 06:02 ODBC and COPY Michael Fork <mfork@toledolink.com>
2001-01-16 06:27 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-01-16 08:25 RE: ODBC and COPY Dave Page <dpage@vale-housing.co.uk>
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