[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