?
Solved

Remote connection to Sybase ASE

Posted on 2000-04-04
7
Medium Priority
?
860 Views
Last Modified: 2012-05-04
I am running Sybase ASE on Linux, and I can't connect to it from another computer. I can connect locally, but it seems like it isn't listening to the network on the designated port. Is there something I need to configure in the system tables to make it listen to processes coming in over the network?
0
Comment
Question by:4tires
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 2

Expert Comment

by:jkotek
ID: 2686750
Look for the interfaces file if you use 'localhost' entry for the hostname - you have to use the 'real' hostname of your machine, otherwise the ASE would listen on IP 127.0.0.1 .

The other point is that some Linux distributions try to resolve the client IP to a hostname and they disconnect him if they won't succeed. It is also possible to denny access to Linux server from specific subnet/host - look in /etc/hosts.allow and /etc/hosts.deny .
0
 

Author Comment

by:4tires
ID: 2687886
The server that I'm trying to connect to is listed in the hosts.allow file and there is nothing in the hosts.deny file.I changed the interfaces file to the ip address, and when I try to telnet to that port from another machine it still says telnet: Unable to connect to remote host: Connection refused.
0
 
LVL 2

Expert Comment

by:jkotek
ID: 2689072
Well, lets say the ASE is running on lin-ase server and you are trying to connect to this server from lin-cli machine.

You should have 'lin-cli' entry in hosts.allow file on lin-ase server. I would also add 'lin-cli' entry into /etc/hosts file.

Btw can you ping from lin-cli to lin-ase? And can you connect from lin-cli to lin-ase using telnet?
0
Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

 

Author Comment

by:4tires
ID: 2691378
I can ping the server from the client, and I can also telnet to the server from the client. It is like everything is running fine except that the server does not service any requests on the specified port. It is like the server is not listening to that port. For example: I can telnet to the webserver port, and the telnet port, but if I try to telnet to the ASE port there is no answer.
0
 

Author Comment

by:4tires
ID: 2702182
Adjusted points from 100 to 200
0
 
LVL 1

Accepted Solution

by:
albertsp earned 600 total points
ID: 2703943
I don't know what portnumber you are using but you can change it to another one by editing your interfaces file. Do not forget to restart Sybase.

Look for free ports in the /etc/services

Remember that you also need this interfaces file on the client side. This file must be in your $SYBASE directory.
0
 

Author Comment

by:4tires
ID: 2705541
The answer: In the interfaces file, make sure that the ip address and port number are specified instead of the local servername and port number, and then restart your Sybase adaptive server.
0

Featured Post

Get MySQL database support online, now!

At Percona’s web store you can order your MySQL database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is a fine trick which I've found useful many times, when you just don't want to accidentally run a batch script or the commands needs administrator rights.
Active Directory can easily get cluttered with unused service, user and computer accounts. In this article, I will show you the way I like to implement ADCleanup..
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question