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