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

Re: changed behavior in libpq odbc driver

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Scot Loach" <sloach(at)sandvine(dot)com>,"Anoop Kumar" <anoopk(at)pervasive-postgres(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: changed behavior in libpq odbc driver
Date: 2005-08-31 13:08:10
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4AC9D9D@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
 

> -----Original Message-----
> From: Scot Loach [mailto:sloach(at)sandvine(dot)com] 
> Sent: 31 August 2005 13:52
> To: Anoop Kumar
> Cc: pgsql-odbc(at)postgresql(dot)org; Dave Page
> Subject: RE: [ODBC] changed behavior in libpq odbc driver
> 
> That didn't fix it, it still returns HY000.
> 
> This is the error message that comes back:
> 
> FATAL:  terminating connection due to administrator command
> server closed the connection unexpectedly
> This probably means the server terminated abnormally

Odd - it works for me:

	Successfully connected to DSN 'unicode'.
SQLGetInfo:
				In:
ConnectionHandle = 0x003B14B8, InfoType = SQL_DBMS_VER=18, InfoValuePtr
= 0x000A73A0, BufferLength = 600, StringLengthPtr = 0x000ADFD8, 
	
Information Value Type = SQL_C_WCHAR=-8
				Return:	SQL_SUCCESS=0
				Out:			*InfoValuePtr =
"08.01.0004 PostgreSQL 8.0.3 on i686-pc-mingw32, co...",
*StringLengthPtr = 173
SQLExecDirect:
				In:
Statementhandle = 0x003B16C0, StatementText = "SELECT version()",
Statementlength = 16
				Return:	SQL_ERROR=-1
				stmt:		szSqlState = "08S01",
*pfNativeError = 27, *pcbErrorMsg = 169, *ColumnNumber = -2, *RowNumber
= -2
	
MessageText = "Error while executing the query;
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request."


What steps are you using to repeat the failure at your end? I'm doing:

1) Open connection
2) Call SQLGetInfo and doubly confirm we're connected.
3) Stop the server.
4) Execute a query.

Regards, Dave

pgsql-odbc by date

Next:From: Scot LoachDate: 2005-08-31 13:46:57
Subject: Re: changed behavior in libpq odbc driver
Previous:From: Scot LoachDate: 2005-08-31 12:52:00
Subject: Re: changed behavior in libpq odbc driver

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