Re: New 9.5.0100 does not work properly - Mailing list pgsql-odbc

On 01/12/2016 08:22 AM, Walter Willmertinger wrote:
> I just installed the new psql-odbc-9-5..msi, started MS Access 2013 (64

As I understand the MSI's have been split out again, so which one did
you install x86, x64, or the all-in-one package?

> bit), opened a form where a Postgresql-table is connected by ODBC. So
> long as I do just read data, all is working. When I try to update data
> in this form (which is saved in the corresponding Postgresql-table), I
> get the write conflict.
>
> After uninstalling psql.odbc in Windows "Program and Features) and
> reinstalling the older 9-3 or 9.4 version, reading and updating is possible.

 From a specific package or the all-in-one installer?

>
>
> Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> schrieb am Di., 12. Jan. 2016 um
> 16:58 Uhr:
>
>     On 01/12/2016 12:36 AM, Walter Willmertinger wrote:
>
>     Ccing list, so more eyes can see this.
>
>      > The "Write Conflict" is independent of the setting "row versioning".
>      > When I strted it was switched off. I switched to "On", but the
>     same result.
>
>     What did you do in between?
>
>     In other words did you disconnect/reconnect from the database, log
>     out/log in, rboot, etc?
>
>     I have had issues with ODBC not catching changes to its conf, especially
>     when there is a live connection.
>
>      >
>      > _Here is an excerpt from mylog:_
>      >
>      > /[7.065]conn=000001F55B153090, query='SELECT
>      >
>
"KundenCode","DatumEreignis","AufnahmeDurchPersonalNr","WeiterAnPersonalNr","Status","Notiz","KdID","Prioritaet","ProgErledigt","update_cs","ZuletztBearbeitetPersonalNr"
>      > FROM "public"."Notizen" WHERE "KundenCode" = E'1' AND "KdID" = 83'
>      > [8.455]ParseAndDescribeWithLibpq: plan_name= query=UPDATE
>      > "public"."Notizen" SET "Notiz"=$1 WHERE "KundenCode" = $2 AND
>     "KdID" =
>      > $3 AND "DatumEreignis" = $4 AND "AufnahmeDurchPersonalNr" = $5 AND
>      > "WeiterAnPersonalNr" = $6 AND "Status" = $7 AND "Prioritaet" IS
>     NULL AND
>      > "ProgErledigt" = $8 AND "update_cs" = $9 AND
>      > "ZuletztBearbeitetPersonalNr" IS NULL
>      > [8.456]conn=000001F55B153090, query='BEGIN'
>      > [8.457]ParseWithLibpq: plan_name= query=UPDATE "public"."Notizen" SET
>      > "Notiz"=$1 WHERE "KundenCode" = $2 AND "KdID" = $3 AND
>     "DatumEreignis" =
>      > $4 AND "AufnahmeDurchPersonalNr" = $5 AND "WeiterAnPersonalNr" =
>     $6 AND
>      > "Status" = $7 AND "Prioritaet" IS NULL AND "ProgErledigt" = $8 AND
>      > "update_cs" = $9 AND "ZuletztBearbeitetPersonalNr" IS NULL
>      > [8.460]conn=000001F55B153090, query='UPDATE "public"."Notizen" SET
>      > "Notiz"=E'Test xxx' WHERE "KundenCode" = E'1' AND "KdID" = 83 AND
>      > "DatumEreignis" = E'2015-09-30 13:48:13'::timestamp AND
>      > "AufnahmeDurchPersonalNr" = 80 AND "WeiterAnPersonalNr" = 80 AND
>      > "Status" = E'E' AND "Prioritaet" IS NULL AND "ProgErledigt" =
>     E'0' AND
>      > "update_cs" = E'2015-09-30 13:48:15'::timestamp AND
>      > "ZuletztBearbeitetPersonalNr" IS NULL'
>      > [8.464]conn=000001F55B153090, query='ROLLBACK'/
>
>     On the face of it the above looks alright. I have seen issues such as
>     you describe with Access and Postgres when using fractional second
>     timestamps, but the above uses integer seconds.
>
>      >
>      > _Here is my "ODBC.INI":_
>      > /[ODBC 32 bit Data Sources]/
>      > /PgSQL_CONSYS=PostgreSQL ANSI(x64) (32 bit)
>      > /
>      > /[PgSQL_CONSYS]
>      > /
>      > /Driver32=C:\Program Files\psqlODBC\0903\bin\psqlodbc30a.dll/
>      >
>      > *But it's Access 2013 64-bit!*
>
>     How did you install psqlodbc and from what source?
>
>     Also what OS and version are you running  on?
>
>     I do not fully understand the 32/64 bit thing in Windows, so I will
>     point you at this:
>
>     https://odbc.postgresql.org/faq.html#6.8
>
>      >
>      > _Here my registry settings for this ODBC-Entry:_
>      >
>      > /[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\PgSQL_CONSYS]/
>      > /"Driver"="C:\\Program Files\\psqlODBC\\0903\\bin\\psqlodbc30a.dll"/
>      > /"CommLog"="1"/
>      > /"Debug"="0"/
>      > /"Fetch"="100"/
>      > /"Optimizer"="0"/
>      > /"Ksqo"="1"/
>      > /"UniqueIndex"="1"/
>      > /"UseDeclareFetch"="0"/
>      > /"UnknownSizes"="0"/
>      > /"TextAsLongVarchar"="1"/
>      > /"UnknownsAsLongVarchar"="0"/
>      > /"BoolsAsChar"="1"/
>      > /"Parse"="0"/
>      > /"CancelAsFreeStmt"="0"/
>      > /"MaxVarcharSize"="255"/
>      > /"MaxLongVarcharSize"="8190"/
>      > /"ExtraSysTablePrefixes"="dd_;"/
>      > /"Description"="Access 64 Bit"/
>      > /"Database"="consys"/
>      > /"Servername"="col"/
>      > /"Port"="5445"/
>      > /"Username"="XXXXX"/
>      > /"UID"="YYYYY"/
>      > /"Password"="ZZZZZZ"/
>      > /"ReadOnly"="0"/
>      > /"ShowOidColumn"="0"/
>      > /"FakeOidIndex"="0"/
>      > /"RowVersioning"="0"/
>      > /"ShowSystemTables"="0"/
>      > /"Protocol"="7.4-1"/
>      > /"ConnSettings"=""/
>      > /"DisallowPremature"="0"/
>      > /"UpdatableCursors"="0"/
>      > /"LFConversion"="1"/
>      > /"TrueIsMinus1"="1"/
>      > /"BI"="0"/
>      > /"AB"="0"/
>      > /"ByteaAsLongVarBinary"="0"/
>      > /"UseServerSidePrepare"="0"/
>      > /"LowerCaseIdentifier"="0"/
>      > /"GssAuthUseGSS"="0"/
>      > /"SSLmode"="allow"/
>      > /"XaOpt"="1"/
>      > /"KeepaliveTime"="-1"/
>      > /"KeepaliveInterval"="-1"/
>      >
>      >
>      > Maybe this can help you in debugging?
>      >
>      >
>      >
>      > Adrian Klaver <adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>
>      > <mailto:adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>>> schrieb am Di., 12. Jan. 2016 um
>      > 00:21 Uhr:
>      >
>      >     On 01/11/2016 06:26 AM, Walter Willmertinger wrote:
>      >      > I installed the new version. Normal connection test was
>     OK, but
>      >     not the
>      >      > special connection test in "Page 3".
>      >      >
>      >      > Using a postgresql database (8.4.22) with MS Access 2013
>     seemed
>      >     to work,
>      >      > but only read access. As soon as I try to change some
>     data, I get the
>      >      > message "Another user has changed ...".
>      >      > I uninstalled the new version and installed the last
>     release, now
>      >     it is
>      >      > working again.
>      >
>      >     When you ran the new version did you see if Row Versioning
>     was checked?
>      >
>      >      >
>      >      > Regards, Walter
>      >      > --
>      >      >
>      >      > Viele Grüße
>      >      >
>      >      > Walter Willmertinger
>      >      >
>      >
>      >
>      >     --
>      >     Adrian Klaver
>      > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>     <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
>      >
>      > --
>      >
>      > Viele Grüße
>      >
>      > Walter Willmertinger
>      >
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
> --
>
> Viele Grüße
>
> Walter Willmertinger
>


--
Adrian Klaver
adrian.klaver@aklaver.com