[Mingw-users] Building Windows DLL with mysql client libraries.

[Peter C. <pc...@ac...>]

I have been trying for several days to build a windows DLL file, the linker keeps complaining 
about undefined references for mysql stuff.

The reported errors actually relate to mysql commands defined as macros.

Any help would be appreciated.

I've come across this problem before but cannot find the old solution.


$ gcc -Wall -DWINDOWS -Ic:/tcl/include -Ic:/mysql/include fbsql.c -shared -o fbsql.dll -
Lc:/tcl/lib -ltcl83 -Lc:/mysql/lib/opt -llibmysql -lwsock32 -lz
c:\windows\TEMP\ccnx8Tfb.o(.text+0x3a):fbsql.c: undefined reference to `mysql_error@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x67):fbsql.c: undefined reference to `mysql_errno@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x1be):fbsql.c: undefined reference to 
`mysql_connect@16'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x2af):fbsql.c: undefined reference to `mysql_close@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x447):fbsql.c: undefined reference to 
`mysql_select_db@8'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x6f3):fbsql.c: undefined reference to `mysql_query@8'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x743):fbsql.c: undefined reference to 
`mysql_use_result@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x772):fbsql.c: undefined reference to 
`mysql_field_count@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x7cf):fbsql.c: undefined reference to 
`mysql_affected_rows@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x828):fbsql.c: undefined reference to 
`mysql_fetch_row@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x920):fbsql.c: undefined reference to 
`mysql_num_rows@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x953):fbsql.c: undefined reference to 
`mysql_free_result@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0xd8f):fbsql.c: undefined reference to `mysql_query@8'
c:\windows\TEMP\ccnx8Tfb.o(.text+0xde5):fbsql.c: undefined reference to 
`mysql_use_result@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0xe37):fbsql.c: undefined reference to 
`mysql_store_result@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0xe85):fbsql.c: undefined reference to 
`mysql_num_rows@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0xed3):fbsql.c: undefined reference to 
`mysql_field_count@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x10a9):fbsql.c: undefined reference to 
`mysql_fetch_row@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x11a1):fbsql.c: undefined reference to 
`mysql_fetch_field_direct@8'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x1381):fbsql.c: undefined reference to 
`mysql_fetch_field_direct@8'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x17ad):fbsql.c: undefined reference to 
`mysql_num_rows@4'
c:\windows\TEMP\ccnx8Tfb.o(.text+0x17fd):fbsql.c: undefined reference to 
`mysql_free_result@4'

Peter Campbell
http://www.fastbase.co.nz
Phone NZ 04 385 2230, Fax 04 385 2224.