FWH 18.02 MinGW 7.2.0

vinhesoft · Post 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

┌────────────────────────────────────────────────────────────────────────────┐
?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>

Post 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"

vinhesoft · Post 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

┌────────────────────────────────────────────────────────────────────────────┐
?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>

Post 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

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

Mr.Rao

With lib libmysql32.lib worked !!

Thank you

Code: Select all

┌────────────────────────────────────────────────────────────────────────────┐
?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