From: | Jorge Santos <jsf(at)dep3(dot)fciencias(dot)unam(dot)mx> |
---|---|
To: | Postgresql ODBC <pgsql-odbc(at)postgresql(dot)org>, debian-user(at)lists(dot)debian(dot)org |
Subject: | Postgresql 7.1 + unixODBC 2.0.5 + StarOffice 5.2 |
Date: | 2001-05-18 20:50:22 |
Message-ID: | 87g0e2jsa9.fsf@dep3.fciencias.unam.mx |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hello,
I have installed all the above (see subject) software and whenever I
try to see the tables in a database with DataManager (a program
supplied alongside unixODBC), th program just won't show any tables.
The same problem happens with StarOffice. I know the driver manager
and database driver are working because I can perform queries through
DataManager or isql (the command line interface to ODBC provided with
unixODBC), the problem is I think StarOffice will need to see the
tables in order to let me get the information I requiere from the
database.
Any ideas why this might be happening. My .odbc.ini and odbcinst.ini
follow:
.odbc.ini:
[dep-2001-1]
Description = Base de datos dep-2001-1
Driver = PostgreSQL
Trace = Yes
Database = dep-2001-1
Servername = localhost
UserName = dep
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
[test]
Description = PostgreSQL
Driver = PostgreSQL
Trace = Yes
Database = template1
Servername = localhost
UserName = postgres
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
[kk]
Description = Base de datos jsf (tabla kk)
Driver = PostgreSQL
Trace = Yes
TraceFile =
Database = jsf
Servername = localhost
UserName = jsf
Password =
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = Yes
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
.odbcinst.ini:
[ODBC]
Trace = Yes
Trace File = /tmp/sql.log
Pooling = No
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/libodbcpsql.so.1
Setup = /usr/lib/libodbcpsqlS.so.1
FileUsage = 1
As you can see I have Trace turned on but I haven't been able to make
much sense of its contens, if it might be worthed, tell me and I'll
mail it.
thanks
jorge santos
From | Date | Subject | |
---|---|---|---|
Next Message | root | 2001-05-19 15:44:17 | dowloading of ODBC drivers |
Previous Message | Ing. Ivo Schwarzer | 2001-05-18 08:17:57 | TEXT fields with size > 8190 |