From: | Katherine Goodwin <kat(at)clocksoft(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem with unixODBC |
Date: | 2004-03-29 12:11:48 |
Message-ID: | 40681284.10100@clocksoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Stergios Zissakis | 2004-03-29 12:44:38 | Re: Problem with unixODBC |
Previous Message | Shachar Shemesh | 2004-03-27 07:49:48 | Re: Performance-problem |