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