I can not do SQSH 2.1.7 with freetds 0.91

Question

I am unable to create sqsh against freetds . This post cross-references to https://sourceforge.net/projects/sqsh/forums/forum/365924/topic/4716627 .

I installed Freetds 0.91 from sunfreeware.com on Solaris 10. I confirmed the installation as described in chapter 9 of the user guide.

Following the sqsh entries from sqsh.org, I set the SYBASE environment variable to / usr / local / freetds and ran the configure script. (I do not have Sybase installed on this machine. I do not need this.)

SYBASE=/usr/local/freetds; export SYBASE ./configure --with-readline 

I checked the Makefile, it seems correct that I read.

 SYBASE_LIBS = -lct -ltds -lnsl -ldl -lm 

When I run make, I get (after creating a bunch of things):

 make ... ...[build output]... ... gcc -L/usr/local/freetds/lib -L/usr/local/lib cmd_alias.o cmd_bcp.o cmd_buf.o cmd_connect.o cmd_do.o cmd_echo.o cmd_exit.o cmd_for.o cmd_func.o cmd_go.o cmd_help.o cmd_history.o cmd_if.o cmd_input.o cmd_jobs.o cmd_kill.o cmd_lock.o cmd_loop.o cmd_misc.o cmd_read.o cmd_reconnect.o cmd_redraw.o cmd_reset.o cmd_return.o cmd_rpc.o cmd_set.o cmd_shell.o cmd_show.o cmd_sleep.o cmd_wait.o cmd_warranty.o cmd_while.o var_ctlib.o var_date.o var_debug.o var_dsp.o var_hist.o var_misc.o var_passwd.o var_readline.o var_thresh.o dsp.o dsp_bcp.o dsp_csv.o dsp_conv.o dsp_desc.o dsp_horiz.o dsp_html.o dsp_meta.o dsp_none.o dsp_out.o dsp_pretty.o dsp_vert.o dsp_x.o sqsh_alias.o sqsh_args.o sqsh_avl.o sqsh_buf.o sqsh_cmd.o sqsh_compat.o sqsh_ctx.o sqsh_debug.o sqsh_env.o sqsh_error.o sqsh_expand.o sqsh_fd.o sqsh_filter.o sqsh_fork.o sqsh_func.o sqsh_getopt.o sqsh_global.o sqsh_history.o sqsh_init.o sqsh_job.o sqsh_readline.o sqsh_sig.o sqsh_sigcld.o sqsh_stdin.o sqsh_strchr.o sqsh_tok.o sqsh_varbuf.o sqsh_main.o -lct -ltds -lnsl -ldl -lm -lreadline -lcurses -o sqsh ld: warning: global symbol `_END_' has non-global binding: (file /usr/local/freetds/lib/libct.so value=LOCL); ld: warning: global symbol `_START_' has non-global binding: (file /usr/local/freetds/lib/libct.so value=LOCL); ld: fatal: file /usr/local/freetds/lib/libtds.a: unknown file type ld: fatal: File processing errors. No output written to sqsh collect2: ld returned 1 exit status make[1]: *** [sqsh] Error 1 make[1]: Leaving directory `/opt/BFMIfiles/src/sqsh-2.1.7/src' make: *** [build-subdirs] Error 2 

Is the error related to this: http://www.freetds.org/faq.html#where.is.libtds.so ?

Any ideas?

Link to the freetds mailing list . Link to sqsh help forum .

Answer 1

When editing src / Makefile, get rid of -ltds (as suggested here) and change -ldl to -liconv. I got the last bit from the cygwin sqsh README version.

I used SYBASE = / usr / local / freetds /.

After that I had to set LD_LIBRARY_PATH = $ SYBASE / lib /: / usr / local / lib / to get freetds and liconv libraries.

Many thanks to the freetds mailing list. http://lists.ibiblio.org/pipermail/freetds/2011q3/027382.html