[freetds] freetds / IBM UniVerse
Perry Taylor
perryft at hotmail.com
Tue Jan 9 11:22:23 EST 2007
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
More information about the FreeTDS
mailing list