Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ikorot AT earthlink.net
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
  • Date: Thu, 2 Dec 2010 10:41:53 -0800 (GMT-08:00)

Hi, guys,
Maybe we can code something in Perl?
It will be independent of the shell and run on every Linux.

Thank you.


-----Original Message-----
>From: "Peter C. Norton" <spacey-freetds.org AT ssr.com>
>Sent: Dec 2, 2010 9:02 AM
>To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
>Subject: Re: [freetds] FreeTDS on Debian: connect to MSSQL with ODBC fails
>
>On Thu, Dec 02, 2010 at 11:30:20AM -0500, jklowden AT schemamania.org wrote:
>> On Thu, Dec 02, 2010 at 10:26:24AM -0500, Peter C. Norton wrote:
>> > On Thu, Dec 02, 2010 at 09:55:32AM -0500, jklowden AT schemamania.org wrote:
>> > > It's trickier than it might look to do correctly. For example, isql
>> > > will
>> > > not report where it looks for its odbc.ini. So the osql script tries
>> > > to
>> > > infer that by searching the binary and parsing ldd(1) output. And
>> > > then
>> > > there are the usual portability issues, such as the versions of sed(1)
>> > > and awk(1), and the options they accept. But after 11 tries we seem
>> > > to
>> > > be making some progress!
>> >
>> > Quick note about the script: if you're on a platform with
>> > ksh/bash/zsh, can you have autoconf/configure replace #!/bin/sh with
>> > the more capable shell? On unix variants that have a true bourne
>> > shell, a lot of things don't work as expected with /bin/sh.
>>
>> Ah, well, Peter, we're missing one critical resource: a more capable
>> scripter.
>>
>> Yours truly can stumble through a Bourne shell script but I've never dealt
>> with ksh or zsh. I use bash interactively and try to color inside the
>> lines such that bash invoked as /bin/sh behaves identically to any Bourne
>> shell. So far that's worked OK: the problems we've had with osql were
>> never shell problems per se, but BSD/Linux utility conflicts or unexpected
>> unixODBC arrangements.
>>
>
>Ah, the joys of shell scripting. Solaris has traditionally insisted
>on keeping a less-than-capable /bin/sh as the default (it was one of
>the few statically linked binaries in solaris, so recovery can be done
>in the miniroot. These days, in solaris 10 there's a /bin/bash.
>Other unix vendors have variations on this theme.
>
>Most of the bash syntax and idioms that people use are actually from
>ksh (~, $(), ${parameter:-word}, more complex parameter expansion like
>${parameter:=word}, command-line editing, aliases, etc.) but ksh also
>does a lot of things more consistently. Some examples are that many
>/bin/sh implementations don't work properly with [ -z $var ] (test is
>not a built-in, so this usage fails, and then you have to rely on the
>features of the platform-specific test(1)) leading to the ugly but
>necessary idiom of [ "x" != "x$VAR" ] you may have seen, etc.
>
>Anyway, currently if you code for bash, maybe you can look for bash in
>configure and m4/auto* put it in the #! line explicitly so that osql
>will work properly on different *nix's with less work.
>
>-Peter
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page