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
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, query='declare SQL_CUR095D0040 cursor for SELECT Config,
nValue FROM MSysConf'
>>ERROR from backend during send_query: 'ERROR: Relation 'msysconf' does
>>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
pgsql-odbc by date
|Next:||From: Dariusz Pietrzak||Date: 2001-06-16 13:00:50|
|Subject: ODBC & ssl.|
|Previous:||From: Hiroshi Inoue||Date: 2001-06-16 01:06:10|
|Subject: RE: [ODBC] Re: ODBC Interface version 07_01_0005, problemwith C++ exceptions|