pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC driver for Windows - Problems
6+ messages / 3 participants
[nested] [flat]
* ODBC driver for Windows - Problems
@ 2000-05-29 06:50 Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-30 12:37 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 1 reply; 6+ messages in thread
From: Viktor de Souza Spínola @ 2000-05-29 06:50 UTC (permalink / raw)
To: pgsql-interfaces
Hi friends!
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.
Are there some kind of "known issues" or incompatibility in this scenario?
I'm really a beginner in PostgreSQL, any appointment would be very helpful!
Please, CC the reply to viktor@viktor.com.br, because I haven't signed the list yet.
Thanks,
Viktor.
\\|//
(o o)
~~~~~~~~~~~~~~~~~~~~oOO~(_)~OOo~~~~~~~~~~~~~~~~~~~
# Viktor de Souza Spínola #
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
# e-mail: viktor@viktor.com.br #
# viktor@araketu.dcc.ufba.br #
# #
# Home Page: http://www.viktor.com.br #
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~#
# "Para conseguir aprender com os seus erros, #
# primeiro você precisa saber admitir #
# que eles existem." #
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC driver for Windows - Problems
2000-05-29 06:50 ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
@ 2000-05-30 12:37 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-05-30 17:38 ` Re: ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
2000-06-02 23:05 ` Re: ODBC driver for Windows - Problems Roderick A. Anderson <raanders@altoplanos.net>
0 siblings, 2 replies; 6+ messages in thread
From: Kovacs Zoltan Sandor @ 2000-05-30 12:37 UTC (permalink / raw)
To: Viktor de Souza Spínola <viktor@viktor.com.br>; +Cc: pgsql-interfaces
> 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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC driver for Windows - Problems
2000-05-29 06:50 ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-30 12:37 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
@ 2000-05-30 17:38 ` Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-31 10:11 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
1 sibling, 1 reply; 6+ messages in thread
From: Viktor de Souza Spínola @ 2000-05-30 17:38 UTC (permalink / raw)
To: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>; +Cc: pgsql-interfaces
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
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC driver for Windows - Problems
2000-05-29 06:50 ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-30 12:37 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-05-30 17:38 ` Re: ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
@ 2000-05-31 10:11 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 0 replies; 6+ messages in thread
From: Kovacs Zoltan Sandor @ 2000-05-31 10:11 UTC (permalink / raw)
To: Viktor de Souza Spínola <viktor@viktor.com.br>; +Cc: pgsql-interfaces; lockhart@alumni.caltech.edu
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC driver for Windows - Problems
2000-05-29 06:50 ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-30 12:37 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
@ 2000-06-02 23:05 ` Roderick A. Anderson <raanders@altoplanos.net>
2000-06-05 08:46 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
1 sibling, 1 reply; 6+ messages in thread
From: Roderick A. Anderson @ 2000-06-02 23:05 UTC (permalink / raw)
To: Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>; +Cc: Viktor de Souza Spínola <viktor@viktor.com.br>; pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: ODBC driver for Windows - Problems
2000-05-29 06:50 ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-30 12:37 ` Re: ODBC driver for Windows - Problems Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-06-02 23:05 ` Re: ODBC driver for Windows - Problems Roderick A. Anderson <raanders@altoplanos.net>
@ 2000-06-05 08:46 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
0 siblings, 0 replies; 6+ messages in thread
From: Kovacs Zoltan Sandor @ 2000-06-05 08:46 UTC (permalink / raw)
To: Roderick A. Anderson <raanders@altoplanos.net>; Viktor de Souza Spínola <viktor@viktor.com.br>; Laszlo Tibor <ltibor@mail.tiszanet.hu>; +Cc: pgsql-interfaces
> > > 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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2000-06-05 08:46 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-05-29 06:50 ODBC driver for Windows - Problems Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-30 12:37 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-05-30 17:38 ` Viktor de Souza Spínola <viktor@viktor.com.br>
2000-05-31 10:11 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
2000-06-02 23:05 ` Roderick A. Anderson <raanders@altoplanos.net>
2000-06-05 08:46 ` Kovacs Zoltan Sandor <tip@pc10.radnoti-szeged.sulinet.hu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox