Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

change the content of interfaces file

983 views
Skip to first unread message

Peter Yu

unread,
Dec 9, 2004, 8:45:08 PM12/9/04
to
Hi!

If I need to change the connection port to SYBASE server, what and which
file should I change?

And if I need to change server name, what and which file should I change?

Thanks!


Peter


FlyBean

unread,
Dec 9, 2004, 8:52:30 PM12/9/04
to
%SYBASE%\ini in Windows platform
$SYBASE/ini in Unix/Linux platform

sql.ini

You can edit it directly.

Peter Yu

unread,
Dec 9, 2004, 9:58:00 PM12/9/04
to
I can't find sql.ini on Unix platform. Is it *interfaces* file?
And after modifying that file, should I restart Sybase server?
Anything else?


"FlyBean" <fly...@freecoder.org> ??? news:41b9015a$1@forums-2-dub ???...

FlyBean

unread,
Dec 9, 2004, 10:19:20 PM12/9/04
to
Oh, sorry. I do forget the interface file under UNIX. Please check your
$SYBASE/ini directory. There is a text file containing like the following:
[server1]
master=tcp,host,port
query=tcp,host,port

You can use the GUI : DSEDIT Utility to do this job.

It's better to restart the ASE after you modify the interface file.
Otherwise the client should not connect to the new service. And you also
should modify the configures of the clients which connects to the ASE.

ktlou

unread,
Dec 9, 2004, 10:28:56 PM12/9/04
to
Hi Peter,

For AIX and SUN
You could locate "interfaces" file from SYBASE home for
ASE server port configuration file.

KTLOU

unread,
Dec 9, 2004, 10:33:01 PM12/9/04
to

The configuration file :
$SYBASE/interfaces....

Bret Halford

unread,
Dec 10, 2004, 9:06:54 AM12/10/04
to

Peter Yu wrote:
>
> I can't find sql.ini on Unix platform. Is it *interfaces* file?
> And after modifying that file, should I restart Sybase server?
> Anything else?
>

To change the port, that file is all you need to change, restart
is necessary.

If you want to change the server name,
You will also need to modify the RUN_<SERVERNAME> with the new
server name in the -S parameter of the dataserver command.
You might also want to change the name of the RUN_<SERVERNAME>
file to avoid confusion. If you are using remote servers,
you will need to update the server name in the sysservers
table for all affected servers.

Peter Yu

unread,
Dec 13, 2004, 12:46:08 AM12/13/04
to
Thank you very much!

"Bret Halford" <br...@sybase.com> ??? news:41B9AD78...@sybase.com
???...

0 new messages