Complete newbie question on odbc

Hi,

I'm having some problems with creating an odbc connection between postreSQL
8.2 and a multi-value database (Univision) -. I have 2 situations, one that
works, and one that doesn't - unfortunately I need to use the one that
doesn't.

Situation 1.

I have Univision loaded onto my PC running XP, and the postgreSQL database
on a linux server.

I create the odbc connection via windows in Control Panel/Administrative
Tools/Data Sources.

In Univision I create an odbc link to a table in the postgreSQL database. I
am prompted that I need to define a key for the table.

After this, I can see the table definition and the data.

Situation 2.

I have both Univision and the postgreSQL database on a linux server.

I'm using unixODBC and the driver that is supplied as part of the postgreSQL
installation. I haven't loaded anything different.

I've set up the odbc.ini file as below.

[PostgreSQL]
Description = Postgres
Driver = PostgreSQL
Trace = No
Tracefile =
Database = lx021
Servername = localhost
UserName = XXXXX
Password = yyyyy
Port = 5432
Protocol = 6.4
Readonly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =

With this setup, I can create a link to a table in the postgreSQL database,
but I am not prompted that I need to define a key for the table.

I can see the table definition in Univision, and the key has been set to oid
(which doesn't exist on the table).

I can't see the data, I guess because the key is wrong.

I only need the data read only, I have tried changing the Readonly setting
to Yes, but that didn't help.

I'm sure I'm doing something wrong, probably in the set up of the data
source above, but can't work out what it is. If anyone could point me in the
right direction, thank you very much!

Terri Reid

BCT Software Solutions

Mail: treid(at)bct-solutions(dot)co(dot)uk