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

I am only briefly familiar with isql but is your odbc.ini file posted the system wide i.e. /etc/odbc.ini file? If so does it have read permissions for all or by your me user? There is also a user specific dsn file i.e. $HOME/.odbc.ini by default that would over ride the system wide file. Does it exist for your user me and is it different? From my initial guess it isn't necessarily a role problem because you should be connecting as username db regardless of who you are logged in as i.e. me or root.

1 members found this post helpful.

Thank you the help.
The home dir had
Protocol = 9.2
which was commented in /etc.

when I changed home to have the same as /etc, it worked.

I am new to odbc setup (I am a programmer) - Could you please let me know how without giving the userid and password explicity, it still works?
Does it take the information from odbc.ini file?

Yes. The default configuration is read from the ini file first and then any command line options would override those in the file.

thank you