It's rumoured that Greg Maples once said:
> My best guess is that the odbc driver code expects some level of
> Reliability in the connection and the port is either jabbering or
> Colliding. Not much else would make sense.
There is a known bug in the driver that causes exactly the symptoms you
describe in pgAdmin and would probably affect DTS as well. In a nutshell,
recent versions of Redhat Linux have an extemely long compiler version
string that consequently make the PostgreSQL version string very long. In
ealier versions of psqlODBC, this would cause a crash at logon when the
database version was requested using the SQLInfo function because a
temporary buffer created to store the data would overflow.
Did you try the updated driver yet that was suggested?
Regards, Dave.