FiveTech Software tech support forums

by **vinhesoft** » Mon Apr 16, 2018 7:02 pm

Mr.Rao,

error compiling with FWH 18.02 and MinGW 7.2.0

libraries: FiveHG.lib and FiveHGC.lib do not contain the class FWMariaDB

eg:

c:\devfw\fwh_1802\samples\buildg maria01

Code: Select all Expand view: ┌────────────────────────────────────────────────────────────────────────────┐ ?FiveWin for Harbour 18.02 and GCC - Feb. 2018 Harbour development power │▄ ?(c) FiveTech 1993-2018 for Microsoft Windows 9X/NT/200X/ME/XP/Vista/7/8/10 │█ └────────────────────────────────────────────────────────────────────────────┘? ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀? Compiling... Harbour 3.2.0dev (r1802131223) Copyright (c) 1999-2018, https://harbour.github.io/ Compiling 'maria01.prg' and generating preprocessed output to 'maria01.ppo'... Lines 4814, Functions/Procedures 2 Generating C source output to 'maria01.c'... Done. c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1b8b): undefined reference to `mysql_ping@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1e27): undefined reference to `mysql_init@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1e51): undefined reference to `mysql_options@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1e6f): undefined reference to `mysql_options@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1f58): undefined reference to `mysql_real_connect@32' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1f92): undefined reference to `mysql_set_character_set@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1fa2): undefined reference to `mysql_errno@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1fc0): undefined reference to `mysql_error@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x1fde): undefined reference to `mysql_close@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x21b4): undefined reference to `mysql_server_init@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x21cb): undefined reference to `mysql_init@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x21f6): undefined reference to `mysql_options@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x223b): undefined reference to `mysql_real_connect@32' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x224d): undefined reference to `mysql_close@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2255): undefined reference to `mysql_server_end@0' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x22af): undefined reference to `mysql_num_rows@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x22dd): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2355): undefined reference to `mysql_list_tables@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x236c): undefined reference to `mysql_errno@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2386): undefined reference to `mysql_ping@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x239f): undefined reference to `mysql_list_tables@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x23c4): undefined reference to `mysql_free_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2429): undefined reference to `mysql_list_dbs@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2440): undefined reference to `mysql_errno@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x245a): undefined reference to `mysql_ping@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2473): undefined reference to `mysql_list_dbs@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2498): undefined reference to `mysql_free_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2534): undefined reference to `mysql_real_query@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2554): undefined reference to `mysql_ping@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2579): undefined reference to `mysql_real_query@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2596): undefined reference to `mysql_store_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x25a9): undefined reference to `mysql_use_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x25c0): undefined reference to `mysql_field_count@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x25d2): undefined reference to `mysql_affected_rows@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2639): undefined reference to `mysql_list_fields@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x268b): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x26a8): undefined reference to `mysql_fetch_field@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x28b5): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x28c6): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2916): undefined reference to `mysql_fetch_lengths@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2b9e): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2bd6): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2c04): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x2c3e): undefined reference to `mysql_fetch_lengths@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3160): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3207): undefined reference to `mysql_real_query@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x321d): undefined reference to `mysql_use_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3238): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x324f): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3266): undefined reference to `mysql_fetch_lengths@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x32b4): undefined reference to `mysql_free_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x349a): undefined reference to `mysql_real_query@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x34b0): undefined reference to `mysql_use_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x34cb): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x34dc): undefined reference to `mysql_fetch_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x34f9): undefined reference to `mysql_fetch_lengths@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x37a9): undefined reference to `mysql_hex_string@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x388b): undefined reference to `mysql_real_escape_string@16' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x39ae): undefined reference to `mysql_hex_string@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3a6f): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3aa9): undefined reference to `mysql_free_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3b4b): undefined reference to `mysql_real_query@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3b61): undefined reference to `mysql_use_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3b7c): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3b8d): undefined reference to `mysql_fetch_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3ba3): undefined reference to `mysql_fetch_lengths@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3dcc): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x3de7): undefined reference to `mysql_free_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x40af): undefined reference to `mysql_real_escape_string@16' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x413d): undefined reference to `mysql_escape_string@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x42ff): undefined reference to `mysql_store_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4370): undefined reference to `mysql_data_seek@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x437e): undefined reference to `mysql_num_fields@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x438f): undefined reference to `mysql_fetch_row@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x43a0): undefined reference to `mysql_fetch_lengths@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4500): undefined reference to `mysql_stmt_bind_param@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x450e): undefined reference to `mysql_stmt_execute@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4554): undefined reference to `mysql_set_server_option@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4593): undefined reference to `mysql_autocommit@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x45c6): undefined reference to `mysql_insert_id@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x45df): undefined reference to `mysql_get_client_info@0' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4604): undefined reference to `mysql_character_set_name@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x462c): undefined reference to `mysql_get_server_info@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4654): undefined reference to `mysql_ping@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4684): undefined reference to `mysql_commit@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x46af): undefined reference to `mysql_rollback@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x46ed): undefined reference to `mysql_select_db@8' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4720): undefined reference to `mysql_errno@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4748): undefined reference to `mysql_error@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4770): undefined reference to `mysql_info@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4798): undefined reference to `mysql_next_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x47c0): undefined reference to `mysql_free_result@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x47e0): undefined reference to `mysql_close@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x47f1): undefined reference to `mysql_server_end@0' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4813): undefined reference to `mysql_num_rows@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x484a): undefined reference to `mysql_stmt_init@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x4898): undefined reference to `mysql_stmt_prepare@12' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x48c5): undefined reference to `mysql_stmt_execute@4' c:\devfw\fwh_1802\lib/fivehg.lib(FWMARIA.o):FWMARIA.c:(.text+0x48ed): undefined reference to `mysql_stmt_close@4' collect2.exe: error: ld returned 1 exit status * Link errors * C:\DevFW\fwh_1802\samples>

