Skip to Content.
Sympa Menu

freetds - Re: [freetds] freetds / IBM UniVerse

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Perry Taylor" <perryft AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] freetds / IBM UniVerse
  • Date: Tue, 09 Jan 2007 09:22:23 -0700

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





Archive powered by MHonArc 2.6.24.

Top of Page