?
Solved

Sybase Connection Problem

Posted on 2004-09-24
8
Medium Priority
?
573 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
[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
  • 3
  • 2
8 Comments
 
LVL 6

Accepted Solution

by:
ChrisKing earned 500 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 ?
0
 
LVL 19

Assisted Solution

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

Expert Comment

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

Bill
0
 
LVL 6

Expert Comment

by:ChrisKing
ID: 12543271
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
ID: 12594157
Objection: 2 suitable answers have been given and the question has been abandoned by the asker this should not be deleted
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

What's worse than having your data encrypted by ransomware? Getting attacked by a so-called "wiper," which simply destroys the data and offers you no hope of ever seeing it again.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

764 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