pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: [INTERFACES] NEW ODBC DRIVER v06-40-0007
3+ messages / 2 participants
[nested] [flat]

* Re: [INTERFACES] NEW ODBC DRIVER v06-40-0007
@ 1999-09-03 03:13  Ken J. Wright <ken@ori-ind.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Ken J. Wright @ 1999-09-03 03:13 UTC (permalink / raw)
  To: Byron Nikolaidis <byron.nikolaidis@home.com>; pgsql-interfaces@hub.org

Thanks Byron!!

At 23:17 09/02/1999 -0400, Byron Nikolaidis wrote:
>
>Hi,
>
>I've posted a new odbc driver at the following locations:





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* NEW ODBC DRIVER v06-40-0007
@ 1999-09-03 03:17  Byron Nikolaidis <byron.nikolaidis@home.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Byron Nikolaidis @ 1999-09-03 03:17 UTC (permalink / raw)
  To: pgsql-interfaces@hub.org


Hi,

I've posted a new odbc driver at the following locations:

ftp://ftp.postgresql.org/pub/odbc/

AND

http://members.home.net/byron.nikolaidis  (my personal homepage).   Note
I have disabled downloading the full install version because of
bandwidth limitations on my ISP, but the source and dll and everything
else is there.

I'm not sure if there is a link from the postgres web site to the driver
yet.

If there are any problems, with the driver or the downloading or html
stuff, please let me know.

Byron

Attachments:

v06-40-0007.txt (text/plain, 452B) download version.txt date: 09/02/99 version: 06.40.0007 ---------------------------------------------------------------------- This file describes changes and or fixes since the last update. NEW FEATURES: none BUG_FIXES: 1. Fix all info functions to check whether the table is a view. 2. Fix for Access 2000 (unconfirmed) 3. Change most statement errors to General Error S1000 instead of 08S01 (communication link failure).
^ permalink raw reply [nested|flat] 3+ messages in thread

* Re: [INTERFACES] NEW ODBC DRIVER v06-40-0007
@ 1999-09-03 04:24  Ken J. Wright <ken@ori-ind.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Ken J. Wright @ 1999-09-03 04:24 UTC (permalink / raw)
  To: Byron Nikolaidis <byron.nikolaidis@home.com>; pgsql-interfaces@hub.org

>BUG_FIXES:
>
>1.  Fix all info functions to check whether the table is a view.
>
>2.  Fix for Access 2000 (unconfirmed)
>
>3.  Change most statement errors to General Error S1000 instead of 08S01
>    (communication link failure).

Byron,

Number 3 is still causing trouble.

from statement.h
#define STMT_BAD_ERROR 27

from environ.c
case STMT_BAD_ERROR:
   strcpy(szSqlState, "08S01");
   // communication link failure

This is the SQLSTATE the driver is returning when there is a failure from
attempting to duplicate a unique index. It appears to be coming from
SC_execute() in statement.c. The following code is executed if there is not
a result set returned (like from a select). It looks like there needs to be
more checking for other types of non-result set type failures. Create is
the only action looked at here, otherwise it's lumped in with the comm link
failures (STMT_BAD_ERROR).

} else {		/* Bad Error -- The error message will be in the Connection */

	if (self->statement_type == STMT_TYPE_CREATE) {
		self->errornumber = STMT_CREATE_TABLE_ERROR;
		self->errormsg = "Error creating the table";
		/*	This would allow the table to already exists, thus appending
			rows to it.  BUT, if the table didn't have the same attributes,
			it would fail.
			return SQL_SUCCESS_WITH_INFO;
		*/
	}
	else {
		self->errornumber = STMT_BAD_ERROR;
		self->errormsg = "Error while executing the query";
	}

Ken




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-09-03 04:24 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-09-03 03:13 Re: [INTERFACES] NEW ODBC DRIVER v06-40-0007 Ken J. Wright <ken@ori-ind.com>
1999-09-03 03:17 NEW ODBC DRIVER v06-40-0007 Byron Nikolaidis <byron.nikolaidis@home.com>
1999-09-03 04:24 Re: [INTERFACES] NEW ODBC DRIVER v06-40-0007 Ken J. Wright <ken@ori-ind.com>

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