Re: changed behavior in libpq odbc driver

> -----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