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: [EMAIL PROTECTED]
