pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedOdbc postgresql database is readonly
2+ messages / 2 participants
[nested] [flat]
* Odbc postgresql database is readonly
@ 2000-06-27 11:28 Michel Claes <Michel.Claes@dexia.be>
0 siblings, 1 reply; 2+ messages in thread
From: Michel Claes @ 2000-06-27 11:28 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
I have installed succesfully postgresql on my linux server, and psqlodbc on my NT4-SP5 workstation.
When I try to connect to my database with access 97 it is always in readonly mode. I have unchecked the read-only options in the odbc manager, the problem persist...
In psqlodbc.log you can see that readonly=1 (it should be 0).
Do tou have a solution ?
Odbc driver version 6.50.0000
Postgresql version 6.3.2-15 running on debian server.
Please find attached : psqlodbc.log, the odbc registry and the DSN registry. (I have replaced the password by '******').
Regards.
Michel.
Attachments:
reg2.reg (text/plain, 379B) download
REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\PostgreSQL]
"Driver"="C:\\WINNT\\System32\\PSQLODBC.DLL"
"Description"="claemdb"
"Database"="claemdb"
"Servername"="ddr-lsrv1-pa.dr.dexia.be"
"Port"="5432"
"Username"="claem"
"Password"="******"
"ReadOnly"="0"
"ShowOidColumn"="0"
"FakeOidIndex"="0"
"RowVersioning"="0"
"ShowSystemTables"="0"
"Protocol"="6.3"
"ConnSettings"=""
reg1.reg (text/plain, 614B) download
REGEDIT4
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
"APILevel"="1"
"ConnectFunctions"="YYN"
"Driver"="C:\\WINNT\\System32\\PSQLODBC.DLL"
"DriverODBCVer"="02.00"
"FileUsage"="0"
"Setup"="C:\\WINNT\\System32\\PSQLODBC.DLL"
"SQLLevel"="1"
"UsageCount"=dword:00000001
"Fetch"="100"
"CommLog"="1"
"Optimizer"="1"
"Ksqo"="1"
"UniqueIndex"="0"
"ReadOnly"="0"
"UseDeclareFetch"="0"
"UnknownSizes"="0"
"TextAsLongVarchar"="1"
"UnknownsAsLongVarchar"="0"
"BoolsAsChar"="1"
"Parse"="0"
"CancelAsFreeStmt"="0"
"MaxVarcharSize"="254"
"MaxLongVarcharSize"="8190"
"ExtraSysTablePrefixes"="dd_;"
"ConnSettings"=""
psqlodbc_138.log (text/plain, 3.4K) download
conn=111163552, SQLDriverConnect( in)='DSN=PostgreSQL;DATABASE=claemdb;SERVER=ddr-lsrv1-pa.dr.dexia.be;PORT=5432;READONLY=1;PROTOCOL=6.3;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS=;', fDriverCompletion=3
DSN info: DSN='PostgreSQL',server='ddr-lsrv1-pa.dr.dexia.be',port='5432',dbase='claemdb',user='claem',passwd='asimov'
onlyread='1',protocol='6.3',showoid='0',fakeoidindex='0',showsystable='0'
conn_settings=''
translation_dll='',translation_option=''
Global Options: Version='06.50.0000', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn=111163552, query=' '
conn=111163552, query='set DateStyle to 'ISO''
conn=111163552, query='set geqo to 'OFF''
conn=111163552, query='set ksqo to 'ON''
NOTICE from backend during send_query: 'NOTICE: Unrecognized variable ksqo
'
conn=111163552, query='select oid from pg_type where typname='lo''
[ fetched 0 rows ]
conn=111163552, SQLDriverConnect(out)='DSN=PostgreSQL;DATABASE=claemdb;SERVER=ddr-lsrv1-pa.dr.dexia.be;PORT=5432;UID=claem;PWD=asimov;READONLY=1;PROTOCOL=6.3;FAKEOIDINDEX=0;SHOWOIDCOLUMN=0;ROWVERSIONING=0;SHOWSYSTEMTABLES=0;CONNSETTINGS='
conn=111163552, query='SELECT Config, nValue FROM MSysConf'
ERROR from backend during send_query: 'ERROR: msysconf: Table does not exist.'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=111163552, stmt=112525376, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT Config, nValue FROM MSysConf'
stmt_with_params='SELECT Config, nValue FROM MSysConf'
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR06B50040'
----------------QResult Info -------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=110, errmsg='ERROR: msysconf: Table does not exist.'
------------------------------------------------------------
henv=111156808, conn=111163552, status=1, num_stmts=16
sock=111156824, stmts=111156872, lobj_type=-999
---------------- Socket Info -------------------------------
socket=316, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=111169888, buffer_out=111173992
buffer_filled_in=42, buffer_filled_out=0, buffer_read_in=42
conn=111163552, query='SELECT "users"."userid" FROM "users" '
[ fetched 3 rows ]
conn=111163552, query='SELECT "userid","firstname","lastname" FROM "users" WHERE "userid" = 'CLAEM' OR "userid" = 'USLKS' OR "userid" = 'EMULP' OR "userid" = 'EMULP' OR "userid" = 'EMULP' OR "userid" = 'EMULP' OR "userid" = 'EMULP' OR "userid" = 'EMULP' OR "userid" = 'EMULP' OR "userid" = 'EMULP''
[ fetched 3 rows ]
conn=111163552, SQLDisconnect
* RE: Odbc postgresql database is readonly
@ 2000-06-29 03:54 Joe Shevland <shevlandj@kpi.com.au>
parent: Michel Claes <Michel.Claes@dexia.be>
0 siblings, 0 replies; 2+ messages in thread
From: Joe Shevland @ 2000-06-29 03:54 UTC (permalink / raw)
To: Michel Claes <Michel.Claes@dexia.be>; pgsql-interfaces
There's two places to uncheck the read-only flag... in the datasource definition and also the global driver settings.
Also, make sure that your linked tables have a unique index or primary key defined as otherwise they'll be marked as read-only (Access needs a PK or index to do inserts/updates... well Access needs a lot of things :).
Cheers,
Joe
>-----Original Message-----
>From: pgsql-interfaces-owner@hub.org
>[mailto:pgsql-interfaces-owner@hub.org]On Behalf Of Michel Claes
>Sent: Tuesday, 27 June 2000 9:29 PM
>To: pgsql-interfaces
>Subject: [INTERFACES] Odbc postgresql database is readonly
>
>
>Hi,
>
>I have installed succesfully postgresql on my linux server, and
>psqlodbc on my NT4-SP5 workstation.
>When I try to connect to my database with access 97 it is always
>in readonly mode. I have unchecked the read-only options in the
>odbc manager, the problem persist...
>In psqlodbc.log you can see that readonly=1 (it should be 0).
>Do tou have a solution ?
>
>Odbc driver version 6.50.0000
>Postgresql version 6.3.2-15 running on debian server.
>
>Please find attached : psqlodbc.log, the odbc registry and the DSN
>registry. (I have replaced the password by '******').
>
>
>
>Regards.
>
>Michel.
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-06-29 03:54 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-27 11:28 Odbc postgresql database is readonly Michel Claes <Michel.Claes@dexia.be>
2000-06-29 03:54 ` Joe Shevland <shevlandj@kpi.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox