Winsock / telnet connection in MS-ACCESS

Hi, Looking for a example completed in MS-ACCESS for a simple telnet session. As an example, click a button on a form and access will login to a linux telnet session and record the characters it receives in a variable and display the transcript in a unbound field. Thanls James ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Sunday Jul 16, 2006 7:33:22 PM: Guys, This is my first time using RAC, and I am very impressed with the speed of reply and the quality of the responses. This been the case let me tell you what I planning to do. The examples and comments give assure me what you are providing will work, but I dont want to be worrying about special control characters from Linux systems etc. So let me explain a little further... I want to connect to a local server running a system call Asterisk. The connection is fully described at: http://www.voip-info.org/wiki/view/Asterisk+manager+API So the requirements for the telnet are: Requirement 1: ============== * Logon to a local IP and Port (5038) For the successfull bidder I will setup an Asterisk Box you can login to on the net. * When you login you get the following response: Asterisk Call Manager/1.0 * Then want to send the following Action: login Username: adm in Secret: amp111 Events: off *Note when you send a blank line you will receive the following: Response: Success Message: Authentication accepted * And that this basicly how it works. * So then if you send the following: ACTION: Command command: show version *Note when you send a blank line you will receive the following: Response: Follows Privilege: Command Asterisk SVN-branch-1.2-r14868 built by root @ [login to view URL] on a i686 running Linux on 2006-03-26 11:48:23 UTC --END COMMAND-- * I would like the code to grab the above and place it as the return of a function, using the "END COMMAND" as a delimiter * To test the function the following could be sent: ACTION: Command command: show version files *Note when you send a blank line you will receive the following: File Revision ---- -------- format_g729.c Revision: 7221 app_playback.c Revision: 7221 app_softhangup.c Revision: 7221 app_zapateller.c Revision: 7221 app_txfax.c Revision: app_sendtext.c Revision: 7221 app_setcidnum.c Revision: 7221 --END COMMAND-- * The test here is to make sure we are receiving the 's correctly * So even though this looks a little complicated, I dont think it is, really the function would be something like this: SendAsterisk(txtCMD) The function would: Open the port, send the txtCMD get all the text upto "--END COMMAND--" return it as the return of the function, and close the connection Requirement 2: ============== * Send the same login str ing as below Action: login Username: admin Secret: amp111 Events: off *Note when you send a blank line you will receive the following: Response: Success Message: Authentication accepted * From there on the system will send events as per: http://www.voip-info.org/wiki/view/asterisk+manager+events * Would like a function that would: * Login as above * Grab each "event from Asterisk" * Write the Event to table the fiels being -EventDate (now()) -Event (text after the 'Event:') -EventTxt (all the text, up until a blank line) * Wait for the next event * The function would basicly never stop I will provide a server acceable over the net I am also ok to do some of the testing, as the strings comming form the system, maybe a little trickey. Hope that helps Thanks James ## Platform MS-ACCESS