ODBC and COPY FROM - Mailing list pgsql-interfaces

From Michael Fork
Subject ODBC and COPY FROM
Date
Msg-id Pine.BSI.4.21.0101160029500.29498-100000@glass.toledolink.com
Whole thread Raw
List 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:

Previous
From: "Adam Lang"
Date:
Subject: Re: Turn off implicit BEGIN from ODBC driver on Windows?
Next
From: "Knopp, Gary"
Date:
Subject: 7.1 Beta3 bug when using ODBC