[Gllug] Sybase woes

[Panos Archondakis]

The file you need is called "interfaces" on Unix / Linux, and is called
"sql.ini" on Windows platforms. The format of the file is significant -
the lines that are indented must begin with tabs, not multiple spaces.
Sample entry below:

SQL_KAHLUA
	master tcp ether kahlua 5000
	query tcp ether kahlua 5000

In this example, the listener is on host "kahlua", on port "5000".

The file can be edited by hand, as long as you keep the format, but the
tools provided to edit the file are dsedit (GUI tool for X or MSWindows)
or dscp (command line). All Sybase software require the $SYBASE variable
to be set; the interfaces / sql.ini file is located by the client
libraries relative to the $SYBASE location (unless it is specified
explicitly when the command is invoked).

See the Sybase documentation for more details - a lot of stuff can be
specified in this file.

Hope this helps.

Panos



On Mon, 2004-01-26 at 16:58, Bruce Richardson wrote:
> On Mon, Jan 26, 2004 at 03:36:26PM +0000, will wrote:
> > Rev Simon Rumble wrote:
> > >This one time, at band camp, will wrote:
> > >
> > >>CT-LIBRARY error:
> > >>       ct_connect(): directory service layer: internal directory 
> > >>control layer error: Requested server name not found.
> > >
> > >I know nothing about Sybase but I do know that Oracle has its own name
> > >service system, seperate from DNS and other methods of resolution for
> > >a name.  Perhaps Sybase has a similar thing?
> > 
> > Don't know.  The developer basically set up the new server connection 
> > the same as the working one, with the IP address as the hostname.
> > 
> > Unfortunatly I know zip about sybase, but now have to support it...
> 
> The sybase libraries normally want an interfaces file, containing the
> details of any servers that you want to connect to.  A little googling
> on that file ("interfaces" is its name, iirc) may help.

-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug