Skip site navigation (1) Skip section navigation (2)

Re: Error handling in ODBC

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-odbc <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Error handling in ODBC
Date: 2001-06-18 06:06:05
Message-ID: 3B2D9A4D.13B1053A@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Dave Page wrote:
> 
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> > Sent: 14 June 2001 11:09
> > To: Dave Page
> > Cc: Zoltan Kovacs; pgsql-odbc
> > Subject: Re: [ODBC] Error handling in ODBC
> >
> >
> > Dave Page wrote:
> > >
> >
> > [snip]
> >
> > >
> > > As far as I can tell, it is then not possible to access the notice
> > > from a client app (cetainly SQLError won't return it in my
> > test prog,
> > > yet I can quite happily get a real error from an invalid query for
> > > example.
> > >
> >
> > Hmm it may be possible that SQLERROR returns a notice message
> > in an appropriate condition(?????) though I'm not sure.
> 
> Unfortunately I'm not really familiar enough with either C or the guts of
> the driver to know or be able to figure out in a reasonable amount of time
> (though I have spent hours staring at the code :-)) what exactly it is/is
> trying to do. I do know it's not doing what I need it to :-(, and - I
> suspect - what it should be doing (though these are not necessarily one and
> the same).
> 

IMHO *ERROR* messages should return SQL_ERROR with the SQLSTATE <>
"00000". As for NOTICEs we seem to be able to change the driver to
return SQL_SUCCESS_WITH_INFO and let the succeeding SQLError() to
return the NOTICE message.
However I've not recognized the circumstances why both ERRORs and
(some) NOTICEs return SQL_ERROR with the SQLSTATE = '00000' now. 

Comments ?

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Dariusz PietrzakDate: 2001-06-18 08:05:19
Subject: Feature request -> autoreconnect.
Previous:From: Hiroshi InoueDate: 2001-06-18 02:14:04
Subject: Re: Re: MSACCESS & Apostrophe in Column Name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group