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

Problem with unixODBC

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 (view raw or flat)
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)


Responses

pgsql-odbc by date

Next:From: Stergios ZissakisDate: 2004-03-29 12:44:38
Subject: Re: Problem with unixODBC
Previous:From: Shachar ShemeshDate: 2004-03-27 07:49:48
Subject: Re: Performance-problem

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