build Error c:\hmg.3.4.4\SAMPLES\HFCL\SQL\POSTGRESQL_1

Moderator: Rathinagiri

Post Reply
User avatar
hmgchang
Posts: 239
Joined: Tue Aug 13, 2013 4:46 am
Location: Indonesia
Has thanked: 1 time
Been thanked: 4 times

build Error c:\hmg.3.4.4\SAMPLES\HFCL\SQL\POSTGRESQL_1

Post by hmgchang » Mon Jun 04, 2018 11:41 pm

Dear Friends,

Build error on : c:\hmg.3.4.4\SAMPLES\HFCL\SQL\POSTGRESQL_1

the build.log :

Code: Select all

hbmk2: Compiling Harbour sources...
Harbour 3.2.0dev (r1703241902)
Copyright (c) 1999-2016, http://harbour-project.org/

demo.prg(57) Warning W0001  Ambiguous reference 'ACTRL_1'

demo.prg(57) Warning W0001  Ambiguous reference 'ACTRL_2'

demo.prg(65) Warning W0005  RETURN statement with no return value in function
hbmk2: Compiling...
hbmk2: Linking... demo.exe
.hbmk/win/mingw/demo.o:demo.c:(.data+0x38): undefined reference to `HB_FUN_DBPGCONNECTION'
.hbmk/win/mingw/demo.o:demo.c:(.data+0x248): undefined reference to `HB_FUN_PGRDD'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x16): undefined reference to `PQfinish'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x46): undefined reference to `PQclear'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x76): undefined reference to `PQfreeCancel'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x19d): undefined reference to `PQconnectdb'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2bb): undefined reference to `PQsetdbLogin'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x336): undefined reference to `PQreset'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x3a6): undefined reference to `PQprotocolVersion'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x426): undefined reference to `PQclientEncoding'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x4b7): undefined reference to `PQsetClientEncoding'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x536): undefined reference to `PQdb'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x5b6): undefined reference to `PQuser'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x636): undefined reference to `PQpass'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x6b6): undefined reference to `PQhost'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x736): undefined reference to `PQport'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x7b6): undefined reference to `PQtty'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x836): undefined reference to `PQoptions'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x8b6): undefined reference to `PQtransactionStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x936): undefined reference to `PQerrorMessage'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x9b6): undefined reference to `PQstatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xa47): undefined reference to `PQexec'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xba0): undefined reference to `PQexecParams'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xc67): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xc84): undefined reference to `PQnfields'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xcf7): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xd14): undefined reference to `PQntuples'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xd96): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xddd): undefined reference to `PQgetisnull'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xdf1): undefined reference to `PQgetvalue'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xe7e): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xec8): undefined reference to `PQgetlength'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xf45): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xf6b): undefined reference to `PQnfields'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xf98): undefined reference to `PQfmod'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0xfa6): undefined reference to `PQftype'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x11b2): undefined reference to `PQfname'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x121a): undefined reference to `PQftable'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x123b): undefined reference to `PQftablecol'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x14e2): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1505): undefined reference to `PQntuples'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1513): undefined reference to `PQnfields'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x157d): undefined reference to `PQgetvalue'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1616): undefined reference to `PQresultErrorMessage'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1696): undefined reference to `PQresultStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1716): undefined reference to `PQcmdStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1796): undefined reference to `PQcmdTuples'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1831): undefined reference to `PQescapeString'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x189f): undefined reference to `PQescapeBytea'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x18b9): undefined reference to `PQfreemem'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1935): undefined reference to `PQunescapeBytea'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x194f): undefined reference to `PQfreemem'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x19c6): undefined reference to `PQoidValue'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1a46): undefined reference to `PQoidStatus'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1ac6): undefined reference to `PQbinaryTuples'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1b58): undefined reference to `PQftable'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1be8): undefined reference to `PQftype'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1c78): undefined reference to `PQfname'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1d08): undefined reference to `PQfmod'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1d98): undefined reference to `PQfsize'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1e3c): undefined reference to `PQgetisnull'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1ec7): undefined reference to `PQfnumber'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1f46): undefined reference to `PQntuples'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x1fc6): undefined reference to `PQnfields'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2057): undefined reference to `PQsendQuery'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x20d7): undefined reference to `PQgetResult'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2186): undefined reference to `PQconsumeInput'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2206): undefined reference to `PQisBusy'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2286): undefined reference to `PQrequestCancel'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2306): undefined reference to `PQflush'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2397): undefined reference to `PQsetnonblocking'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2416): undefined reference to `PQisnonblocking'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x24c6): undefined reference to `PQuntrace'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2547): undefined reference to `PQsetErrorVerbosity'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x25d7): undefined reference to `lo_import'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x267a): undefined reference to `lo_export'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2707): undefined reference to `lo_unlink'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2786): undefined reference to `PQserverVersion'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2807): undefined reference to `PQgetCancel'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x28d0): undefined reference to `PQcancel'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x29b7): undefined reference to `PQescapeByteaConn'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x29d1): undefined reference to `PQfreemem'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2a8c): undefined reference to `PQprepare'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2bda): undefined reference to `PQexecPrepared'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2caa): undefined reference to `PQputCopyData'
C:/hmg.3.4.4/harbour/lib/win/mingw\libhbpgsql.a(postgres.o):postgres.c:(.text+0x2d2c): undefined reference to `PQputCopyEnd'
collect2.exe: error: ld returned 1 exit status
hbmk2[demo]: Error: Running linker. 1
gcc.exe .hbmk/win/mingw/demo.o .hbmk/win/mingw/_hbmkaut_demo.o c:/hmg.3.4.4/SAMPLES/HFCL/SQL/POSTGRESQL_1/_temp.o    -pthread  -static-libgcc  -static-libstdc++  -static -lpthread -mwindows -Wl,--start-group -lhmg -lcrypt -ledit -leditex -lgraph -lini -lreport -lhfcl -lmsvfw32 -lvfw32 -lhbmysql -lmysql -lhbfimage -lhbpgsql -lsddmy -lhbvpdf -lhbct -lhbwin -lhbmzip -lminizip -lhbmemio -lhbmisc -lhbtip -lsqlite3 -lhbsqlit3 -lsddodbc -lrddsql -lhbodbc -lodbc32 -lhbhpdf -lhbnetio -lxhb -lpng -llibhpdf -lhbzebra -lhbextern -lhbdebug -lhbvmmt -lhbrtl -lhblang -lhbcpage -lgtcgi -lgtpca -lgtstd -lgtwin -lgtwvt -lgtgui -lhbrdd -lhbuddall -lhbusrrdd -lrddntx -lrddcdx -lrddnsx -lrddfpt -lhbrdd -lhbhsx -lhbsix -lhbmacro -lhbcplr -lhbpp -lhbcommon -lhbmainwin -lkernel32 -luser32 -lgdi32 -ladvapi32 -lws2_32 -liphlpapi -lwinspool -lcomctl32 -lcomdlg32 -lshell32 -luuid -lole32 -loleaut32 -lmpr -lwinmm -lmapi32 -limm32 -lmsimg32 -lwininet -lhbpcre -lhbzlib   -Wl,--end-group -odemo.exe  -LC:/hmg.3.4.4/harbour/lib/win/mingw -LC:/hmg.3.4.4/lib

hbmk2: Error: Referenced, missing, but unknown function(s): DBPGCONNECTION(),
       PGRDD()
Pls advise what to do...

TIA

best rgds,
Chang
Just Hmg It !

User avatar
dragancesu
Posts: 569
Joined: Mon Jun 24, 2013 11:53 am
DBs Used: DBF, MySQL, Oracle
Location: Subotica, Serbia
Has thanked: 14 times
Been thanked: 101 times

Post by dragancesu » Tue Jun 05, 2018 6:45 am

You need dll that come with the installation of a PostgreSQL database

It works with harbour, does not work with hmg, the same case with the Oracle database

Try MySQL, it works great

User avatar
hmgchang
Posts: 239
Joined: Tue Aug 13, 2013 4:46 am
Location: Indonesia
Has thanked: 1 time
Been thanked: 4 times

Post by hmgchang » Tue Jun 05, 2018 11:47 am

Thanks Dragancesu...
Any suggestions how to start using harbour ?
Just Hmg It !

Post Reply