FreeTDS Development Group

[Casey Boardman <cboardman AT batterymarch.com>]

No dice so far.  Here are the end results of make with SYBASE set to the two 
different values.  This does affect the SYBASE_LIBS in the Makefile.

Should I reinstall the package to the /usr/local/ vs /usr/local/freetds/?  Is 
this a sqsh error at this point?


With 
- environment: SYBASE=/usr/local/freetds 
- Makefile (edited by me): SYBASE_LIBS   =    -lct    -lnsl -ldl -lm

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    -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);
Undefined                       first referenced
 symbol                             in file
libiconv_close                      /usr/local/freetds/lib/libct.so
libiconv_open                       /usr/local/freetds/lib/libct.so
libiconv                            /usr/local/freetds/lib/libct.so
ld: fatal: Symbol referencing 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


With 
- environment: SYBASE=/usr/local/ 
- Makefile: SYBASE_LIBS   =       -lintl -lnsl -ldl -lm

gcc -g -O2  -DSQSH_RC='"/usr/local/etc/sqshrc:${HOME}/.sqshrc"' 
-DUSE_READLINE           -I/usr/local//include -I/usr/local/include   -c -o 
cmd_alias.o cmd_alias.c
In file included from cmd_alias.c:28:
sqsh_global.h:27:22: ctpublic.h: No such file or directory
In file included from sqsh_global.h:35,
                 from cmd_alias.c:28:
dsp.h:52: error: syntax error before "CS_INT"
dsp.h:52: warning: no semicolon at end of struct or union
dsp.h:53: warning: data definition has no type or storage class
dsp.h:54: error: syntax error before "c_nullind"
dsp.h:54: warning: data definition has no type or storage class
dsp.h:55: error: syntax error before "c_is_native"
dsp.h:55: warning: data definition has no type or storage class
dsp.h:56: error: syntax error before '*' token
dsp.h:56: warning: data definition has no type or storage class
dsp.h:57: error: syntax error before "c_native_len"
dsp.h:57: warning: data definition has no type or storage class
dsp.h:58: error: syntax error before '*' token
dsp.h:58: warning: data definition has no type or storage class
dsp.h:59: error: syntax error before "c_maxlength"
dsp.h:59: warning: data definition has no type or storage class
dsp.h:60: error: syntax error before "c_justification"
dsp.h:60: warning: data definition has no type or storage class
dsp.h:62: error: syntax error before "c_column_id"
dsp.h:62: warning: data definition has no type or storage class
dsp.h:63: error: syntax error before "c_aggregate_op"
dsp.h:63: warning: data definition has no type or storage class
dsp.h:71: error: syntax error before "c_processed"
dsp.h:71: warning: data definition has no type or storage class
dsp.h:78: error: syntax error before '*' token
dsp.h:78: warning: data definition has no type or storage class
dsp.h:84: error: syntax error before "c_width"
dsp.h:84: warning: data definition has no type or storage class
dsp.h:86: warning: data definition has no type or storage class
dsp.h:94: error: syntax error before "CS_INT"
dsp.h:94: warning: no semicolon at end of struct or union
dsp.h:95: warning: data definition has no type or storage class
dsp.h:96: error: syntax error before '*' token
dsp.h:96: warning: data definition has no type or storage class
dsp.h:98: error: syntax error before "d_bylist_size"
dsp.h:98: warning: data definition has no type or storage class
dsp.h:99: error: syntax error before '*' token
dsp.h:99: warning: data definition has no type or storage class
dsp.h:100: error: syntax error before '}' token
dsp.h:100: warning: data definition has no type or storage class
dsp.h:164: error: syntax error before "CS_COMMAND"
dsp.h:188: error: syntax error before "CS_COMMAND"
dsp.h:237: error: syntax error before "CS_COMMAND"
dsp.h:238: error: syntax error before "CS_COMMAND"
dsp.h:239: error: syntax error before "CS_COMMAND"
dsp.h:240: error: syntax error before "CS_COMMAND"
dsp.h:241: error: syntax error before "CS_COMMAND"
dsp.h:242: error: syntax error before "CS_COMMAND"
dsp.h:243: error: syntax error before "CS_COMMAND"
dsp.h:244: error: syntax error before "CS_COMMAND"
dsp.h:245: error: syntax error before "CS_COMMAND"
dsp.h:248: error: syntax error before '*' token
dsp.h:248: error: syntax error before '*' token
dsp.h:248: warning: data definition has no type or storage class
dsp.h:249: error: syntax error before "dsp_desc_fetch"
dsp.h:249: error: syntax error before '*' token
dsp.h:249: warning: data definition has no type or storage class
dsp.h:250: error: syntax error before '*' token
dsp.h:251: error: syntax error before "dsp_datetime_len"
dsp.h:251: error: syntax error before '*' token
dsp.h:251: warning: data definition has no type or storage class
dsp.h:252: error: syntax error before "dsp_datetime4_len"
dsp.h:252: error: syntax error before '*' token
dsp.h:252: warning: data definition has no type or storage class
dsp.h:253: error: syntax error before "dsp_money_len"
dsp.h:253: error: syntax error before '*' token
dsp.h:253: warning: data definition has no type or storage class
dsp.h:254: error: syntax error before "dsp_money4_len"
dsp.h:254: error: syntax error before '*' token
dsp.h:254: warning: data definition has no type or storage class
dsp.h:255: error: syntax error before "dsp_datetime_conv"
dsp.h:255: error: syntax error before '*' token
dsp.h:255: warning: data definition has no type or storage class
In file included from cmd_alias.c:28:
sqsh_global.h:42: error: syntax error before "g_cs_ver"
sqsh_global.h:42: warning: data definition has no type or storage class
sqsh_global.h:50: error: syntax error before '*' token
sqsh_global.h:50: warning: data definition has no type or storage class
sqsh_global.h:51: error: syntax error before '*' token
sqsh_global.h:51: warning: data definition has no type or storage class
sqsh_global.h:72: error: syntax error before '*' token
sqsh_global.h:72: warning: data definition has no type or storage class
sqsh_global.h:72: warning: array 'g_do_cols' assumed to have one element
make[1]: *** [cmd_alias.o] Error 1
make[1]: Leaving directory `/opt/BFMIfiles/src/sqsh-2.1.7/src'
make: *** [build-subdirs] Error 2


Thanks again for the help.


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of 
jklowden AT schemamania.org
Sent: Wednesday, September 21, 2011 11:59
To: FreeTDS Development Group
Subject: Re: [freetds] Can't make SQSH 2.1.7 with freetds 0.91

On Wed, Sep 21, 2011 at 10:56:50AM -0400, Casey Boardman wrote:
> But there is not libtds.so (per  
> http://www.freetds.org/faq.html#where.is.libtds.so).
> 
> Or do I have to get/build it separately? 

You don't need libtds.so; it doesn't exist.  The functions that used to be in
libtds are now included in the client libraries.  For sqsh, libct  is all you
need.  

$ ls -1 lib/libct.*
lib/libct.a
lib/libct.la
lib/libct.so
lib/libct.so.4
lib/libct.so.4.0.0

It should be enough just to remove "-ltds" from your linker command.  

--jkl

> From: [jklowden AT freetds.org]
> Sent: Tuesday, September 20, 2011 10:33 PM
...
> Just a slight tweak to the Makefile: there is no libtds.a and no need
> for it.  Everything you need should be in libct.so.
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

This message is intended for the addressee only and may contain privileged or 
confidential information. Unless you are the intended recipient, you may not 
use, copy or disclose to anyone any information contained in this message. If 
you have received this message in error, please notify the author by replying 
to this message and then kindly delete the message. Thank you.