by **nageswaragunupudi** » Wed Apr 18, 2018 12:34 am

The build includes FWMaria libs.
But you need to link with import lib "libmysql.lib" built from "libmysql.dll"

by **vinhesoft** » Wed Apr 18, 2018 11:04 am

Mr.Rao

use the lib libySQL.Lib that is in the lib folder of version FWH 18.02

Look:

Code: Select all Expand view: ┌────────────────────────────────────────────────────────────────────────────┐ ?FiveWin for Harbour 18.02 and GCC - Feb. 2018 Harbour development power │▄ ?(c) FiveTech 1993-2018 for Microsoft Windows 9X/NT/200X/ME/XP/Vista/7/8/10 │█ └────────────────────────────────────────────────────────────────────────────┘? ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀? Compiling... Harbour 3.2.0dev (r1802131223) Copyright (c) 1999-2018, https://harbour.github.io/ Compiling 'maria01.prg' and generating preprocessed output to 'maria01.ppo'... Lines 4814, Functions/Procedures 2 Generating C source output to 'maria01.c'... Done. c:\devfw\fwh_1802\lib/libmysql.lib: file not recognized: File format not recogni zed collect2.exe: error: ld returned 1 exit status * Link errors * C:\DevFW\fwh_1802\samples>

by **nageswaragunupudi** » Wed Apr 18, 2018 11:09 am

libmysql.lib is for borland complier.
libmysql32.lib is for Microsoft compiler.

You may try linking with libmysql32.lib.
If that does not work, you may need to create an implib yourself with gcc from the libmysql.dll

by **vinhesoft** » Wed Apr 18, 2018 11:28 am

Mr.Rao

With lib libmysql32.lib worked !!

Thank you

Code: Select all Expand view: ┌────────────────────────────────────────────────────────────────────────────┐ ?FiveWin for Harbour 18.02 and GCC - Feb. 2018 Harbour development power │▄ ?(c) FiveTech 1993-2018 for Microsoft Windows 9X/NT/200X/ME/XP/Vista/7/8/10 │█ └────────────────────────────────────────────────────────────────────────────┘? ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀? Compiling... Harbour 3.2.0dev (r1802131223) Copyright (c) 1999-2018, https://harbour.github.io/ Compiling 'maria01.prg' and generating preprocessed output to 'maria01.ppo'... Lines 4814, Functions/Procedures 2 Generating C source output to 'maria01.c'... Done. * Application successfully built C:\DevFW\fwh_1802\samples>

FiveTech Software tech support forums

FWH 18.02 MinGW 7.2.0

FWH 18.02 MinGW 7.2.0

Re: FWH 18.02 MinGW 7.2.0

Re: FWH 18.02 MinGW 7.2.0

Re: FWH 18.02 MinGW 7.2.0

Re: FWH 18.02 MinGW 7.2.0

Who is online