Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Alternative to TLI in interfaces?

3 posts in Unix Last posting was on 2001-04-18 21:21:22.0Z
Robert Gumpertz Posted on 2001-04-17 21:58:51.0Z
Message-ID: <3ADCBC9B.36DB6C21@examen.com>
Date: Tue, 17 Apr 2001 14:58:51 -0700
From: Robert Gumpertz <robertg@examen.com>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Alternative to TLI in interfaces?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 14
NNTP-Posting-Host: inferno.examen.com 208.147.70.129
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:596
Article PK: 1092686

Greetings:
We're going to be doing some frequent re-arranging of our TCP/IP network
over the next few weeks, and would like to be able to use DNS lookup on
a hostname in the interfaces file so that address switches will be
transparent to the dataservers. Platform is ASE 12.0.1 on Solaris 2.6.
Does anybody know if Sybase 12 supports anything other than TLI format
in the in Unix interfaces file? I have a vague recollection of seeing a
posting on this in another group ages ago.
Thanx,
-Bob Gumpertz


Sherlock, Kevin Posted on 2001-04-18 20:53:04.0Z
Message-ID: <3ADDFE93.FD0BA3AA@denims01.dex.uswest.com>
Date: Wed, 18 Apr 2001 15:53:04 -0500
From: "Sherlock, Kevin" <ksherlo@denims01.dex.uswest.com>
Reply-To: ksherlo@qwest.com
Organization: QWEST DEX
X-Mailer: Mozilla 4.76 (Macintosh; U; PPC)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Subject: Re: Alternative to TLI in interfaces?
References: <3ADCBC9B.36DB6C21@examen.com>
Content-Type: multipart/mixed; boundary="------------BB8054CC460D30E88D0C1F97"
Newsgroups: sybase.public.sqlserver.unix
Lines: 60
NNTP-Posting-Host: np-10.dex.uswest.com 199.168.39.10
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:592
Article PK: 1092682


Robert Gumpertz wrote:
>
> Greetings:
> We're going to be doing some frequent re-arranging of our TCP/IP network
> over the next few weeks, and would like to be able to use DNS lookup on
> a hostname in the interfaces file so that address switches will be
> transparent to the dataservers. Platform is ASE 12.0.1 on Solaris 2.6.
> Does anybody know if Sybase 12 supports anything other than TLI format
> in the in Unix interfaces file? I have a vague recollection of seeing a
> posting on this in another group ages ago.
> Thanx,
> -Bob Gumpertz

Here is a response that I gave on this topic some time ago in
sybase.public.sqlserver.administration under the subject "tli in
interfaces file"

---------------------------------------

TLI on solaris involves the default practice of hardcoding the host ip
and port address as a hex string in the solaris interfaces file.

There is nothing keeping that from being changed to use the tcp driver
for DCL in 11.5.x and 11.9.x as follows (for example):

YOUR_SERVER_NAME
<tab>master tli tcp yourdnshostname portnumber
<tab>query tli tcp yourdnshostname portnumber

This should work for any product that uses open server 11.5 and above.
Keep in mind that the old open client (isql, etc, v10 and below, which
you should have upgraded from by now) will not be able to read such an
entry. In any case, note the use of DNS now instead of hard-coded ip addresses.

TLI is an outdated technology employed when it was the only thing
around. I don't particularly know why it has held over as the default
for these versions of ASE, but it has.


Download VCard ksherlo.vcf


Robert Gumpertz Posted on 2001-04-18 21:21:22.0Z
Message-ID: <3ADE0552.29C46B11@examen.com>
Date: Wed, 18 Apr 2001 14:21:22 -0700
From: Robert Gumpertz <robertg@examen.com>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Alternative to TLI in interfaces?
References: <3ADCBC9B.36DB6C21@examen.com> <3ADDFE93.FD0BA3AA@denims01.dex.uswest.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.unix
Lines: 52
NNTP-Posting-Host: inferno.examen.com 208.147.70.129
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.unix:591
Article PK: 1092681

Many thanks for the re-post, Kevin, you've solved our problem.
-bob g

"Sherlock, Kevin" wrote:

> Robert Gumpertz wrote:
> >
> > Greetings:
> > We're going to be doing some frequent re-arranging of our TCP/IP network
> > over the next few weeks, and would like to be able to use DNS lookup on
> > a hostname in the interfaces file so that address switches will be
> > transparent to the dataservers. Platform is ASE 12.0.1 on Solaris 2.6.
> > Does anybody know if Sybase 12 supports anything other than TLI format
> > in the in Unix interfaces file? I have a vague recollection of seeing a
> > posting on this in another group ages ago.
> > Thanx,
> > -Bob Gumpertz
>
> Here is a response that I gave on this topic some time ago in
> sybase.public.sqlserver.administration under the subject "tli in
> interfaces file"
>
> ---------------------------------------
>
> TLI on solaris involves the default practice of hardcoding the host ip
> and port address as a hex string in the solaris interfaces file.
>
> There is nothing keeping that from being changed to use the tcp driver
> for DCL in 11.5.x and 11.9.x as follows (for example):
>
> YOUR_SERVER_NAME
> <tab>master tli tcp yourdnshostname portnumber
> <tab>query tli tcp yourdnshostname portnumber
>
> This should work for any product that uses open server 11.5 and above.
> Keep in mind that the old open client (isql, etc, v10 and below, which
> you should have upgraded from by now) will not be able to read such an
> entry. In any case, note the use of DNS now instead of hard-coded ip addresses.
>
> TLI is an outdated technology employed when it was the only thing
> around. I don't particularly know why it has held over as the default
> for these versions of ASE, but it has.
>
> ------------------------------------------------------------------------
> Name: ksherlo.vcf
> ksherlo.vcf Type: VCard (text/x-vcard)
> Encoding: 7bit
> Description: Card for Sherlock, Kevin