FreeTDS Development Group

["Perry Taylor" <perryft AT hotmail.com>]

I definitely got further with osql v1.4. Does this shed any light on my 
problem?

# ./osql -S SQL1 -U userid -P password
looking for odbc.ini and odbcinst.ini in /usr/local/etc
looking for DSN [SQL1] in /root/.odbc.ini
     found DSN [SQL1] in /root/.odbc.ini
[SQL1] not found in "/root/.odbc.ini"
looking for DSN [SQL1] in /usr/local/etc/odbc.ini
     found DSN [SQL1] in /usr/local/etc/odbc.ini
found this section:
       [SQL1]
       Driver          = /usr/local/freetds/lib/libodbc.so
       Description     = sql1 cueball database
       #Servername     = SQL1
       Database        = cueball
       Server          = devsql1
       Port            = 1433
       TDS_Version     = 8.0

looking for driver for DSN [SQL1]
driver "/usr/local/freetds/lib/libodbc.so" found for [SQL1] in odbc.ini
found driver named "/usr/local/freetds/lib/libodbc.so"
basename: too few arguments
Try `basename --help' for more information.
driver "/usr/local/freetds/lib/libodbc.so" found for [] in
/usr/local/freetds/lib/libodbc.so is a readable file
"Server" found, not using freetds.conf
FreeTDS servername is "devsql1"
devsql1 has address 192.168.16.5

                          DSN: SQL1
            Server's hostname: devsql1
                      Address: 192.168.16.5
                       Driver: /usr/local/freetds/lib/libodbc.so

Attempting connection as userid...
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

Thanks.

Perry

> From: "James K. Lowden" <jklowden AT freetds.org>
> Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
> Subject: Re: [freetds] freetds / IBM UniVerse
> Date: Sat, 6 Jan 2007 10:43:21 -0500
>
> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

_________________________________________________________________
Fixing up the home? Live Search can help 
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=en-US&source=hmemailtaglinenov06&FORM=WLMTAG