Thread: ODBC: Could not send Query to backend; Socket has been closed

Migrated our entire DB to postgresql on Friday evening, with no
problems, so it went live. Everything was fine up until 40 minutes ago,
when suddenly the box died forcing me to power cycle it.

Following that I am now getting the following errors from our NT server
box:

   Microsoft OLE DB Provider for ODBC Drivers error '80004005'
   Could not send Query to backend; Could not send Query to backend;
Socket has been closed

I can connect fine with pgAdmin II on a number of boxes, it just seems
to be the ODBC connections that are failing big time. The database
appears intact, just doesn't make any sense.

Help!



Yours Unwhettedly,
Robert John Shepherd.

Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk

For a copy of my Public PGP key, email: pgp@robertsworld.org.uk

"Robert John Shepherd" <robert@reviewer.co.uk> writes:
> Following that I am now getting the following errors from our NT server
> box:

>    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>    Could not send Query to backend; Could not send Query to backend;
> Socket has been closed

What shows up in the postmaster log?

It might also be worth checking basic connectivity (can you ping the DB
server from the NT box and vice versa).

            regards, tom lane

> What shows up in the postmaster log?

Nothing of any relevance.


> It might also be worth checking basic connectivity (can you ping the
DB
> server from the NT box and vice versa).

It isn't a connectivity issue, but it was caused by a connectivity issue
(the database box died, and rebooted). :/


Yours Unwhettedly,
Robert John Shepherd.

Editor
DVD REVIEWER
The UK's BIGGEST Online DVD Magazine
http://www.dvd.reviewer.co.uk

For a copy of my Public PGP key, email: pgp@robertsworld.org.uk