Message-ID: <382BE021.DB1D2B58@caiw.nl>
Date: Fri, 12 Nov 1999 10:38:42 +0100
From: Erwin van der Valk <The.Falcon@caiw.nl>
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: Adding records via Ole Db
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi there,
I'm having trouble with inserting records into an PostgreSQL server from
a visual C++ application using OLE DB.

I'm writing a Visual C++ application that communicates with several
datasources, including a PostgreSQL database server. To do that I'm
using OLE DB, since OLE DB can also interact with non relational
datasources.

I have installed the ODBC driver for postgres, and there is an OLE DB
Provider for ODBC. Using that provider I can insert records into a MS
SQL server, or into an Access database, but for some reason I can not
insert or update records into the PostgreSQL server. I can delete or
select records, but inserting doesn't work.

Is there anybody who knows how to work around this problem?

Thanks a lot,
Erwin van der Valk
falcon@caiw.nl