Обсуждение: using ODBC-Driver of POSTGRES in relation to CRecordsets

Поиск
Список
Период
Сортировка

using ODBC-Driver of POSTGRES in relation to CRecordsets

От
The Hermit Hacker
Дата:
Hello!

I've got a real problem, if I try to use any CRecordset to access any Table
in a Database of POSTGRES SQL-Server.

First the description of my little test-program:

I used the Class-Wizard of VC 5.0 to generate a new class which base-class
is a Crecordset
I selected the correct ODBC-Database from the menu and then the table, I
wanted to access within my program.

But if I try to open the recordset, I always get Unhandled Exceptions.
I found out, that the ODBC-Driver of postgres seems not to support
Snapshots.(there were DEBUG-Asserts, caused by missing functions in the
ODBC-Driver)
So I tried to use Dynaset.
But that doesn't work, too.
(Exception, whe the Open-Method checks the Cursor-Type.)

Please help me, what to do, that I can acces any Table via the ODBC-Driver
and an CRecordset

(Is there any Sample-Code available???)


Thankyou in Advance!

Oliver







Re: [INTERFACES] using ODBC-Driver of POSTGRES in relation to CRecordsets

От
Byron Nikolaidis
Дата:
OK,

You sent me a logfile which showed the problem.  I made some fixes to the
driver and sent a new driver for you to try via mail 2 days ago.  I've heard
nothing back.

I need some feedback on the driver I sent you already before we can go on.

Byron

The Hermit Hacker wrote:

> Hello!
>
> I've got a real problem, if I try to use any CRecordset to access any Table
> in a Database of POSTGRES SQL-Server.
>
> First the description of my little test-program:
>
> I used the Class-Wizard of VC 5.0 to generate a new class which base-class
> is a Crecordset
> I selected the correct ODBC-Database from the menu and then the table, I
> wanted to access within my program.
>
> But if I try to open the recordset, I always get Unhandled Exceptions.
> I found out, that the ODBC-Driver of postgres seems not to support
> Snapshots.(there were DEBUG-Asserts, caused by missing functions in the
> ODBC-Driver)
> So I tried to use Dynaset.
> But that doesn't work, too.
> (Exception, whe the Open-Method checks the Cursor-Type.)
>
> Please help me, what to do, that I can acces any Table via the ODBC-Driver
> and an CRecordset
>
> (Is there any Sample-Code available???)
>
> Thankyou in Advance!
>
> Oliver