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@bct-solutions.co.uk