Thread: Adding records via Ole Db

Adding records via Ole Db

From
Erwin van der Valk
Date:
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