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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-interfaces by date

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