Thanks for all the support
@methyl-: I think you are still unclear with the structure.See i use Window 7 in windows Sql Server 2005 is installed and there is a separate server of Unix from which i log in into it through putty(telnet). Putty is installed into Window 7.
I think now you are clear
---------- Post updated at 01:54 AM ---------- Previous update was at 01:51 AM ----------
Hi Padow
If possible can you provide me the detailed structure how to do this all.
Thanks in advance
I have a requirement and below is the detail.
Create a shell script and needs to run in server "a".
Connect to teradata database server "b".
execute the .sql file from server "a"
Save the output of the query to a file in server "a"
Schedule this shell script to run every day for every 4... (1 Reply)
Hello aix community,
After scouring the internet to find a step by step process, I've exhausted my efforts. Although I have learned a lot which brings me to this forum. I'm totally new and hope to ask the right questions.
What is the easiest way to connect to a SQL server from aix?
... (2 Replies)
I am trying to establish connection with SQL server 2008 through ODBC on Linux. First step would be
1. How to verify if ODBC driver for SQL server is installed on Linux OS.
PLease let me know how to do it/ if there is any link which could be helpful in this context.
thanks in advance (1 Reply)
I need to connect sql server 2008 from korn shell script. Can you please give me the script which connects sql server 2008 from korn shell script. (2 Replies)
Hello All
I am getting a problem.What i want to do is to connect unix(korn shell) and sql server 2005. But it is not happening.
The task is to schedule a job using crown or something else that connect with sql server 2005 and run the query and save the result in a text file. (5 Replies)
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
I am using solaris-5.1 to run shell script and want to connect to SQL-5.1 which is installed on SantOS.
Kindly let... (3 Replies)
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script as below
1. To compare values of an array with SQL table's entry.
Kindly let me know on how to do this
Thanks,
Double post. Continue here (0 Replies)
Hi All,
Am porting my application from AIX to Windows. As a part of this I need to port the Database in IBM DB2 UDB to SQL Server 2005. Is there any Guide/Doc/Article available on this? How to convert the stored procedures and physical data from DB2 to SQL Server 2005?
Thanks in Advance (0 Replies)
Server(3pm) User Contributed Perl Documentation Server(3pm)NAME
Net::SMTP::Server - A native Perl SMTP Server implementation for Perl.
SYNOPSIS
use Carp;
use Net::SMTP::Server;
use Net::SMTP::Server::Client;
use Net::SMTP::Server::Relay;
$server = new Net::SMTP::Server('localhost', 25) ||
croak("Unable to handle client connection: $!
");
while($conn = $server->accept()) {
# We can perform all sorts of checks here for spammers, ACLs,
# and other useful stuff to check on a connection.
# Handle the client's connection and spawn off a new parser.
# This can/should be a fork() or a new thread,
# but for simplicity...
my $client = new Net::SMTP::Server::Client($conn) ||
croak("Unable to handle client connection: $!
");
# Process the client. This command will block until
# the connecting client completes the SMTP transaction.
$client->process || next;
# In this simple server, we're just relaying everything
# to a server. If a real server were implemented, you
# could save email to a file, or perform various other
# actions on it here.
my $relay = new Net::SMTP::Server::Relay($client->{FROM},
$client->{TO},
$client->{MSG});
}
DESCRIPTION
The Net::SMTP::Server module implements an RFC 821 compliant SMTP server, completely in Perl. It's extremely extensible, so adding in
things like spam filtering, or more advanced routing and handling features can be easily handled. An additional module,
Net::SMTP::Server::Relay has also been implemented as an example of just one application of this extensibility. See the pod for more
details on that module. This extension has been tested on both Unix and Win32 platforms.
Creating a new server is as trivial as:
$server = new Net::SMTP::Server($host, $port);
This creates a new SMTP::Server. Both $host and $port are optional, and default to the current hostname and the standard SMTP port(25).
However, if you run on a multi-homed machine, you may want to explicitly specify which interface to bind to.
The server loop should look something like this:
while($conn = $server->accept()) {
my $client = new Net::SMTP::Server::Client($conn) ||
croak("Unable to handle client connection: $!
");
$client->process;
}
The server will continue to accept connections forever. Once we have a connection, we create a new Net::SMTP::Server::Client. This is a
new client connection that will now be handled. The reason why processing doesn't begin here is to allow for any extensibility or hooks a
user may want to add in after we've accepted the client connection, but before we give the initial welcome message to the client. Once
we're ready to process an SMTP session, we call $client->process. This may HANG while the SMTP transaction takes place, as the client and
server are communicating back and forth (and if there's a lot of data to transmit, well...).
Once $client->process returns, various fields have been filled in. Those are:
$client->{TO} -- This is an array containing the intended
recipients for this message. There may be
multiple recipients for any given message.
$client->{FROM} -- This is the sender of the given message.
$client->{MSG} -- The actual message data. :)
The SMTP::Server module performs no other processing for the user. It's meant to give you the building blocks of an extensible SMTP server
implementation. For example, using the MIME modules, you can easily process $client->{MSG} to handle MIME attachments, etc. Or you could
implement ACLs to control who can connect to the server, or what actions are taken. Finally, a suggested use that the author himself uses,
is as an SMTP relay. There are lots of times I need access to an SMTP server just to send a message, but don't have access to one for
whatever reason (firewalls, permissions, etc). You can run your own SMTP server whether under Unix or Win32 environments, and simply point
your favorite mail client to it when sending messages. See the Net::SMTP::Server::Relay modules for details on that use.
AUTHOR AND COPYRIGHT Net::SMTP::Server / SMTP::Server is Copyright(C) 1999, MacGyver (aka Habeeb J. Dihu) <macgyver@tos.net>. ALL RIGHTS
RESERVED.
You may distribute this package under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
SEE ALSO
Net::SMTP::Server::Client, Net::SMTP::Server::Relay
perl v5.10.1 1999-12-28 Server(3pm)