Hi Gustaf,
I am now back working on this nsdbtds connection with naviserver. I got tsql to work but when I updated my config.tcl it give the error that it cannot load the nsdbtds.so because of an undefined symbol.
From error.log:
[20/Nov/2024:13:22:00][1.7fea3a39f800][-main:martyi_intra-] Notice: modload: loading module ns/db/driver/nsdbtds from file /usr/local/ns/bin/nsdbtds.so
[20/Nov/2024:13:22:00][1.7fea3a39f800][-main:martyi_intra-] Error: modload: /usr/local/ns/bin/nsdbtds.so: couldn't load file "/usr/local/ns/bin/nsdbtds.so": /usr/local/ns/bin/nsdbtds.so: undefined symbol: tds_free_connection
I compiled the nsdbtds by doing the following:
de <naviserver container>
cd /usr/local/src
git clone https://github.com/naviserver-project/nsdbtds.git
cd nsdbtds
make
# Got error that it cannot find the config.h file..
# Modified Makefile to be:
FREETDS_HOME = /usr/local/src/freetds-1.4.22
# Ran make again
make
# Got errors
# Removed the following line from nsdbtds.c
/* #include "freetds/string.h" */
# Ran make again
make
# It Compiled!! and generated the nsdbtds.so !!
make install <-- this puts it into /usr/local/ns/bin
# Run tsql with -H and -S and it worked! I could run SELECT commands
tsql -H <host> -U <username> -P <passwd>
tsql -S egServer73 -U <username> -P <passwd>
Any ideas why I would get an undefined symbol tds_free_connection? It does not seem like it could be from the '#include freetds/string.h' that I had to remove.
As always, thanks for your assistance,
Marty
