Re: Problem with unixODBC

Hi,
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.

Regards,
Stergios

-----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
SQL>

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.ini:
-------------------------------------
[ODBC Data Sources]
test = PostgreSQL

[test]
Description = postgres
Driver = /usr/lib/libodbcpsql.so.1
Database = jobs
Trace = No
TraceFile = /tmp/odbc.log
Servername = localhost
UserName = kat
Password = xxxx
Port = 5432
-------------------------------------

odbcinst.ini:
-------------------------------------
# Example driver definitinions
#
#
[ODBC Drivers]
PostgreSQL = Installed

# Included in the unixODBC package
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
FileUsage = 1

# From the MyODBC package
#[MySQL]
#Description = ODBC for MySQL
#Driver = /usr/lib/libmyodbc.so
#FileUsage = 1

-------------------------------------

Many thanks in advance,

Kat

--
Katherine Goodwin
Clockwork Software Systems

intY has scanned this email for all known viruses (www.inty.com)

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

http://archives.postgresql.org