FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

Perry Taylor wrote:
> >From: "Lowden, James K" 
> > > From: Perry Taylor
> > >
> > > $ /usr/local/freetds/bin/osql -S SQL1 -U userid -P password
> > > odbc.ini and odbcinst.ini should be in /lib/ld-linux.so.2 looking
> > > for DSN [SQL1] in /home/perryt/.odbc.ini
> > >    found DSN [SQL1] in /home/perryt/.odbc.ini
> > > [SQL1] not found in "/home/perryt/.odbc.ini" looking for DSN [SQL1]
> > > in /lib/ld-linux.so.2/odbc.ini
> > >      cannot read "/lib/ld-linux.so.2/odbc.ini"
> > > osql: error: unable to locate SQL1 in any odbc.ini
> > >
> >The script uses a heuristic to determine the directory name.  What does
> >this say on your machine?
> >
> >     $ ISQL=$(command -v isql)
> >     $ strings ${ISQL} | grep ^/ | grep -v elf
> >     /usr/local/lib
> >
> Here's what I get...
> 
> $ ISQL=$(command -v isql)
> $ strings ${ISQL} | grep ^/ | grep -v elf
> /lib/ld-linux.so.2
> /usr/local/lib

I just committed a slightly smarter osql that should work on your machine.
 Look for revision 1.4 in CVS.  You don't need a snapshot tarball; you can
just fetch that one script from SourceForge.  

I don't know that osql will help fix anthing on your machine (although it
might) but thank you for your help in making it more useful.  

--jkl