TinyTDS 2.1.3 installation errors

gem_make.out

current directory: C:/devl/ruby/ruby-2.6.6-64/lib/ruby/gems/2.6.0/gems/tiny_tds-2.1.3/ext/tiny_tds
C:/devl/ruby/ruby-2.6.6-64/bin/ruby.exe -I C:/devl/ruby/ruby-2.6.6-64/lib/ruby/site_ruby/2.6.0 -r ./siteconf20200929-91088-1jx3uom.rb extconf.rb
looking for freetds headers in the following directories:
 - /opt/local/include
 - /opt/local/include/freetds
 - /usr/local/include
 - /usr/local/include/freetds
looking for freetds library in the following directories:
 - /opt/local/lib
 - /opt/local/lib/freetds
 - /usr/local/lib
 - /usr/local/lib/freetds
checking for sybfront.h... no
checking for sybdb.h... no
checking for tdsdbopen() in -lsybdb... no
checking for dbanydatecrack() in -lsybdb... no
Failed! Do you have FreeTDS 0.95.80 or higher installed?
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers.  Check the mkmf.log file for more details.  You may
need configuration options.

Provided configuration options:
	--with-opt-dir
	--without-opt-dir
	--with-opt-include
	--without-opt-include=${opt-dir}/include
	--with-opt-lib
	--without-opt-lib=${opt-dir}/lib
	--with-make-prog
	--without-make-prog
	--srcdir=.
	--curdir
	--ruby=C:/devl/ruby/ruby-2.6.6-64/bin/$(RUBY_BASE_NAME)
	--help
	--with-freetds-dir
	--without-freetds-dir
	--with-freetds-include
	--without-freetds-include=${freetds-dir}/include
	--with-freetds-lib
	--without-freetds-lib=${freetds-dir}/lib
	--with-sybdblib
	--without-sybdblib
	--with-sybdblib
	--without-sybdblib

To see why this extension failed to compile, please check the mkmf.log which can be found here:

  C:/devl/ruby/ruby-2.6.6-64/lib/ruby/gems/2.6.0/extensions/x64-mingw32/2.6.0/tiny_tds-2.1.3/mkmf.log

extconf failed, exit code 1

mkmf.log

find_header: checking for sybfront.h... -------------------- no

"x86_64-w64-mingw32-gcc -o conftest.exe -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong conftest.c  -L. -LC:/devl/ruby/ruby-2.6.6-64/lib -L/opt/local/lib -L/opt/local/lib/freetds -L/usr/local/lib -L/usr/local/lib/freetds -L. -pipe -s -fstack-protector-strong     -lx64-msvcrt-ruby260  -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi  "
checked program was:
/* begin */
1: #include "ruby.h"
2: 
3: #include <winsock2.h>
4: #include <windows.h>
5: int main(int argc, char **argv)
6: {
7:   return 0;
8: }
/* end */

"x86_64-w64-mingw32-gcc -E -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong  conftest.c -o conftest.i"
conftest.c:5:10: fatal error: sybfront.h: No such file or directory
    5 | #include <sybfront.h>
      |          ^~~~~~~~~~~~
compilation terminated.
checked program was:
/* begin */
1: #include "ruby.h"
2: 
3: #include <winsock2.h>
4: #include <windows.h>
5: #include <sybfront.h>
/* end */

--------------------

find_header: checking for sybdb.h... -------------------- no

"x86_64-w64-mingw32-gcc -E -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong  conftest.c -o conftest.i"
conftest.c:5:10: fatal error: sybdb.h: No such file or directory
    5 | #include <sybdb.h>
      |          ^~~~~~~~~
compilation terminated.
checked program was:
/* begin */
1: #include "ruby.h"
2: 
3: #include <winsock2.h>
4: #include <windows.h>
5: #include <sybdb.h>
/* end */

--------------------

find_library: checking for tdsdbopen() in -lsybdb... -------------------- no

"x86_64-w64-mingw32-gcc -o conftest.exe -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong conftest.c  -L. -LC:/devl/ruby/ruby-2.6.6-64/lib -L/opt/local/lib -L/opt/local/lib/freetds -L/usr/local/lib -L/usr/local/lib/freetds -L. -pipe -s -fstack-protector-strong     -lx64-msvcrt-ruby260 -lsybdb  -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi  "
conftest.c: In function 't':
conftest.c:17:57: error: 'tdsdbopen' undeclared (first use in this function)
   17 | int t(void) { void ((*volatile p)()); p = (void ((*)()))tdsdbopen; return !p; }
      |                                                         ^~~~~~~~~
