mORMot Open Source

noobies

Member

Registered: 2011-09-13

Posts: 139

Postresql error with use zeos. SOLVED!

run sample 15 - External DB performance
1) install latest postgresql (PostgreSQL 9.6.1 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit)
2) uncomment
{$define USEZEOS}
{$define USEFIREDAC}
3) comment all except Postresql
4) install odbc and setup
5) put \zeoslib\lib\postgresql\libpq74.dll into  15 - External DB performance folder and rename to libpq.dll
6) run
odbc test success
firedac test success
zeos test failed

Project PerfTest.exe raised exception class EZSQLException with message 'SQL Error: ERROR:  prepared statement "518270435119021832" does not exist'.

press continue on error and next exception

Project PerfTest.exe raised exception class ESQLite3Exception with message 'Error SQLITE_ERROR (1) [Step] using 3.15.2 - SQL Error: ERROR:  prepared statement "518270435119021832" does not existrthDate,, extended_errcode=1'.

press continue on error and next exception

Project PerfTest.exe raised exception class ESQLite3Exception with message 'Error SQLITE_ERROR (1) [drop table Sample] using 3.15.2 - no such table: Sample, extended_errcode=1'.

where i wrong?

Last edited by noobies (2016-12-21 07:41:40)

miab3

Member

From: Poland

Registered: 2014-10-01

Posts: 188

Re: Postresql error with use zeos. SOLVED!

Too old PostgreSQL client(and ZEOS)?

Michal

noobies

Member

Registered: 2011-09-13

Posts: 139

Re: Postresql error with use zeos. SOLVED!

mormot - latest source
zeos - latest 7.2 from https://github.com/svn2github/ZeosLib/t … esting-7.2
zeos 7.3 same result
installed PostgreSQL-9.6.1-1-win64-bigsql.exe

but if i put into folder not renamed libpq74.dll i get error (lib from "c:\Program Files\PostgreSQL\pg96\bin\libpq.dll" )

Project PerfTest.exe raised exception class Exception with message 'Client-Library libpq.dll found but could not be loaded. Check compile-target and library compatibility!'.

i try donwload x32 (postgresql-9.6.1-1-windows-binaries.zip) and x64 (postgresql-9.6.1-1-windows-x64-binaries.zip) version dll always "Client-Library libpq.dll found but could not be loaded. Check compile-target and library compatibility!"

noobies

Member

Registered: 2011-09-13

Posts: 139

Re: Postresql error with use zeos. SOLVED!

SOLVED!
1) install psqlodbc_09_05_0400-x86
2) copy all files from "c:\Program Files (x86)\psqlODBC\0905\bin\" into 15 - External DB performance folder