Thread: ODBC and COPY FROM

ODBC and COPY FROM

From
Michael Fork
Date:
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