FreeTDS Development Group

["Young Lee" <young AT dolphinsearch.com>]

You may not have LD_LIBRARY_PATH and SYBASE varialbes set.


SYBASE=/usr/local/freetds
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$SYBASE/lib
export SYBASE LD_LIBRARY_PATH

HTH

> I wish I have the same luck. My connection still not working
> I have check and re check but no connection.
> It always said:
> [root@Centrax unittests]# ./t0001
> t0001.c: Testing login, logout
> connect: Network is unreachable
> tds_connect() failed
> try_tds_login() failed
> 
> Any other option, I am trying to connect to Win2k with MS SQL 7.0
> 
> Thanks
> Leon
> 
> > -----Original Message-----
> > From: bounce-freetds-121815 AT franklin.oit.unc.edu
> > [mailto:bounce-freetds-121815 AT franklin.oit.unc.edu]On Behalf Of Young
> > Lee
> > Sent: Friday, December 01, 2000 9:29 AM
> > To: TDS Development Group
> > Subject: [freetds] RE: newbie question. make check and all failed
> >
> >
> > Thank you guys. Problem solved.
> > I got an email from Alexander Grebennikov, algr AT rocc.ru.
> >
> > Here's what he suggested to sovle the problem.
> > "> As u typed in PWD :
> > > SRV=ODBC
> > >
> > > then  u must describe this SRV in interfaces file with the same
> > name ( e.g.
> > > ODBC)
> > > But u described it with name 'taz'
> > >
> > > When TDS seeing SRV=ODBC in your PWD file, it tries to search
> > this string in
> > > /usr/local/freetds/interfaces"
> >
> > After I changed the SRV entry in PWD file to match the one in
> > /usr/local/freetds/interace as Mr. Alexandar and Mr. James suggested, it
> > worked.
> >
> >
> >
> > > Leon & Young,
> > >
> > > I don't know precisely how FreeTDS reads the interfaces file,
> > but I can help with
> > > what it's supposed to look like.
> > >
> > > Short answers:
> > > *    You probably don't need a "master" line; it's used by the server.
> > > *    The third field should be "tcp" but I doubt FreeTDS cares.
> > > *    The second field should be the hostname of the machine the
> > server is on, and
> > > should match the SRV entry in the PWD file.  (Young, is your
> > server called "ODBC" or
> > > "taz" or something else?)
> > >
> > > The Long Answer can be found at:
> > >
> > >
> > http://manuals.sybase.com:80/onlinebooks/group-cn/cng1110e/u_confi
> > g/@ebt-link;pt=4114?target=%25N%14_5178_START_RESTART_N%25
> > >
> > > by looking for "interfaces format" (unquoted) on the main
> > Sybase page.  I've
> > > shortened it for the sake of the list.
> > >
> > > Hope this helps.
> > >
> > > --jkl
> > >
> > > =======- start Sybase manual text -=======
> > > SERVERNAME<newline>
> > > <tab>{master|query} protocol network host port<newline>
> > > <blank line>
> > > where:
> > >
> > > *     SERVERNAME is an alias by which Open Client and Open Server
> > >        recognize which interfaces entry to read. SERVERNAME must begin
> > >        with a letter (ASCII a-z, A-Z), contain letters, numbers, and
> > >        underscores only, and have a maximum of 11 characters.
> > > *       "master|query" specifies the type of connection:
> > >               "master" specifies a master line, which is used by server
> > >               applications to listen for client queries.
> > >               "query" specifies a query line, which is used by client
> > >               applications to find servers.
> > >
> > >        The master line and the query line of an interfaces entry contain
> > >        identical information. dscp creates both types of lines
> > for each entry.
> > >        The resulting entry can be used by both clients and servers.
> > >
> > >        protocol is the name of the network protocol. The valid
> > values are:
> > >               "tcp" for TCP/IP - All UNIX platforms
> > >               "spx" for IPX/SPX - UnixWare
> > >               "decnet" for DECnet - Digital UNIX
> > >
> > >        network is a descriptor of the network.
> > >
> > >        Open Client and Open Server do not currently use network; it is a
> > >        placeholder should Sybase need to define this information in the
> > >        future.
> > >
> > >        host is the network name of the node, or machine, that
> > the server is
> > >        running on. The maximum number of characters for host depends on
> > >        the protocol specified in the entry:
> > >               For TCP/IP the maximum is 32.
> > >
> > >        Use the /bin/hostname command to determine the network name of
> > >        the machine you are logged into.
> > >
> > >        port is the port used by the server to receive queries.
> > The TCP/IP and
> > >        DECnet protocols specify this element differently:
> > >               TCP/IP: Valid port numbers range from 1025 to 65535.
> > >               However, the numbers 1025 to 7009, 9535 and 17007 are
> > >               registered port numbers and may already be in use on your
> > >               system.
> > > =======- end Sybase manual text -=======
> > >
> > > Leon Darmawangsa wrote:
> > >
> > > > Hi Young, I have the same problem,
> > > > the only difference is that is in my PWD and interface file
> > > >
> > > > Here's my PWD file content
> > > > UID=sa
> > > > PWD=xxxx
> > > > SRV=myServer
> > > > DB=tempdb
> > > >
> > > > Here's my interface file content
> > > > myServer
> > > >       query tcp tds4.2 192.168.2.18 1433
> > > >
> > > > I can't still connect to the database, I have both tried the ping
> > > > and telnet and everything look ok, but when I run the test.sh, it
> > > > still the same thing (network unreachable).
> > > >
> > > > Can somebody please tell me what is wrong with my interface file
> > > >
> > > > Thanks
> > > > Leon
> > > >
> > > > > -----Original Message-----
> > > > > From: bounce-freetds-121815 AT franklin.oit.unc.edu
> > > > > [mailto:bounce-freetds-121815 AT franklin.oit.unc.edu]On
> > Behalf Of Young
> > > > > Lee
> > > > > Sent: Thursday, November 30, 2000 4:29 PM
> > > > > To: TDS Development Group
> > > > > Subject: [freetds] newbie question. make check and all failed
> > > > >...
> > > > > Here's my PWD file content
> > > > > UID=sa
> > > > > PWD=
> > > > > SRV=ODBC
> > > > > DB=tempdb
> > > > >
> > > > > Here's my interface file content
> > > > > taz
> > > > >         query tcp tds4.2 192.168.2.18 1433
> >
> > ---
> > You are currently subscribed to freetds as: [leon AT totalnet.com]
> > To unsubscribe, forward this message to
> > $subst('Email.Unsub')
> >