Sybase Connection Problem

Posted on 2004-09-24
Last Modified: 2012-05-05

I have a server with redhat 7.1 and sybase 12.5 and have this error
 Msg 7207, Level 17, State 3:
Server 'srv_prd', Procedure 'xp_cmdshell', Line 2:
Can't open a connection to site 'SRV_PRD_XP' because there are no remote
connections available. Rerun when there are fewer remote users and/or fewer
local users making remote accesses, or contact a user with System Administrator
(SA) role.
Msg 7205, Level 18, State 3:
Server 'srv_prd', Procedure 'xp_cmdshell', Line 2:
Can't open a connection to site 'SRV_PRD_XP'.  See the error log file in the SQL
Server boot directory.

Can helpme ?


PD: sorry, mi english is bad :-(

Question by:caquevedo
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
  • 3
  • 2

Accepted Solution

ChrisKing earned 125 total points
ID: 12148945
Is the XP server (SRV_PRD_XP) running on the linux box ?
Is the SRV_PRD_XP server defined in $SYBASE/interfaces on the linux box ?
LVL 19

Assisted Solution

grant300 earned 125 total points
ID: 12151155
Check the server configuration setting for number of remote connections.
LVL 19

Expert Comment

ID: 12540587
Well, I guess that is O.K. except that I sent the guy to exactly the spot he needed to go to fix the problems


Expert Comment

ID: 12543271
I object, Venabili has no Sybase experience and is not qualified to be a CV in this TA

Expert Comment

ID: 12594157
Objection: 2 suitable answers have been given and the question has been abandoned by the asker this should not be deleted

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor ( Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

695 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