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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dariusz Pietrzak | 2001-06-16 13:00:50 | ODBC & ssl. |
Previous Message | Hiroshi Inoue | 2001-06-16 01:06:10 | RE: [ODBC] Re: ODBC Interface version 07_01_0005, problemwith C++ exceptions |