Re: Connecting Read-*WRITE* to ORACLE from STAROFFICE via ODBC

From: Raoul Markus <raoul.markus_at_arcormail.de>
Date: Mon, 04 Oct 1999 21:23:35 +0200
Message-ID: <37F8FEB6.FA79A31F@arcormail.de>

this is an log-file (or trace?) from two attempts to connect to ORACLE or POSTGRES, resp. Both fail to be openend for data manipulation, that means they are read-only connections, though I try desperatly to get a WRITE connection!

C. Kirsch gave the hint of missing primary keys - well there are primary keys defined on the tables, but the aren't shown in SO51. (only when I open a window 'Relationen' - whatever it does, but it shows the primary keys in their proper places)

Who knows further help?

the logging starts below ||

                         \/

Compiled for Linux (x86/glibc2) 2.2.0-pre6 (i586-pc-linux-gnu) Copyright (C) OpenLink Software.

Registered to OpenLink Demo Version
This is a 2 concurrent users license
restricted to 10 concurrent connections

oplrqb: using rulebook /usr/lib/openlink/bin/oplrqb.ini
oplrqb: bound UDP protocol to 0.0.0.0.60001
oplrqb: bound TCP protocol to 0.0.0.0.5001
oplrqb: using UDP address 127.0.0.2.0 for IPC
oplrqb: request broker started by openlink
oplrqb: spawning /usr/lib/openlink/bin/w3config/www_sv www_sv +debug
oplrqb: started persistent www_sv (pid=2574)
oplrqb: setting Environment WWW_SV
oplrqb: localhost called (127.0.0.1.1646)
oplrqb: request: domain=Postgres 95 database=mydb serveropts=
oplrqb:   connectopts= user=markus opsys=unix readonly=0
oplrqb:   application= processid=2487
oplrqb: solve mapping: pgr95:mydb:markus:other:localhost::rw
oplrqb: using mapping: pgr95:*:*:*:*:*:*
oplrqb: using [generic_pgr95] ServerProgram=pgr95_sv
oplrqb: connect params: domain=Postgres 95 db=mydb serveropts= readonly=0
oplrqb:   connectopts= user=markus opsys=unix machine=localhost

application=

oplrqb: spawning /usr/lib/openlink/bin/pgr95_sv generic_pgr95 +debug
oplrqb: asking agent for server handle
oplrqb: setting Environment POSTGRES
oplrqb: change environment 'ODBC_CATALOGS' -> 'Y'
oplrqb: change environment 'PG_DATA' -> '/var/local/pgsql'

generic_pgr95: server starting

oplrqb: got it!
oplrqb: asking agent for connection handle
oplrqb: got it!
oplrqb: accepted markus_at_localhost.

generic_pgr95: * 3: CREATE TABLE/PRIMARY KEY will create implicit index tabelle2_pkey for table tabel
le2 (0)
generic_pgr95: ** 3: ERROR: pg_rewrite: Permission denied. (1) oplrqb: unmap markus_at_localhost.
oplrqb: killing generic_pgr95 agent (pid=2575) generic_pgr95: got SIGTERM
generic_pgr95: server shutting down

oplrqb: pid 2575 died with exit code 0
oplrqb: agent died (pid=2575)
oplrqb: removing agent generic_pgr95 with 0 connections
oplrqb: localhost called (127.0.0.1.1697)
oplrqb: request: domain=Oracle 8 database= serveropts=
oplrqb:   connectopts= user=caddok opsys=unix readonly=0
oplrqb:   application= processid=2487
oplrqb: solve mapping: ora8::caddok:other:localhost::rw
oplrqb: using mapping: ora8:*:*:*:*:*:*
oplrqb: using [generic_ora8] ServerProgram=ora8_sv
oplrqb: connect params: domain=Oracle 8 db= serveropts= readonly=0
oplrqb:   connectopts= user=caddok opsys=unix machine=localhost

application=

oplrqb: spawning /usr/lib/openlink/bin/ora8_sv generic_ora8 +debug
oplrqb: asking agent for server handle
oplrqb: setting Environment ORACLE8
oplrqb: change environment 'ORACLE_HOME' ->

'/usr/oracle/u01/app/oracle/product/8.0.5' oplrqb: change environment 'ORACLE_SID' -> 'ORCL' oplrqb: change environment 'ODBC_CATALOGS' -> 'Y' generic_ora8: server starting

oplrqb: got it!
oplrqb: asking agent for connection handle
oplrqb: got it!
oplrqb: accepted caddok_at_localhost.
oplrqb: unmap caddok_at_localhost.
oplrqb: killing generic_ora8 agent (pid=2625)

generic_ora8: got SIGTERM
generic_ora8: server shutting down

oplrqb: pid 2625 died with exit code 0
oplrqb: agent died (pid=2625)
oplrqb: removing agent generic_ora8 with 0 connections
oplrqb: UDP broadcast failed (Network is unreachable)

hugh_williams_at_my-deja.com wrote:

> Can I suggest you log a call a support call with us via our online WEB
>
Received on Mon Oct 04 1999 - 14:23:35 CDT