Thread: using ODBC-Driver of POSTGRES in relation to CRecordsets
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
From
Byron Nikolaidis
Date:
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