Thread: ODBC driver for Windows - Problems

> I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder
> client program, using the PostODBC (it supports protocols 6.3, 6.4 and
> 6.5 - how about 7.0???) driver. It works very good partially, but it's
> GPF'ing at some points - as far as I could understand, when I'm
> retrieving data.
We are using 7.0, it works well, but the code needs a few improvements
yet. What do you mean about 'GPF'ing'? 

> Are there some kind of "known issues" or incompatibility in this
> scenario?
Referential error reporting is not supported yet but there is an
experimental DLL on our FTP site, if you really need this feature.

Regards,
Zoltan

My program is hanging when trying to retrieve some specific DataWindow's,
and this does not happen with other databases (even through ODBC). I'll make
some more test, and try to averiguate more this week.
I'm using the PostODBC driver I've found in postgresql.org FTP site, it
claims to support protocols 6.3, 6.4 and 6.5, and says nothing aboutm 7.0.
Do you use the same driver I have?
I does not support referential error reporting, I can imagine that, by the
way, what happens when one of these errors happen?

Thanks for your help, I'm still studying PostgreSQL, that's why I'm so
insecure... it's good to hear that that PostODBC driver is really reliable,
it gives me hope, at least ;)


Much thanks again! (please forgive my English language poorness, I'm from
Brazil)
Viktor

----- Original Message -----
From: "Kovacs Zoltan Sandor" <tip@pc10.radnoti-szeged.sulinet.hu>
To: "Viktor de Souza Spínola" <viktor@viktor.com.br>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Tuesday, May 30, 2000 9:37 AM
Subject: Re: [INTERFACES] ODBC driver for Windows - Problems


> > I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder
> > client program, using the PostODBC (it supports protocols 6.3, 6.4 and
> > 6.5 - how about 7.0???) driver. It works very good partially, but it's
> > GPF'ing at some points - as far as I could understand, when I'm
> > retrieving data.
> We are using 7.0, it works well, but the code needs a few improvements
> yet. What do you mean about 'GPF'ing'?
>
> > Are there some kind of "known issues" or incompatibility in this
> > scenario?
> Referential error reporting is not supported yet but there is an
> experimental DLL on our FTP site, if you really need this feature.
>
> Regards,
> Zoltan
>
>

On Tue, 30 May 2000, [iso-8859-1] Viktor de Souza Sp�nola wrote:

> I'm using the PostODBC driver I've found in postgresql.org FTP site, it
> claims to support protocols 6.3, 6.4 and 6.5, and says nothing aboutm 7.0.
> Do you use the same driver I have?
As far as I know, 7.0 uses the same protocol as the 6.5. Most things
should work automatically with 7.0. But... when first beta was released,
the SPI way of the referential integrity (see contrib/spi/refint* for
details) didn't work anymore. It might be corrected since then, but we
found out that the new way of the referential integrity checks (i.e.
FOREIGN KEY and REFERENCES) should be better for future use so we decided
to rewrite all the SQL database code at the server side. It was
successful, but the current driver (which can be found on e.g.
postgresql.org) couldn't report some type of errors, e.g. referential
integrity violations. As far as I know, duplicate unique key violations
were also not reported correctly. Now I have a new version, but we are not
sure, that it will work with all application (e.g. Applixware for Unix or
other Windows database software, e.g. MS Access). Currently the new code
should be checked until it will be forwarded to the CVS tree.

No other drawbacks are known for us yet, but we decided to use both
Borland C++ Builder and PostgreSQL, so we MUST support client and server
side improvements for a longer time...

Regards, Zoltan

On Tue, 30 May 2000, Kovacs Zoltan Sandor wrote:

> > I'm trying to access a PostgreSQL 7.0 backend from my PowerBuilder
> > client program, using the PostODBC (it supports protocols 6.3, 6.4 and
> > 6.5 - how about 7.0???) driver. It works very good partially, but it's
> > GPF'ing at some points - as far as I could understand, when I'm
> > retrieving data.
> We are using 7.0, it works well, but the code needs a few improvements
> yet. What do you mean about 'GPF'ing'? 

General Protection Fault.  Core dump without protection.  Love those
Windows!

Rod
-- 
Roderick A. Anderson
raanders@altoplanos.net               Altoplanos Information Systems, Inc.
Voice: 208.765.6149                            212 S. 11th Street, Suite 5
FAX: 208.664.5299                                  Coeur d'Alene, ID 83814

> > > GPF'ing at some points - as far as I could understand, when I'm
> > > retrieving data.
> > We are using 7.0, it works well, but the code needs a few improvements
> > yet. What do you mean about 'GPF'ing'? 
> General Protection Fault.  Core dump without protection.  Love those
> Windows!
Oh, I see... Viktor, could you please write exactly where and when did you
realize GPF? I don't remember we had such an error. (We had others, e.g.
Access violation, but not GPF.) Tibor, did we?

Regards, Zoltan