Solved

Sybase Connection Problem

Posted on 2004-09-24
8
520 Views
Last Modified: 2012-05-05
Hi,

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 ?

Marco.


PD: sorry, mi english is bad :-(

0
Comment
Question by:caquevedo
  • 3
  • 2
8 Comments
 
LVL 6

Accepted Solution

by:
ChrisKing earned 125 total points
Comment Utility
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 ?
0
 
LVL 19

Assisted Solution

by:grant300
grant300 earned 125 total points
Comment Utility
Check the server configuration setting for number of remote connections.
0
 
LVL 19

Expert Comment

by:grant300
Comment Utility
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

Bill
0
 
LVL 6

Expert Comment

by:ChrisKing
Comment Utility
I object, Venabili has no Sybase experience and is not qualified to be a CV in this TA
0
 
LVL 6

Expert Comment

by:ChrisKing
Comment Utility
Objection: 2 suitable answers have been given and the question has been abandoned by the asker this should not be deleted
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Marketing can be an uncomfortable undertaking, especially if your material is technology based. Luckily, we’ve compiled some simple and (relatively) painless tips to put an end to your trepidation and start your path to success.
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now