Skip site navigation (1) Skip section navigation (2)

RV: no updateable recordset

From: Manuel Martínez Valls <mmartinezv(at)sanostra(dot)es>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: RV: no updateable recordset
Date: 2001-06-16 11:19:37
Message-ID: NFBBLONJBDILGHLJNCHDKEKDCBAA.mmartinezv@sanostra.es (view raw or flat)
Thread:
Lists: pgsql-odbc
Hi,

	I'm trying to access to a postgreSQL database via ODBC. I'm able to read
the data without any problem from VB on windows, but I can't update or
insert any record.

	I have NOT checked the 'read only' option of the driver.

	I'm using Postgres 7.1.2 on a SuSE 6.3 Linux, and the 7.01.0005 driver. But
I had the problem previously (with version 7.0.2 and an older version of the
driver).

	I can insert or update a record from 'psql' or via the unixODBC driver
installed on the same machine.

	There's another extrange thing, I'm not able to modify any record, but I
can do a drop table via odbc (so the table is not read only). I'm using the
visual basic sample VisData to do the test. I've read something about a
msysconf file or table, in the logs I see the following:
>> Relation 'msysconf' does not exist'

>>conn=152710432,
SQLDriverConnect(out)='DSN=test;DATABASE=test;SERVER=server;
>>PORT=5432;UID=postgres;PWD=XXXX;READONLY=0;PROTOCOL=6.4;FAKEOIDINDEX=0;
>>SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
>>conn=152710432,query='BEGIN'
>>conn=152710432, query='declare SQL_CUR095D0040 cursor for SELECT Config,
nValue FROM MSysConf'
>>ERROR from backend during send_query: 'ERROR:  Relation 'msysconf' does
not exist'
>>conn=152710432, query='ABORT'
>>STATEMENT ERROR: func=SC_execute, desc='', errnum=-1, errmsg='Error while
executing the query (non-fatal)'

	Does this mean that my databases should contain any tables to allow odbc
(write)connections? Can anybody help me?


Thanks in advance,

	Manuel Martínez Valls


Responses

pgsql-odbc by date

Next:From: Dariusz PietrzakDate: 2001-06-16 13:00:50
Subject: ODBC & ssl.
Previous:From: Hiroshi InoueDate: 2001-06-16 01:06:10
Subject: RE: [ODBC] Re: ODBC Interface version 07_01_0005, problemwith C++ exceptions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group