|
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] 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@xxxxxxxxxxxxxxxxxxx |
