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

ODBC and COPY FROM

From: Michael Fork <mfork(at)toledolink(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC and COPY FROM
Date: 2001-01-16 05:36:59
Message-ID: Pine.BSI.4.21.0101160029500.29498-100000@glass.toledolink.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
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.  The code that produces
the error is as follows:

cnRemoteDB.Execute "COPY tbldirectory FROM stdin " _
	& "USING DELIMITERS '|' WITH NULL AS '' "

I am curious if anyone has gotten COPY to work thru the ODBC driver, and
if possible, a code snippet that I can use as a guide.

Thanks

Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio


pgsql-interfaces by date

Next:From: Michael ForkDate: 2001-01-16 06:02:32
Subject: ODBC and COPY
Previous:From: Thomas LockhartDate: 2001-01-16 05:12:29
Subject: Re: outer join in PostgreSql

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