Skip to Content.
Sympa Menu

freetds - RE: newbie question. make check and all failed

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Leon Darmawangsa" <leon AT totalnet.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: newbie question. make check and all failed
  • Date: Fri, 1 Dec 2000 14:24:34 -0800


Thanks Young, that is it. Now I can connect to my SQL Server.

Thanks a bunch
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 2:11 PM
> To: TDS Development Group
> Subject: [freetds] RE: newbie question. make check and all failed
>
>
> 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')
> > >
>
> ---
> You are currently subscribed to freetds as: [leon AT totalnet.com]
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>





Archive powered by MHonArc 2.6.24.

Top of Page