Skip to Content.
Sympa Menu

freetds - Re: How to compile SQSH with FreeTDS .60?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Jay Sauls" <jaysauls AT hotmail.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: How to compile SQSH with FreeTDS .60?
  • Date: Thu, 3 Oct 2002 15:29:59 -0700


Thanks for the assist Brian. I was able to successfully compile sqsh.

Next problem, which is probably off topic for this list, but I don't
know who else to ask: now that I've got sqsh successfully compiled, I
can't figure out how to get it to do integrated auth. I've tried using
the -X option to no avail.

Stepping through the sqsh code, it only seems capable of setting TDS
version to be <= 5. The FreeTDS code indicates that it will only try
integrated auth on TDS version >= 7.

I'm not sure, but sqsh seems to be leaving the tds version field = null
when building a connection context. Is this correct?

Before I do too much more hacking around, I was wondering if anyone knew
for sure if sqsh 2.0 will work with integrated auth or not.

Thanks....

-----Original Message-----
From: bounce-freetds-149810 AT franklin.oit.unc.edu
[mailto:bounce-freetds-149810 AT franklin.oit.unc.edu] On Behalf Of Brian
Bruns
Sent: Wednesday, October 02, 2002 6:46 PM
To: TDS Development Group
Subject: [freetds] Re: How to compile SQSH with FreeTDS .60?


Later versions of SQSH should do the right thing mostly automatically.
Set $SYBASE to the location of the install (/usr/local for 0.60,
/usr/local/freetds for any previous version). If you do have to edit
the
SYBASE_LIBS in the makefile it should be set to "-lct"

Brian

On Wed, 2 Oct 2002, Jay Sauls wrote:

> I have FreeTDS 0.60 installed and running nicely. tsql sucessfully
> connects to my native-mode SQLServer with integrated auth. Very nice!
>
> I'd like to use sqsh to do some advanced queries (espeically running
> stored procedures). However, the latest compiled SQSH I can find for
> FreeTDS on x86 Linux (located at www.sqsh.org/sqsh_download.html) uses
> FreeTDS 0.52, which I assume doesn't have integrated auth support.
>
> So I need to compile sqsh to use FreeTDS 0.60.
>
> While perusing this handy url:
> http://www.freetds.org/userguide/c1457.htm#AEN1461
>
> I noticed a note in the instructions:
>
> "After running configure in SQSH's directory (make sure you set the
Sybase
> environment variable first), look for the Sybase_LIBS definition in
the
> Makefile. Change the line to match this example. "
>
> What exactly should I set the SYBASE environment variable to? I don't
> have OpenClient installed (and I don't own a sybase license, so I
don't
> know where or if I can obtain OpenClient). Is OpenClient required to
> compile sqsh?
>
> Thanks for any help....
>
> ---
> You are currently subscribed to freetds as: [camber AT ais.org]
> To unsubscribe, forward this message to
$subst('Email.Unsub')
>


---
You are currently subscribed to freetds as: [jaysauls AT hotmail.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page