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 11:57:11 -0800


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')
>





Archive powered by MHonArc 2.6.24.

Top of Page