conftest.c:17:57: note: each undeclared identifier is reported only once for each function it appears in
checked program was:
/* begin */
 1: #include "ruby.h"
 2: 
 3: #include <winsock2.h>
 4: #include <windows.h>
 5: 
 6: /*top*/
 7: extern int t(void);
 8: int main(int argc, char **argv)
 9: {
10:   if (argc > 1000000) {
11:     int (* volatile tp)(void)=(int (*)(void))&t;
12:     printf("%d", (*tp)());
13:   }
14: 
15:   return 0;
16: }
17: int t(void) { void ((*volatile p)()); p = (void ((*)()))tdsdbopen; return !p; }
/* end */

"x86_64-w64-mingw32-gcc -o conftest.exe -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong conftest.c  -L. -LC:/devl/ruby/ruby-2.6.6-64/lib -L/opt/local/lib -L/opt/local/lib/freetds -L/usr/local/lib -L/usr/local/lib/freetds -L. -pipe -s -fstack-protector-strong     -lx64-msvcrt-ruby260 -lsybdb  -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi  "
C:/devl/ruby/ruby-2.6.6-64/msys64/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/9.3.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -lsybdb
collect2.exe: error: ld returned 1 exit status
checked program was:
/* begin */
 1: #include "ruby.h"
 2: 
 3: #include <winsock2.h>
 4: #include <windows.h>
 5: 
 6: /*top*/
 7: extern int t(void);
 8: int main(int argc, char **argv)
 9: {
10:   if (argc > 1000000) {
11:     int (* volatile tp)(void)=(int (*)(void))&t;
12:     printf("%d", (*tp)());
13:   }
14: 
15:   return 0;
16: }
17: extern void tdsdbopen();
18: int t(void) { tdsdbopen(); return 0; }
/* end */

--------------------

find_library: checking for dbanydatecrack() in -lsybdb... -------------------- no

"x86_64-w64-mingw32-gcc -o conftest.exe -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong conftest.c  -L. -LC:/devl/ruby/ruby-2.6.6-64/lib -L/opt/local/lib -L/opt/local/lib/freetds -L/usr/local/lib -L/usr/local/lib/freetds -L. -pipe -s -fstack-protector-strong     -lx64-msvcrt-ruby260 -lsybdb  -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi  "
conftest.c: In function 't':
conftest.c:17:57: error: 'dbanydatecrack' undeclared (first use in this function)
   17 | int t(void) { void ((*volatile p)()); p = (void ((*)()))dbanydatecrack; return !p; }
      |                                                         ^~~~~~~~~~~~~~
conftest.c:17:57: note: each undeclared identifier is reported only once for each function it appears in
checked program was:
/* begin */
 1: #include "ruby.h"
 2: 
 3: #include <winsock2.h>
 4: #include <windows.h>
 5: 
 6: /*top*/
 7: extern int t(void);
 8: int main(int argc, char **argv)
 9: {
10:   if (argc > 1000000) {
11:     int (* volatile tp)(void)=(int (*)(void))&t;
12:     printf("%d", (*tp)());
13:   }
14: 
15:   return 0;
16: }
17: int t(void) { void ((*volatile p)()); p = (void ((*)()))dbanydatecrack; return !p; }
/* end */

"x86_64-w64-mingw32-gcc -o conftest.exe -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/x64-mingw32 -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0/ruby/backward -IC:/devl/ruby/ruby-2.6.6-64/include/ruby-2.6.0 -I. -I/opt/local/include -I/opt/local/include/freetds -I/usr/local/include -I/usr/local/include/freetds -D__USE_MINGW_ANSI_STDIO=1 -DFD_SETSIZE=2048 -D_WIN32_WINNT=0x0600 -D__MINGW_USE_VC2005_COMPAT -D_FILE_OFFSET_BITS=64  -O3 -fno-fast-math -fstack-protector-strong conftest.c  -L. -LC:/devl/ruby/ruby-2.6.6-64/lib -L/opt/local/lib -L/opt/local/lib/freetds -L/usr/local/lib -L/usr/local/lib/freetds -L. -pipe -s -fstack-protector-strong     -lx64-msvcrt-ruby260 -lsybdb  -lshell32 -lws2_32 -liphlpapi -limagehlp -lshlwapi  "
C:/devl/ruby/ruby-2.6.6-64/msys64/mingw64/bin/../lib/gcc/x86_64-w64-mingw32/9.3.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -lsybdb
collect2.exe: error: ld returned 1 exit status
checked program was:
/* begin */
 1: #include "ruby.h"
 2: 
 3: #include <winsock2.h>
 4: #include <windows.h>
 5: 
 6: /*top*/
 7: extern int t(void);
 8: int main(int argc, char **argv)
 9: {
10:   if (argc > 1000000) {
11:     int (* volatile tp)(void)=(int (*)(void))&t;
12:     printf("%d", (*tp)());
13:   }
14: 
15:   return 0;
16: }
17: extern void dbanydatecrack();
18: int t(void) { dbanydatecrack(); return 0; }
/* end */

--------------------