Re: changed behavior in libpq odbc driver

My mistake, I tried it again and it does seem to be working now - I must not have updated properly for my last compile.

scot.

-----Original Message-----
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Wednesday, August 31, 2005 9:08 AM
To: Scot Loach; Anoop Kumar
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: RE: [ODBC] 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