Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0G6RC044688 for ; Tue, 16 Jan 2001 01:27:12 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0G6R9J11472; Tue, 16 Jan 2001 01:27:10 -0500 (EST) To: Michael Fork cc: pgsql-interfaces@postgresql.org Subject: Re: ODBC and COPY In-reply-to: References: Comments: In-reply-to Michael Fork message dated "Tue, 16 Jan 2001 01:02:32 -0500" Date: Tue, 16 Jan 2001 01:27:09 -0500 Message-ID: <11469.979626429@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/152 X-Sequence-Number: 766 Michael Fork 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