February 5, 2011 at 7:24 am
Hi,
I want to send and recevie the data through telent using sql query, can any one help me.As when i am running the below coomand like
exec master.dbo.xp_cmdshell 'Ping localhost' i get the reply
when i run
exec master.dbo.xp_cmdshell 'ipconfig /all' i get the ip details
but when i run exec master..xp_cmdshell 'telnet localhost 25' i get output as NULL and when i run telnet coomand through coomand prompt i get the results.
February 5, 2011 at 9:45 am
You cannot run an interactive command using xp_cmdshell. An interactive command requires someone to have access to the machine where the command is being run to interact with command window.
Since this will be run in the background there is no way to interact with the command.
If you tell us what you are trying to accomplish, someone here can probably come up with a way to solve this problem without having to use xp_cmdshell.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 5, 2011 at 11:28 pm
I had got a project in which there is a phyical hardware to which the ip wil be assigned and it will communicating with server where sql in installed and it will work on certain defined ports.
my job is to connect through telnet from sql server to that hardware and sql will be sending some data to that ip on defined port & if coomunication is through then hardware will send me the acknowlegement and based on acknowlegement recevied i will do certain further process in my database.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply