Thread: ODBC and Visual C++

I am currently writing a front end application is Visual C++ to work with a
Postgres backend. I set the recordset class' m_nDefaultType to dynaset in
the constructor, which should allow me to update the records. I compile the
program, and I get a messagebox telling me that the ODBC driver does not
support dynasets. If I try to do it as a snapshot, then there is no problem,
except that I cannot update. I am using a system DSN, and letting the Visual
C++ wizards generate the recordset/view classes using ODBC. Does anyone know
how I can get the ODBC driver to support dynasets? I'm sure it's really
easy, I just don't know ODBC that well.

J-T MacNeil (ext. 266)
Software QA Specialist
Sur-Gard Security Communications
Tel    416 667-0144
Fax    416 667-0038
e-Mail    macneilj@sur-gard.com

You can use the ODBC Cursor Library -- I think you specify this option when
making the connection.

Byron

----- Original Message -----
From: JT MacNeil <macneiljt@sur-gard.com>
To: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, June 27, 2000 6:18 PM
Subject: [INTERFACES] ODBC and Visual C++


> I am currently writing a front end application is Visual C++ to work with
a
> Postgres backend. I set the recordset class' m_nDefaultType to dynaset in
> the constructor, which should allow me to update the records. I compile
the
> program, and I get a messagebox telling me that the ODBC driver does not
> support dynasets. If I try to do it as a snapshot, then there is no
problem,
> except that I cannot update. I am using a system DSN, and letting the
Visual
> C++ wizards generate the recordset/view classes using ODBC. Does anyone
know
> how I can get the ODBC driver to support dynasets? I'm sure it's really
> easy, I just don't know ODBC that well.
>
> J-T MacNeil (ext. 266)
> Software QA Specialist
> Sur-Gard Security Communications
> Tel 416 667-0144
> Fax 416 667-0038
> e-Mail macneilj@sur-gard.com
>
>