Solved

Sybase Connection Problem

Posted on 2004-09-24
8
555 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
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 125 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

Read the original post on Monitis Blog. Believe it or not, the most important thing about the website of your business is not what’s on it but how fast it loads. Yes, that’s right!    As you can see on this infographic (an oldie but goodie!), …
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

730 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