Re: ODBC patch

Started by Kovacs Zoltanalmost 26 years ago7 messageshackers

kovacsz@pc10.radnoti-szeged.sulinet.hu

almost 26 years ago

On Sat, 20 May 2000, Thomas Lockhart wrote:

I modified the current ODBC driver for
* referential integrity error reporting,
* SELECT in transactions and
* disabling autocommit.
I tested these changes with Borland C++ Builder -> ODBCExpress ->
WinODBC driver (DLL) -> Postgres 7.0beta1 and Borland C++ Builder -> BDE ->
WinODBC driver (DLL) -> Postgres 7.0beta1. The patch is based on snapshot of
22th April (I don't think that someone has modified it since that: Byron
hasn't gave any sign of living for about a month and I didn't find any
comments about the ODBC driver on the list).

We are starting to think about organizing additional ODBC testing for
7.0.1. istm that your patches would help existing functionality, and
not damage (or change for the worse) current behavior.

Yes, sure. I know that this code (which was sent to Thomas) needs further
check. Have you had time to think about it?

Regards,
Zoltan
Kov\'acs, Zolt\'an
kovacsz@pc10.radnoti-szeged.sulinet.hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz

Import Notes

Reply to msg id not found: 3926194A.B9A9B000@alumni.caltech.edu

Thomas Lockhart

lockhart@alumni.caltech.edu

almost 26 years ago

In reply to: Kovacs Zoltan (#1)

I modified the current ODBC driver for
* referential integrity error reporting,
* SELECT in transactions and
* disabling autocommit.

We are starting to think about organizing additional ODBC testing

Yes, sure. I know that this code (which was sent to Thomas) needs
further check. Have you had time to think about it?

Sorry to ask this: can you please re-re-send the patch to me? I've
upgraded my machine and at the moment my backup disk is unreadable :(

re-TIA

- Thomas

frank

f.callaghan@ieee.org

almost 26 years ago

In reply to: Thomas Lockhart (#2)

Re: Re: ODBC patch

Thomas Lockhart wrote:

I modified the current ODBC driver for
* referential integrity error reporting,
* SELECT in transactions and
* disabling autocommit.

We are starting to think about organizing additional ODBC testing

Yes, sure. I know that this code (which was sent to Thomas) needs
further check. Have you had time to think about it?

Sorry to ask this: can you please re-re-send the patch to me? I've
upgraded my machine and at the moment my backup disk is unreadable :(

re-TIA

- Thomas

Does this anything to do with a problem I'm having:

When selecting data (using ODBC) from within a transaction block with
V7.0 I get NO data back :( The same query performed outside the block
works fine !!
This same code works ok with 6.5.x with no problems.

Any Clues ?

TIA,
Frank.

Import Notes

Resolved by subject fallback

Bruce Momjian

bruce@momjian.us

almost 26 years ago

In reply to: Thomas Lockhart (#2)

Re: Re: ODBC patch

Did we ever get this patch applied?

I modified the current ODBC driver for
* referential integrity error reporting,
* SELECT in transactions and
* disabling autocommit.

We are starting to think about organizing additional ODBC testing

Yes, sure. I know that this code (which was sent to Thomas) needs
further check. Have you had time to think about it?

Sorry to ask this: can you please re-re-send the patch to me? I've
upgraded my machine and at the moment my backup disk is unreadable :(

re-TIA

- Thomas

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Thomas Lockhart

lockhart@alumni.caltech.edu

almost 26 years ago

In reply to: Bruce Momjian (#4)

Re: Re: ODBC patch

Did we ever get this patch applied?

No. Zoltan has re-re-sent it to me, and I am planning on looking at it
and testing here.

- Thomas

Bruce Momjian

bruce@momjian.us

over 25 years ago

In reply to: Thomas Lockhart (#2)

Re: Re: ODBC patch

Can I ask about the status of this?

I modified the current ODBC driver for
* referential integrity error reporting,
* SELECT in transactions and
* disabling autocommit.

We are starting to think about organizing additional ODBC testing

Yes, sure. I know that this code (which was sent to Thomas) needs
further check. Have you had time to think about it?

Sorry to ask this: can you please re-re-send the patch to me? I've
upgraded my machine and at the moment my backup disk is unreadable :(

re-TIA

- Thomas

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Kovacs Zoltan

kovacsz@pc10.radnoti-szeged.sulinet.hu

over 25 years ago

In reply to: Bruce Momjian (#6)

Re: Re: ODBC patch

Can I ask about the status of this?

I modified the current ODBC driver for
* referential integrity error reporting,
* SELECT in transactions and
* disabling autocommit.

We are starting to think about organizing additional ODBC testing

Yes, sure. I know that this code (which was sent to Thomas) needs
further check. Have you had time to think about it?

Sorry to ask this: can you please re-re-send the patch to me? I've
upgraded my machine and at the moment my backup disk is unreadable :(

re-TIA

- Thomas

Unfortunately no new state yet. I received another patch from Max Khon,
its aim was similar. It worked mostly, but my one seemed better for a
certain test. My patch works well at our place with Borland C++ Builder 4.

I don't think the ODBC driver has any future. It's frozen. Our next
application also will not contain any ODBC, we think about using JDBC
instead. :-(

Kov\'acs, Zolt\'an
kovacsz@pc10.radnoti-szeged.sulinet.hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz