FreeTDS Development Group

["Ron Creamer" <ron AT pageworks.com>]

Lowden, James K wrote:
> SQSH is written to Sybase's standard, not Microsoft's.  I'm a little
> surprised it even links to FreeTDS with msdblib enabled. 

I'm assuming from follow on posts that it should still work.

> > I applied a patch credited to Gentoo to the src/config.h file 
> > after my I ran configure:
>
>
> This is a sqsh patch, right?  I don't see how it could do any harm, although
> you could probably do without it.  

Actually, without this patch, it fails to compile. The patch forwarded 
to me by Garret Goebel a while back, credited to Gentoo is:
Gentoo has the following patch for src/config.h after you've run configure:

60c60
< /* #undef HAVE_STRERROR */
---

>> #define HAVE_STRERROR 1

62,67c62,67
< /* #undef HAVE_STRFTIME */
< /* #undef HAVE_MEMCPY */
< /* #undef HAVE_MEMMOVE */
< /* #undef HAVE_LOCALTIME */
< /* #undef HAVE_TIMELOCAL */
< /* #undef HAVE_STRCHR */
---

>> #define HAVE_STRFTIME 1
>> #define HAVE_MEMCPY 1
>> #define HAVE_MEMMOVE 1
>> #define HAVE_LOCALTIME 1
>> #define HAVE_TIMELOCAL 1
>> #define HAVE_STRCHR 1

69c69
< /* #undef HAVE_GETTIMEOFDAY */
---

>> #define HAVE_GETTIMEOFDAY 1

> Try:
>
> 1.  Configure without --enable-msdblib.
Exact same behavior (hangs)
> 2.  Double check that sqsh is linking to the right FreeTDS (with ldd).  
I believe it is. Here is the output of "ldd sqsh":
        libct.so.2 => /usr/lib/libct.so.2 (0x0030a000)
        libtds.so.3 => /usr/lib/libtds.so.3 (0x008de000)
        libdl.so.2 => /lib/libdl.so.2 (0x00bcb000)
        libm.so.6 => /lib/tls/libm.so.6 (0x00ba7000)
        libreadline.so.4 => /usr/lib/libreadline.so.4 (0x0481c000)
        libncurses.so.5 => /usr/lib/libncurses.so.5 (0x047da000)
        libc.so.6 => /lib/tls/libc.so.6 (0x00a6c000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x00a54000)
        libgpm.so.1 => /usr/lib/libgpm.so.1 (0x00a48000)

> 3.  Post a log, so we can see where it's giving up. 
Unfortunately, even with the log level at 99, no entries make it into 
the log. I feel it is a sqsh problem, it doesn't even seem to get to 
freetds.
> 4.  Run sqsh under gdb, and post a backtrace if it catches a signal. 
My apologies, I've never run gdb. I've tried it several times, and I'm 
not yet familiar enough with it. Do you have proper syntax to run gdb on 
a sqsh command line such as "sqsh -S sqlserver -U username -P password"?

> HTH.  Always happy to help a fellow sqsher.  

Thanks. I appreciate it. Again, tsql works flawlessly. I didn't want to 
go on with apache/php until I had sqsh working first per the freetds manual.

If it helps, sqsh exits with an error of 255, which is basically just a 
"general" error.

-Ron