[SOLVED] ISQL to connect to postgres in linux - [08S01]Could not send Query(connection dead) error

Hi,

I have postgres installed in linux and have my dsn setup as below

odbc.ini
[db]
Description = PostgreSQL connection to 'db' database
Driver = PostgreSQL
Database = db
Servername = localhost
UserName = db
Password = password
Trace = Yes
TraceFile = /logfilepath
Port = actualportnumbr
#Protocol =
#ReadOnly = No
#RowVersioning = No
#ShowSystemTables = No
#ShowOidColumn = No
#FakeOidIndex = No
#ConnSettings =

When I am logged in as myself,

[me@myip ]$ isql db db pass(from dsn) -v

SQL> drop table test1;
[08S01]Could not send Query(connection dead);
Could not send Query(connection dead)
[ISQL]ERROR: Could not SQLExecute
SQL> quit

But when I am logged as root

[root@myip]# isql db db pass(from dsn) -v
SQL> drop table test1; is success

OR

just login with db without explicitly specifying username/pass

[root@myip]# isql db -v
SQL> drop table test1; is success

SQL> SELECT rolname, rolsuper, rolcreaterole, rolcreatedb, rolcanlogin FROM pg_roles;

+-----------------------------------------------------------------+---------+--------------+------------+------------+
| rolname | rolsuper| rolcreaterole| rolcreatedb| rolcanlogin|
+-----------------------------------------------------------------+---------+--------------+------------+------------+

| me | 1 | 0 | 0 | 1 |

| db | 1 | 0 | 0 | 1 |

Am I missing any permissions? Any help would be appreciated