Skip site navigation (1) Skip section navigation (2)

Re: Problem with unixODBC

From: "Stergios Zissakis" <szis(at)intranet(dot)gr>
To: "Katherine Goodwin" <kat(at)clocksoft(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Problem with unixODBC
Date: 2004-03-29 12:44:38
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
try removing the username and password from the odbc.ini file; leave the
options blank.
Supply your credentials in the connect string;
"UID=<username>;PWD=<password>;DSN=<your DSN>".

It works for me.


-----Original Message-----
From: pgsql-odbc-owner(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]On Behalf Of Katherine Goodwin
Sent: Monday, March 29, 2004 3:12 PM
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Problem with unixODBC

Dear all,

I'm trying to get the ODBC driver working with Postgres so I can use the
OpenOffice data sources facilities.

I've managed to get ODBC working so that I can connect to a database but
I am unable to see any tables.

The following happens...

[etc(at)pike]$ isql test
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
SQL> help
[ISQL]ERROR: Could not SQLTables

However, if I connect using psql using the same credentials, I can see
the tables fine.

I'm assuming this is an access control / permissions type issue, but am
not sure how to fix it.

Any suggestions gratefully received.

My config files are as follows:

[ODBC Data Sources]
test = PostgreSQL

Description     =  postgres
Driver          = /usr/lib/
Database        =  jobs
Trace               = No
TraceFile           = /tmp/odbc.log
Servername          = localhost
UserName            = kat
Password            = xxxx
Port                = 5432

# Example driver definitinions
[ODBC Drivers]
PostgreSQL = Installed

# Included in the unixODBC package
Description     = ODBC for PostgreSQL
Driver          = /usr/lib/
Setup           = /usr/lib/
FileUsage       = 1

# From the MyODBC package
#Description    = ODBC for MySQL
#Driver         = /usr/lib/
#FileUsage      = 1


Many thanks in advance,


Katherine Goodwin
Clockwork Software Systems

intY has scanned this email for all known viruses (

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


In response to

pgsql-odbc by date

Next:From: SZ?CS GaborDate: 2004-03-29 12:49:18
Subject: Error Codes in 7.4 (was: Re: error 23000 is not treated in psqlODBC)
Previous:From: Katherine GoodwinDate: 2004-03-29 12:11:48
Subject: Problem with unixODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group